在Python中获取Excel表格的数量 [英] Get number of sheet excel in python

问题描述

如何在下面的python示例中获取工作表数量?

How get number of sheet in below python example?

file = self.excel_file.decode('base64')

excel_fileobj = TemporaryFile('wb+')
excel_fileobj.write(file)
excel_fileobj.seek(0)

workbook = openpyxl.load_workbook(excel_fileobj, data_only=True)

sheet_number= ???

sheet = workbook[workbook.get_sheet_names()[0]]


for row in sheet.rows:
            print(row[1].value)

sheet_number = ????

sheet_number=????

任何溶蛋白?

推荐答案

workbook.worksheets包含工作表对象的列表.

workbook.worksheets contains a list of worksheet objects.

要获取工作表的数量:

sheet_number = len(workbook.worksheets)

迭代所有工作表的最简单方法:

Simplest way to iterate over all worksheets:

for ws in workbook.worksheets:
    print ws.title

这篇关于在Python中获取Excel表格的数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！