PYTHON操作EXCEL，实例代码

最新推荐文章于 2024-12-25 12:09:02 发布

原创最新推荐文章于 2024-12-25 12:09:02 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#python #excel #tuples #import

本文介绍了一个利用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()