Pathon---读取ExcellData--转自项目

最新推荐文章于 2025-01-08 17:50:00 发布

jjjjyyyyy

最新推荐文章于 2025-01-08 17:50:00 发布

阅读量944

点赞数

CC 4.0 BY-SA版权

文章标签： import class file

本文链接：https://blog.youkuaiyun.com/jjjjyyyyy/article/details/1575749

本文介绍了一个Python类ExcelProcessor，该类利用Win32COM客户端库来打开并读取Excel文件的数据。通过实例化这个类并指定文件名，可以获取指定工作表中特定范围内的单元格数据。

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

need package: win32com.client
from http://sourceforge.net/project/showfiles.php?group_id=78018&package_id=79063&release_id=449591

by Holibut, 2007.04.19
'''

import win32com.client

class ExcelProcessor:
    _fileName='';
    #_workBook
    def __init__(self, asFilename =''):

        if len(asFilename)> 0:
            self.openFile(asFilename)

    def openFile(self, asFilename=''):
        self._excelApp = win32com.client.Dispatch("Excel.Application")
        if self._excelApp.Visible != 1 :
            self._excelApp.Visible=1

        #if the file is already opened, then use it.
        if self._excelApp.Workbooks.count == 0:
            print "not opened yet"
            self._workbook = self._excelApp.Workbooks.Open (asFilename)
        else:
            self._workbook = self._excelApp.Workbooks[0]

    def getData(self, aiSheetIndex = 1, aiRowFrom = 1, aiRowTo = 1, aiColumnFrom = 1, aiColumnTo = 1):
        self._sheet = self._workbook.worksheets(aiSheetIndex)
        loData = []
        for liRow in range(aiRowFrom, aiRowTo):
            loRow = []
            for liColumn in range(aiColumnFrom, aiColumnTo):
                loRow.append(self._sheet.cells(liRow, liColumn).text)
            loData.append(loRow)

        #
        return loData