does not include trailing comma when last column is empty about xlsx2csv HOT 6 CLOSED

it works for me, please send me your xlsx file if it's possible

from xlsx2csv.

xlsx file: http://cl.ly/3i3I0o1s1W3j41452P07
output: https://gist.github.com/750235

from xlsx2csv.

i have fixed it, give it a try

from xlsx2csv.

Thanks for the quick fix. That works, with that file. Funnily, the actual file I'm trying to process has some empty fields in the first column as well, and sometimes it's adding an extra comma to the beginning instead of the end. I will create another sample xlsx (my real one has PII in it) and post again later.

from xlsx2csv.

Ok, here is a new xlsx.

There are 5 sheets and you can see the output from xlsx2csv.py for each of them in that same gist: https://gist.github.com/750235

I was trying to find the simplest example to recreate the bug, but as you can see from the output, it's... inconsistent.

I can work around it by moving the columns around in Excel. I'm just glad to have something to convert to csv since Excel really sucks at it.

from xlsx2csv.

try it again, it should work now

from xlsx2csv.