python获取excel表单名称_Python Excel - 如何将工作表名称转换为工作表编号

In this program I create a sheet on the input excel file called new_sheet.

I need the sheet number of the sheet without having to look at the excel file.

How do I return the sheet number from the program?

import xlwt

import xlrd

import csv

workbook = xlrd.open_workbook('input.xls')

worksheet = workbook.add_sheet('new_sheet')

解决方案

I'm not understand well if you want count how many sheets there are in your Excel file or if you want know, gave the name of sheet at which number correspond;

anyway, if you want count how many sheets there are in an Excel file you can proceed in this way:

workbook = xlrd.open_workbook('input.xls')

worksheet = workbook.add_sheet('new_sheet')

# number of sheet

print workbook.nsheets

Instead, if you want know the corresponding number of sheets from the name you can proceed in this way:

workbook = xlrd.open_workbook('input.xls', on_demand=True)

for index, sheet in enumerate(workbook.sheet_names()):

if sheet == :

print index

With on_demand=True, you can open file not loading automatically.

Regards