python 读取 Excel 写入Excel

import openpyxl
 
# 打开excel文件,获取工作簿对象
wb = openpyxl.load_workbook('example.xlsx')
# 从表单中获取单元格的内容
ws = wb.active  # 当前活跃的表单
 
print(ws.cell(row=1, column=2)) # 获取第一行第二列的单元格
print(ws.cell(row=1, column=2).value)
for i in range(1, 8, 2): #  获取1,3,4,7 行第二列的值
    print(i, ws.cell(row=i, column=2).value)

 抄自：https://www.cnblogs.com/crazymagic/articles/9752287.html

 

插入到excel

openpyxl

#!/usr/bin/env python

from openpyxl import Workbook

book = Workbook()
sheet = book.active

sheet['A1'] = 1
sheet.cell(row=2, column=2).value = 2

book.save('write2cell.xlsx')

https://geek-docs.com/python/python-tutorial/python-openpyxl.html#Openpyxl-2

 

 

import xlsxwriter

workbook = xlsxwriter.Workbook('hello.xlsx') # 建立文件

worksheet = workbook.add_worksheet() # 建立sheet， 可以work.add_worksheet('employee')来指定sheet名，但中文名会报UnicodeDecodeErro的错误

worksheet.write('A1', 'Hello world') # 向A1写入

worksheet.write(1,1,'guoshun')#向第二行第二例写入guoshun
workbook.close()

 

 抄自：https://www.cnblogs.com/shunguo/p/11399315.html