Python-使用openpyxl模块写入Excel文件
Openpyxl是用于读取和写入Excel(扩展名为xlsx/xlsm/xltx/xltm)文件的Python库。openpyxl模块允许Python程序读取和修改Excel文件。
例如,用户可能必须遍历数千行并挑选一些信息,才能根据某些条件进行较小的更改。使用Openpyxl模块,可以非常有效且轻松地完成这些任务。
示例
# import openpyxl module
import openpyxl
#Call a Workbook() func of openpyxl to create a new blank Workbook object
wb = openpyxl.Workbook()
# Get workbook active sheet from the active attribute
sheet = wb.active
# Cell objects also have row, column and coordinate attributes that provide
# location information for the cell.
# The first row or column integer is 1, not 0. Cell object is created by
# using sheet object's cell() method.
c1 = sheet.cell(row = 1, column = 1)
# writing values to cells
c1.value = "Vishesh"
c2 = sheet.cell(row= 1 , column = 2)
c2.value = "Ved"
#Once have a Worksheet object,one can access a cell object by its name also
# A2 means column = 1 & row = 2.
c3 = sheet['A2']
c3.value = "Python"
# B2 means column = 2 & row = 2.
c4 = sheet['B2']
c4.value = "Programming"
#Anytime you modify the Workbook object or its sheets and cells, the #spreadsheet file will not be saved until you call the #save()workbook method.
wb.save("C:\\Users\\Vishesh\\Desktop\\demo.xlsx")热门推荐
1 训练狗狗基础
2 怎么训练狗狗笑
3 怎么训练狗狗卧下
4 上海狗狗训练基地
5 训练狗狗排便
6 狗狗基础训练
8 如何训练狗狗装死
9 狗狗站姿训练
10 狗狗训练用品
11 训练狗狗吧
12 狗狗要怎么训练
13 怎么训练狗狗玩球
14 训练狗狗唤回
15 狗狗训练躺下
16 狗狗训练指令
17 狗狗的训练技巧
18 狗狗不好训练