Get list of sheets from excel workbook

Aspose.Cells Product Family
1

I am trying to find all the sheets from excel workbook, but i am not getting any function to get whole list of sheets from excel workbook.

Thanks

2

@asposeLegit
Please use Workbook.Worksheets property to get all worksheets.
See API:

3

@asposeLegit,

Moreover, there is no single API to get whole list of worksheets in the workbook, so you may get one by one to store to arrays/list. I guess you are using Aspose.Cells for Python via Java, here is sample code segment for your reference:
e.g.
Sample code:

......
wb = Workbook("yourfile.xlsx")
ws = wb.getWorksheets()
sheet_count = ws.getCount()
print(sheet_count)
# sheet name list
sheet_names = []
for i in range(0, sheet_count):
    sheet_name = ws.get(i).getName()
    sheet_names.append(sheet_name)
print(sheet_names)

Hope, this helps a bit.

4

@asposeLegit
Please try the following codes to get all worksheets:
workbook = Workbook(“output.ods”)
sheets = workbook.getWorksheets()
for sheet in sheets:
print(sheet.getName())