python script .xls file

[colin1988]

Hi
I have a .csv file, how do I save it like .xls file using a python script?
It doesn't work if I just change the extention.

Can anyone help me?
Thx

[Irithori]

What is the purpose?
Calc/Excel can read or import csv files directly.

[colin1988]

I have to make 2 python scripts: one to make a .csv file (interogating a database- this is done) and one to make an excel file from this .csv file.
This will be used on a web interface (using django) to make 2 butons for a database:
1: save as .csv file
2. save as .xls file

My job is to do this script.

Thx for your help

[coopstah13]

xls is a binary proprietary format, and I don't think it will be a simple task to create a file of that type

here is a paid application SpreadScript: Use Perl, Python, or Tcl to Read and Write Microsoft Excel Spreadsheets on Linux and Solaris

I think you will need to do some heavy googling like "create xls linux" "create xls without excel" "create xls python" etc

[blinky]

Probably not what you have time for, but you could try openoffice running as a server process and Python bindings for UNO (see OpenOffice.org Developer's Guide - OpenOffice.org Wiki) - never tried it my self (have played with the java bindings).

[colin1988]

thx for u're help
I've managed to rezolv it, the long way:
1)save datas as .csv
2)covert from .csv to .xls
3)delete the .csv file

[Kloschüssel]

and how did you do the conversion?