PYTHON操作EXCEL,实例代码

本文介绍了一个利用pywin32库简化Excel文件读写的Python类。该类提供了获取单元格值、设置单元格值及获取指定范围内的数据等功能,并附带了一段示例代码演示如何使用此类进行Excel文件的操作。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

用pywin32了。
我前段时间刚刚做过这方面的东西,给你一段代码希望对你有所帮助。

Python code
from win32com.client import Dispatch
import win32com.client

class easyExcel:
""" A utility to make it easier to get at Excel. Remembering
to save the data is your problem, as is error handling.
Operates on one workbook at a time.
"""

def __init__ (self, filename = None):
self.xlApp
= win32com.client.Dispatch( ' Excel.Application ' )
if filename:
self.filename
= filename
self.xlBook
= self.xlApp.Workbooks.Open(filename)
else :
self.xlBook
= self.xlApp.Workbooks.Add()
self.filename
= ''

def save(self, newfilename = None):
if newfilename:
self.filename
= newfilename
self.xlBook.SaveAs(newfilename)
else :
self.xlBook.Save()

def close(self):
self.xlBook.Close(SaveChanges
= 0)
del self.xlApp

def GetExcelLineCount(self):
count
= 0
sht
= self.xlBook.Worksheets( ' 第一轮 ' )
while True:
if sht.Cells(count + 1 , 1 ).Value == None:
break
count
+= 1
return count
def getCell(self, sheet, row, col):
" Get value of one cell "
sht
= self.xlBook.Worksheets(sheet)
return sht.Cells(row, col).Value

def setCell(self, sheet, row, col, value):
" set value of one cell "
sht
= self.xlBook.Worksheets(sheet)
sht.Cells(row, col).Value
= value

def getRange(self, sheet, row1, col1, row2, col2):
" return a 2d array (i.e. tuple of tuples) "
sht
= self.xlBook.Worksheets(sheet)
return sht.Range(sht.Cells(row1, col1), sht.Cells(row2, col2)).Value

if __name__ == " __main__ " :
xls
= easyExcel( ' D:/用户目录/pythonworkspace/excel2doc/src/test.xls ' )
lineNum
= xls.GetExcelLineCount()
for i in range( 1 ,lineNum + 1 ):
for j in range( 1 , 8 ):
print i,j,xls.getCell( ' 第一轮 ' , i, j)
xls.save()
xls.close()

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值