search

DiegoZoracKy / convert-excel-to-json

Convert Excel to JSON, mapping sheet columns to object keys.
MIT License
287 stars 91 forks source link

When header is having comment it's not working #23

Open Dilipv500 opened 5 years ago

Dilipv500 commented 5 years ago

Code:- var excelToJson = require('convert-excel-to-json'); var result =await excelToJson({ sourceFile: 'data.xlsx', columnToKey: { '*': '{{columnHeader}}' } });

excelcommentissue

DiegoZoracKy commented 5 years ago

Hi @Dilipv500, can you explain better what went wrong? Did you get some error? Were the headers shown as letters? Posting the output here can be helpful.

Dilipv500 commented 5 years ago

when ever i tried to retrieve the data if the Excel File(Header consists of Cell comment) then the execution stops automatically.

without comments in Excel Cell Headers then it's working fine.

could you please tell me if anything i'm missing?