表格基本操作pandas和openpyxl

1, 创建表格

from openpyxl import load_workbook,Workbook
wb = Workbook()
path = "/.../3.xlsx"
wb.save(path)

2, 写入表格

import pandas as pd
dataFrame = pd.DataFrame(columns = {‘’，‘’ } )
writer = pd.ExcelWriter('3.xlsx', engine='openpyxl')
writer.book = wb
writer.sheets = dict((ws.title, ws) for ws in wb.worksheets)
dataFrame.to_excel(writer, "Main",index=0,startrow=0,startcol=0)
writer.save()

3, 写入值

DataFrame.set_value(self, index, col, value, takeable=False)

4, 关于openpyxl

import openpyxl
wb = openpyxl.load_workbook('3.xlsx')
sheets = wb.sheetnames
ws = wb.active
# 当前活跃的表单

ws.cell(row=5, column=2).value

cell = ws['B1']

那么：cell.coordinate 是 B1

          cell.row 是1

          cell.column是2

          cell.value

或如下格式调用

ws.cell(row=5, column=2).value

更多数学原理小文请关注公众号：未名方略

最后

以上就是整齐羊最近收集整理的关于表格基本操作pandas和openpyxl的全部内容，更多相关表格基本操作pandas和openpyxl内容请搜索靠谱客的其他文章。