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