Csv blank rows problem with Excel

I have a csv file which contains rows from a sqlite3 database. I wrote the rows to the csv file using python.

When I open the csv file with Ms Excel, a blank row appears below every row, but the file on notepad is fine(without any blanks).

Does anyone know why this is happenning and how I can fix it?

Edit: I used the strip() function for all the attributes before writing a row.

Thanks.

Answers


You're using open('file.csv', 'w')--try open('file.csv', 'wb').

The Python csv module requires output files be opened in binary mode.


Need Your Help

Controlling size of new window for external link

java html

I have a popup on my homepage, and I am happy with the size of that window...I have added a link on the homepage to direct to same popup, but it opens in a full size window. How do I get the linke...