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.

Leave a Reply

Your email address will not be published. Required fields are marked *