Pywin32: How to import data into Excel?

2005-11-08 Thread Dmytro Lesnyak
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      xlBook.Sheets(sheet_name).Cells(i,j).Value = value_fro

RE: Pywin32: How to import data into Excel?

2005-11-08 Thread Dmytro Lesnyak
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?

2005-11-08 Thread Dmytro Lesnyak
 >  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 will be 52 X 25000 table and it works fine in Excel (f.e. I need

RE: How to - import code not in current directory

2005-11-17 Thread Dmytro Lesnyak
Yes, you can. Try this: import sys sys.path.append('c:\some\other\directory\') import bar Good luck! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of py Sent: 17. marraskuuta 2005 15:19 To: python-list@python.org Subject: How to - import code not in cur