Workbook=New WorkbookApplication("C:\Users\rlgandu\Downloads\ECOO Autoreport Status 2024.xlsx")
Sheetnames=Workbook.GetSheets.ToArray
This will get you the sheet names dynamically.
Workbook=New WorkbookApplication("C:\Users\rlgandu\Downloads\ECOO Autoreport Status 2024.xlsx")
Sheetnames=Workbook.GetSheets.ToArray
This will get you the sheet names dynamically.