python 进行 excel基本操作技巧

from openpyxl import Workbook
from openpyxl import Workbook
wb=Workbook()
ws1=wb.active
ws1=wb.active
ws1.tiltle=‘range names’
li_v[ ] 嵌套的列表形式
from openpyxl import Workbook
li_v=[[‘name’,‘age’,‘from openpyxl import Workbookgender’],[‘amy’,18,‘femle’],[‘bod’,18,‘male’]]
​
for li in li_v: #SyntaxError: unexpected EOF while parsing
ws1.append(li)

for li in li_v: #SyntaxError: unexpected EOF while parsing
ws1.append(li)

ws2=wb.create_sheet(title=‘PI’) #创建工作表
from openpyxl.utils import get_column_letter
2
for row in range(1,10):
for col in range(1,10):
c=ws2.cell(column=col, row=row, value="{0}".format(get_column_letter(col)))
dest_filename=‘empty_book.xlsx’
wb.save(dest_filename)
使用数据格式
ws=Workbook()
ws=wb.active
from openpyxl import Workbook
ws=Workbook()