Categories
js nodejs Programming

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

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.