node-csvtojson icon indicating copy to clipboard operation
node-csvtojson copied to clipboard

Is it possible to have excel recognize column as text, and not a number?

Open davegri opened this issue 6 years ago • 1 comments

I'm currently exporting a column from javascript and converting it to a string. For some reason though excel parses it as a number and removes leading zeros if I try to edit the column. Is it possible to specify something that can fix this?

Thanks

davegri avatar Sep 26 '19 09:09 davegri

You can change the types of columns using built-in column parsers or checkType parameter.

https://github.com/Keyang/node-csvtojson#built-in-parsers

Keyang avatar Oct 04 '19 12:10 Keyang