How to write data to excel file?

Question

I have some data that I would like to save in an excel file. How to do this in python?

Answer 1

There is a great python module called XLWT . I would recommend using this ... it writes native Excel files instead of CSV. Supports formulas, etc.

Documentation (borrowed from Mark)

Answer 2

I will answer a slightly different question: "How can I write data so that Excel can read it?"

Use the csv module to write your data as a CSV file, and then open it in Excel.

 import csv csvout = csv.writer(open("mydata.csv", "wb")) csvout.writerow(("Country", "Year")) for coutry, year in my_data_iterable(): csvout.writerow((country, year)) 

Answer 3

If you need a BIFF8 XLS file, I would use excellent xlwt .

Answer 4

if it works on Windows, try creating an instance of EXCEL.APPLICATION through COM

Use Excel Help to reference an object.

That way you can even format data, write formulas, etc.