xlsjs: “Error: Unrecognized ExtProp type: 2 0”?

xlsjs

While working on ETL (Extract, Transform, Load) projects at work, I ran into an unusual issue using xlsjs:

Error: Unrecognized ExtProp type: 2 0

After digging through the xlsjs source code, I realized that it was following the MS-XLS Specifications, as it should, and section 2.5.108 ExtProp, the extType value that I was running into was not defined in the table. Seeing as the format structure was related to formatting, I forked the xlsjs library and created a version that was more forgiving.

If you are running into this issue and want a workaround, try xlsjs2.

React: react-router and dynamic page title

I have been learning React for the past few weeks, and I am loving it. I spent today learning react-router at https://github.com/reactjs/react-router-tutorial. After going through it and implementing a lot of it in my app, I realized that it did not cover one thing that I really need: dynamic page title.

I have googled and looked at different examples of how others have done it (e.g. react-document-title, document.title) but I finally decided to tinker on my own and see if I can come up with my own implementation. (I know… another one???)

My sample code will be added to the result of lesson 3 from the tutorial I linked above:

App.js:

index.js:

Looking at index.js, I thought why not add a title attribute on the Route nodes directly? That would be the most convenient location, in my mind.

index.js:

We added it to routing, but how will App get its value? This part is easy.

App.jsx:

That’s it.

Data scraping: how to prevent

Data scraping is common these days with so many data driven web applications out there. Regardless of the legality and ethics of the subject, it just sucks to know that there may be people out there who might hammer at your site to “take” all your hard work for their selfish use. That being said, it’s almost impossible to prevent people from taking your data, especially if your data is easily accessible by the public.

You’re probably here because you’re suspicious of possible data scraping activities happening in your website. While there are preventive measures you can take to keep the scrapers out, there are always holes for the smart ones to get through and eventually take the data they want. What we want to do is make it very difficult for the average scraper to hack away the data.
Continue reading “Data scraping: how to prevent”