Re: Pywin32: How to import data into Excel?

Simon Brunning wrote: On 08/11/05, Dmytro Lesnyak [EMAIL PROTECTED] 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

Pywin32: How to import data into Excel?

Hello, I need to import some big data into Excel from my Python script. I have TXT file (~7,5 Mb). Im using Pywin32 library for that, but if I first try to read the TXT file and then save the values one by one like xlBook.Sheets(sheet_name).Cells(i,j).Value = value_from_TXT_file it

RE: Pywin32: How to import data into Excel?

[Dmytro Lesnyak] I need to import some big data into Excel from my Python script. I have TXT file (~7,5 Mb). I'm using Pywin32 library for that, but if I first try to read the TXT file and then save the values one by one like xlBook.Sheets(sheet_name).Cells(i,j).Value =

Re: Pywin32: How to import data into Excel?

On 08/11/05, Dmytro Lesnyak [EMAIL PROTECTED] 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

RE: Pywin32: How to import data into Excel?

Thanks a lot. It really works! Now, I can solve my problem and make my script faster! A few suggestions: + When trying to automate anything in Excel, it's usually illuminating to record a macro which does what you want, and then to translate that VBA code into Python. Yes, I also

Re: Pywin32: How to import data into Excel?

On 11/8/05, Dmytro Lesnyak [EMAIL PROTECTED] wrote: Hello, I need to import some big data into Excel from my Python script. I have TXT file (~7,5 Mb). I'm using Pywin32 library for that, but if I first try to read the TXT file and then save the values one by one like I have to

RE: Pywin32: How to import data into Excel?

I have to question the reasoning behind using Excel. That much data seems like it would be troublesome to manage in Excel. How good is Excel at working with that much data? Well,It's not that big data. As result, It willbe 52 X 25000 table and it works fine in Excel (f.e. I need to make

RE: Pywin32: How to import data into Excel?

Tim Golden wrote: [Dmytro Lesnyak] I need to import some big data into Excel from my Python script. I have TXT file (~7,5 Mb). I'm using Pywin32 library for that, but if I first try to read the TXT file and then save the values one by one like xlBook.Sheets(sheet_name).Cells(i,j).Value =

RE: Pywin32: How to import data into Excel?

[Tim Golden] + When trying to automate anything in Excel, it's usually illuminating to record a macro which does what you want, and then to translate that VBA code into Python. [Duncan Booth] Another suggestion: when automating Excel, turn off the automatic recalculation (set

Re: Pywin32: How to import data into Excel?

PyXLWriter might be at your service: http://pyxlwriter.sourceforge.net/ Have a nice day, Marco -- http://mail.python.org/mailman/listinfo/python-list