openxl

from openpyxl import Workbook

import datetime

 

filePath = r'e:/python/test.xlsx'

 

#创建Excel实例

myWb = Workbook()

#第一个sheet表

myWs0 = myWb.active

#新建sheet表

myWs1 = myWb.create_sheet("我的sheet")

 

#对每个sheet写入数据

myWs0['A1'] = "自带的"

myWs1['B2'] = "第一个"

 

#往sheet B3中写数据

myWs1.cell(row=3,column=2,value=10)

 

#写入单元格A1-E5，值为单元格号

for i in range(1,6):

    for j in range(1,6):

        value = str(chr(ord('A')+j-1)) + str(i)

        myWs1.cell(row=i, column=j, value="%s"%value)

 

#读取单元格B2的值

mycell = myWs1.cell(row=2,column=2)

print (mycell.value)

 

#打印C3的值

print (myWs1.cell(3,3).value)

 

#输出sheet行数、列数

print (myWs1.max_row,end=" ")

print (myWs1.max_row)

 

#保存Excel表格

myWb.save(filePath)