Pywin32: How to import data into Excel?

Norbert Norbert.Klamann at klamann-software.de
Sun Nov 13 13:11:27 EST 2005


Simon Brunning wrote:
> On 08/11/05, Dmytro Lesnyak <Dmytro.Lesnyak at xtract.fi> wrote:
> > I need to import some big data into Excel from my Python script. I have TXT
> > file (~7,5 Mb).
>
> Have you considered converting your text data to CSV format? Excel
> opens CSV files happily enough, and you could always automate
> save-as-workbook and any formatting you need afterwards.

But there are thorny issues with different locales and number formats.
Excel is also just too clever in recognising dates

All the best

Norbert




More information about the Python-list mailing list