Jan-10-2020, 04:43 AM
May be try this to see if that helps,
Sandeep
GANGA SANDEEP KUMAR
import pandas as pd xl = pd.ExcelFile('test123.xlsx') a=xl.sheet_names print(a)# original sheet names list exclusionlist=["Sheet1","Sheet4"]# exclusion list for item in exclusionlist: a.remove(item) print(a)#now "a" have remaining sheetnames workbook_url = 'test123.xlsx' #df = pd.read_excel(workbook_url, sheet_name=a, ignore_index=True) df = pd.concat(pd.read_excel(workbook_url, sheet_name=a), ignore_index=True, sort=False) print(df) #print(df.keys()Best Regards,
Sandeep
GANGA SANDEEP KUMAR