再将读取后的文件转为excel表格
时间: 2023-10-07 09:04:11 浏览: 43
回答: 将读取后的文件转为Excel表格的过程可以使用Python的xlwt库来实现。首先,你需要安装xlwt库。然后,你可以使用以下代码将读取后的文件转为Excel表格:
```python
import xlwt
def txt_xls(filename, xlsname):
try:
f = open(filename, 'r', encoding='utf-8')
xls = xlwt.Workbook()
sheet = xls.add_sheet('sheet1', cell_overwrite_ok=True)
x = 0
while True:
line = f.readline()
if not line:
break
for i, item in enumerate(line.split(';')):
sheet.write(x, i, item)
x += 1
f.close()
xls.save(xlsname)
except:
raise
if __name__ == "__main__":
filename = "file.csv"
xlsname = "b.xls"
txt_xls(filename, xlsname)
```
这段代码会读取名为"file.csv"的文件,并将其内容写入名为"b.xls"的Excel表格中。你可以根据需要修改文件名和表格名。请确保你已经安装了xlwt库,并将代码中的文件名和表格名修改为你实际使用的文件名和表格名。
#### 引用[.reference_title]
- *1* *3* [Java 读取 Excel 模板,将数据填入Excel表格,后转换为PDF文件(实用)](https://blog.csdn.net/BASK2311/article/details/127595446)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [python将CSV文件转为excel](https://blog.csdn.net/qq_56539133/article/details/126037781)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]