Reading data from excel spreadsheet - cannot open the specified worksheet

[wilson208]

Hi, i have been workin on a project that uses an excel spreadsheet to read data from to get results. In the spreadsheet i have 5 different worksheets, named simply 1 to 5. I need to be able to go to open the workbook, open a specified worksheet and get multiple values from all cells in a particular row. I have searched the internet for a solution but cannot find one. Any help or guidance would be greatly appreciated. Many thanks, Wilson