擅长:python、mysql、java
<p>似乎您可以为Python使用<a href="http://sourceforge.net/projects/pywin32/" rel="nofollow">pywin32</a>库。我重写了代码,但不确定<code>TextFileTextQualifier</code>的值。您可以通过运行VB脚本来查看它的值(和其他变量)。在</p>
<pre><code>import win32com.client
excel = win32com.client.Dispatch("Excel.Application")
ws = excel.Workbooks.Add().Worksheets(1)
qtNew = ws.QueryTables.Add( "TEXT;C:\\DRIVE D\\graphme\\result.txt", ws.Range("A1"))
qtNew.TextFilePlatform = 866
qtNew.TextFileStartRow = 1
qtNew.TextFileParseType = 1
qtNew.TextFileTextQualifier = 1
qtNew.TextFileConsecutiveDelimiter = False
qtNew.TextFileTabDelimiter = True
qtNew.TextFileSemicolonDelimiter = False
qtNew.TextFileCommaDelimiter = False
qtNew.TextFileSpaceDelimiter = False
qtNew.TextFileColumnDataTypes = [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1]
qtNew.TextFileTrailingMinusNumbers = True
qtNew.Refresh()
</code></pre>