In [2]:
import csv
from openpyxl import load_workbook
import codecs
wb = load_workbook('/data/demo/example.xlsx')
a_sheet = wb.get_sheet_by_name('工作表2')
/tmp/ipykernel_1413/1538790818.py:5: DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]).
a_sheet = wb.get_sheet_by_name('工作表2')
使用load_workbook函数导入xlsx文件，获取表名为‘工作表2’的表格。
在这里打开csv文件使用的是codecs模块，codecs专门用作编码转换，
当要做编码转换的时候可以借助codecs很简单的进行编码转换。
接下来逐个读取xlsx文件中的内容，再写入csv文件中。
In [3]:
with codecs.open('xx_1.csv', 'w', encoding='utf-8') as f:
write = csv.writer(f)
for row in a_sheet.rows:
for cell in row:
print(cell.value)
write.writerow(str(cell.value))
name age Max 26 Marry 18 Nanncy 10
In [4]:
import pandas as pd
data_xls = pd.read_excel('/data/demo/example.xlsx', index_col=0,
sheet_name='工作表2')
data_xls.to_csv('1.csv', encoding='utf-8')
--------------------------------------------------------------------------- ModuleNotFoundError Traceback (most recent call last) Cell In[4], line 1 ----> 1 import pandas as pd 2 data_xls = pd.read_excel('example.xlsx', index_col=0, 3 sheet_name='工作表2') 4 data_xls.to_csv('1.csv', encoding='utf-8') ModuleNotFoundError: No module named 'pandas'
In [5]:
import csv
from openpyxl import Workbook
with open('xx_1.csv', 'r', encoding='utf-8') as f:
read = csv.reader(f)
workbook = Workbook()
sheet = workbook.create_sheet('Data', index=0)
l = 0
for line in read:
r = 0
for i in line:
x=[l,r,i]
sheet.append(x)
r = r + 1
l = l + 1
workbook.save('xx_1.xlsx')