python 换页符_Python用什么方法可以将换行符分割成多行？

展开全部

import pandas as pd

import xlsxwriter

if __name__ == "__main__":

file_name = r'C:\Users\Administrator\Desktop\test.xlsx'

"""   读取，切割成数组   """

context = pd.read_excel(file_name)

num = context['序号'][0]

value = context['名称'][0]

new_num = num.split('\n')

new_value = value.split('\n')

"""   写入数据   """

workbook = xlsxwriter.Workbook(file_name)

# 创建工作表

worksheet = workbook.add_worksheet('sheet1')

# 写单元格

worksheet.write(0, 0, '序号')

worksheet.write(0, 1, '名称')

# 写列,其中列需62616964757a686964616fe58685e5aeb931333433636166要大写

worksheet.write_column('A2', new_num)

worksheet.write_column('B2', new_value)

# 关闭工作簿

workbook.close()

###顺便给一下你学习的链接吧，这个其实就是个简单的读写文件的应用而已，网页链接