Hi,

I have an excel which has two worksheets. I need to read the excel and do a check for each columns on each worksheet. I am able to do my check, if my excel had only one worksheet. How do I go about working with multiple worksheets on the same excel file.

File Name: TESTExcel.xlsx

Sheet 1 Name: Sheet1.xlsx

Sheet 2 Name: Sheet2.xlsx

Any help will be greatly appreciated.

Thanks

Use the sheet name.

$wb.WorkSheets.Item('sheet1.xlsx')