使用Python将文本文件插入现有xlsx

Question

我有一个包含11个工作表的.xlsx文件，我需要从第3行开始插入文本文件的内容（tab delim，大约30列，100行）。我尝试了下面的代码，但最终出现了错误。（使用bash/Linux）

#!/usr/bin/env python

import csv
from openpyxl.reader.excel import load_workbook
from xlrd import open_workbook
from xlutils import copy as xl_copy


with open('S12_final.txt') as tab_file: #open tab text file
    tab_reader = csv.reader(tab_file, delimiter='\t')
    xls_readable_book = load_workbook('S12.xlsx') #load workbook
    xls_writeable_book = xl_copy.copy(xls_readable_book)
    xls_writeable_sheet = xls_writeable_book.get_sheet_by_name('Filtered') #write data on this sheet
    for row_index, row in enumerate(tab_reader):
        xls_writeable_sheet.write(row_index, 0, row[0])
        xls_writeable_sheet.write(row_index, 1, row[1])
    xls_writeable_book.save('S12.xlsx') #save excel file

错误：

^{pr2}$

有什么建议吗？在

Answer 1

考虑这个openpyxl示例：

from openpyxl.workbook.workbook import Workbook # as _Workbook
import csv

wb = Workbook()
wb.create_sheet('Filtered')
ws = wb['Filtered']

with open('test/S12_final.csv') as tab_file:
    tab_reader = csv.reader(tab_file, delimiter='\t')

    # Skipt first 2 Lines
    [next(tab_reader) for skip in range(2)]

    # Append list(rowData) after Sheets last accessed Row
    for rowData in tab_reader:
        ws.append(rowData)

wb.save('test/S12.xlsx')

使用Python:3.4.2-openpyxl:2.4.1-LibreOffice:4.3.3.2测试