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=????

Any solutin?

解決方案

workbook.worksheets contains a list of worksheet objects.

To get the number of worksheets:

sheet_number = len(workbook.worksheets)

Simplest way to iterate over all worksheets:

for ws in workbook.worksheets:

print ws.title

總結(jié)

以上是生活随笔為你收集整理的python显示表格_在Python中获取Excel表格的数量的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。