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()

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
 

写入

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')

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
 

test.xlsx文件内容

文章来源: blog.csdn.net，作者：Dream丶Killer，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/qq_43965708/article/details/113894501