excel - 将文本转换为 Excel 电子表格

Question

我是 Python 新手，但我有一个有趣的任务。我们有非常大的结构文本。例子：

'''

Writers 1.
Writer Dostoevsky, career: 1844-1849 (early career), 1849-1854 (exile to Siberia), 1854-1866 (prison, marriage).
Writer Pushkin, career: 1820-1822 (first publishing), 1836-1837 (duels and death).
Writers 2.
Writer Shakespeare, career: 1585-1588 (career beginning).
Writer Hemingway, career: 1913-1917 (high school), 1916-1917 (first publishing), 1818-1819 (World War I).
Writer Twain, career: 1883-1909 (Love of science and technology).

'''

我们需要将其转换为excel电子表格以获得清晰的信息视图：

我该如何解决？我尝试使用正则表达式，但我想获得电子表格是不够的，如图所示。

标签： excelspreadsheet

Answer 1

您将需要使用 xlwt 库。你可以在这里找到

# Writing to an excel  
# sheet using Python 
import xlwt 
from xlwt import Workbook 

# Workbook is created 
wb = Workbook() 

# add_sheet is used to create sheet. 
sheet1 = wb.add_sheet('Sheet 1') 

sheet1.write(1, 0, 'ISBT DEHRADUN') 
sheet1.write(2, 0, 'SHASTRADHARA') 
sheet1.write(3, 0, 'CLEMEN TOWN') 
sheet1.write(4, 0, 'RAJPUR ROAD') 
sheet1.write(5, 0, 'CLOCK TOWER') 
sheet1.write(0, 1, 'ISBT DEHRADUN') 
sheet1.write(0, 2, 'SHASTRADHARA') 
sheet1.write(0, 3, 'CLEMEN TOWN') 
sheet1.write(0, 4, 'RAJPUR ROAD') 
sheet1.write(0, 5, 'CLOCK TOWER') 

wb.save('xlwt example.xls') 

酱