Pywin32: How to import data into Excel?
Norbert.Klamann at klamann-software.de
Sun Nov 13 19:11:27 CET 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
More information about the Python-list