Menu

#19 [patch]xls2csv quoting

open
nobody
None
5
2009-05-19
2009-05-19
No

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

Discussion

  • Lukasz Szybalski

    xls2csv patch for proper quoting

     
  • Lukasz Szybalski

    • summary: xls2csv quoting --> [patch]xls2csv quoting
     

Log in to post a comment.