<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=639365707-08112005>Hello,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=639365707-08112005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=639365707-08112005>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I need to import some big
data</SPAN><FONT face="Times New Roman" size=3> 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</FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3></FONT> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT
face="Times New Roman"><FONT size=3><SPAN
class=639365707-08112005>
</SPAN>xlBook.Sheets(sheet_name).Cells(i,j).Value =
value_from_TXT_file</FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT
face="Times New Roman"> <?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3>it takes about 10 hours to proce<SPAN class=639365707-08112005>ss</SPAN>
whole <SPAN class=639365707-08112005>data (and it's not acceptable in my
case)</SPAN>.</FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3>I just wonder if it’s possible to speed up the process. F.e. by using
</FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3></FONT> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT
face="Times New Roman"><FONT size=3><SPAN
class=639365707-08112005>
</SPAN>xlApp.Workbooks.OpenText() –function</FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3></FONT> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3>I was trying to do that, but I don’t have any documentation for th<SPAN
class=639365707-08112005>e</SPAN> function and it doesn’t work.</FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman"
size=3></FONT> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
class=639365707-08112005><FONT face="Times New Roman"
size=3>BR,</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
class=639365707-08112005><FONT face="Times New Roman"
size=3>Dima</FONT></SPAN></P></SPAN></FONT></DIV></BODY></HTML>