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
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
>
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
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