1. Is it possible to modify the example xls2csv.py to accept argv that
would have spreadsheet name? If blank leave it with the same functionality.
xls2csv myfile.xls 'Sheet1'
2. Attached you will find fix for encoding of special characters.
Example:
currently when encoding from xml the following line:
"ORG4296,A.N. BOWLING, MFG.,ftp://ftp.nhtsa.dot.gov/mfrmail/ORG4296.pdf"
should be(I think):
"ORG4296","A.N. BOWLING, MFG.","ftp://ftp.nhtsa.dot.gov/mfrmail/ORG4296.pdf"
I'm trying to convert this spreadsheet.
ftp://ftp.nhtsa.dot.gov/manufacture/Directory%20566apr.zip
Attached you will find a patch where I'm creating csv writer and adding a row.
csv writer does the encoding for me.
Could you tell me how to do #1, apply the fix for #2 and update the
file in your repository for the next release.?
3. In you free time would it be possible to mount a xls2csv as a program in a bin directory so that we could run it from a command line.
xls2csv somefile.xls
Thanks,
Lucas
xls2csv patch for proper quoting