我的代码如下。
import csv
import openpyxl
import sys
def convert(input_path, output_path):
"""
Read a csv file (with no quoting), and save its contents in an excel file.
"""
wb = openpyxl.Workbook()
ws = wb.worksheets[0]
with open(input_path) as f:
reader = csv.reader(f, delimiter='\t', quoting=csv.QUOTE_NONE)
for row_index, row in enumerate(reader):
for col_index, value in enumerate(row):
ws.cell(row=row_index, column=col_index).value = value
wb.save(output_path)
def main():
try:
input_path, output_path = sys.argv[1:]
except ValueError:
print 'Usage: python %s input_path output_path' % (sys.argv[0],)
else:
convert(input_path, output_path)
if __name__ == '__main__':
main()
但我收到了这个错误。
Traceback (most recent call last):
File "txt2xlsx.py", line 33, in <module>
main()
File "txt2xlsx.py", line 29, in main
convert(input_path, output_path)
File "txt2xlsx.py", line 18, in convert
ws.cell(row=row_index, column=col_index).value = value
File "C:\python27\lib\site-packages\openpyxl\worksheet\worksheet.py", line 350, in cell
column = get_column_letter(column)
File "C:\python27\lib\site-packages\openpyxl\utils\__init__.py", line 100, in get_column_letter
raise ValueError("Invalid column index {0}".format(idx))
ValueError: Invalid column index 0
我想我已经正确安装了 openpyxl 。
我记得我以前使用这个程序没有任何问题。我最近买了一台新电脑,所以这可能是电脑配置问题。但我不明白。