does not include trailing comma when last column is empty

[katylava]

given the headers A,B,C and data stuff,more stuff, [empty] the csv output doesn't not include a comma after "more stuff".

[dilshod]

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

[katylava]

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

[dilshod]

i have fixed it, give it a try

[katylava]

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.

[katylava]

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.

[dilshod]

try it again, it should work now