CODEWITHSUNDEEP
pythonxlrd
Cacheing
Cacheing

Reputation: 3471

python xlrd: how to remove quotation marks when converting excel file to csv

I used this method xls to csv converter to convert excel files(xls and xlsx) to csv files. But when converting to csv files, it adds " " to each cell.

Now, my question is how to remove the quotation marks when converting.

Upvotes: 0

Views: 1124

Answers (1)

Peter DeGlopper
Peter DeGlopper

Reputation: 37319

Set the CSV writer's quoting argument to whichever of the csv module's quoting constants has the behavior you want.

http://docs.python.org/2/library/csv.html#csv.QUOTE_ALL

Upvotes: 2

Related Questions