擅长:python、mysql、java
<p>还有另一种可能。我得承认有点难看,但我测试成功了。在</p>
<p>您需要创建一个新类:</p>
<pre><code>class NewType():
def __init__(self, sValue=""):
self.strValue = sValue
def __str__(self):
return self.strValue
</code></pre>
<p>然后定义一个转换函数:</p>
^{pr2}$
<p>在您的函数(要读取_excel的位置)中,假设有28列要读取,请执行以下操作:</p>
<pre><code>import pandas as pd
converters = dict()
for i in range(0,28,1):
converters[i] = convert
dataframe = pd.read_excel(path_to_file, sheet_name, 0, None, 0, None, 27, False, None, "", None, False, None, converters)
dataframe = dataframe.transpose()
dataDict = dataframe.to_dict()
newDict= OrderedDict()
for dataLine in dataDict.values():
for field in dataLine.keys():
dataLine[field] = str(dataLine[field])
#do something with dataLine
</code></pre>
<p>最后你得到了与CSV.DictReader如果你把数据格式化成CSV格式</p>