Python读写Excel文件

读取

Excel 02.xlsx文件内容如下

import xlwings as xw

app = xw.App(visible=True, add_book=False)
app.display_alerts = False
app.screen_updating = False
wb = app.books.open(r'C:\Users\pc\Desktop\数据分析\Excel 练习课件\Excel 02.xlsx')
data = app.books[0].sheets[0].range('A3:G20').value
print(data)
wb.close()
app.quit()

写入

import xlwings as xw

wb = xw.Book()
sht = wb.sheets[0]
info_list = [['01', '已揽收', 'beijing'],
             ['02', '已发货', 'shanghai'],
             ['03', '已揽收', 'tianjin'],
             ['04', '已发货', 'chengdu'],
             ['05', '正在派送', 'chongqing']]
titles = [['货号', '状态', '地点']]
sht.range('A1').value = titles
sht.range('A2').value = info_list
wb.save(r'C:\Users\pc\Desktop\test.xlsx')

test.xlsx文件内容