将段落以“一个一个字”的方式放入表格

以下面截图中的段落为例：（案例中有三个段落）

使用如下代码，转化为每行15个字的表格，且段落开始处空两格（用-表示空格，后面可直接在word或者excel里面替换为无字符）。

# -*- coding: utf-8 -*-
"""
Created on Fri May 28 22:24:58 2021

@author: l2832
"""
import pandas as pd
data_org = pd.read_csv('xc.csv',encoding='gbk')
#print(data_org)
data_first = data_org['first'][0]
first_row = '--'+ data_first[:13]

Row = int(len(data_first[13:])/15)
middle_row = []
middle_row.append(first_row)
for i in range(Row):
    middle_row.append(data_first[13+(i*15):13+((i+1)*15)])
end_row = data_first[13+(Row*15):]+'-'*(15-(len(data_first[13+(Row*15):])))
middle_row.append(end_row)



data_first = data_org['second'][0]
first_row = '--'+ data_first[:13]

Row = int(len(data_first[13:])/15)
#middle_row = []
middle_row.append(first_row)
for i in range(Row):
    middle_row.append(data_first[13+(i*15):13+((i+1)*15)])
end_row = data_first[13+(Row*15):]+'-'*(15-(len(data_first[13+(Row*15):])))
middle_row.append(end_row)



data_first = data_org['third'][0]
first_row = '--'+ data_first[:13]

Row = int(len(data_first[13:])/15)
#middle_row = []
middle_row.append(first_row)
for i in range(Row):
    middle_row.append(data_first[13+(i*15):13+((i+1)*15)])
end_row = data_first[13+(Row*15):]+'-'*(15-(len(data_first[13+(Row*15):])))
middle_row.append(end_row)


#print(first_row)
print(middle_row)
#print(end_row)



# 一行一行写入excel里面
import xlwt
workbook = xlwt.Workbook(encoding = 'gbk')
worksheet = workbook.add_sheet('data')
for i in range(len(middle_row)):
    for j in range(len(middle_row[i])):
        worksheet.write(i,j, middle_row[i][j])
workbook.save('xc_handdle_after.xls')

案例转化后的格式截图如下：