Skip to Content
Sep 11, 2009 at 04:15 PM

Selecting worksheet from EXCEL


Hi All,

I am working with EXCEL with multiple worksheets. I am able to get the data that i need to the worksheets. But my issue now is the EXCEL will have multiple worksheets. I need to choose the worksheet by name. Lets say my EXCEL has 3 sheets.Sheet1/Sheet2 and Sheet3. When i execute for the first time i want to load my data to Sheet3. Next time may be in Sheet2.

What i am looking at is i want to check the worksheet name and if it matches my requirement then i will load into that sheet. If not i want to move to the next worksheet and check its name. Continue this till i check all the worksheet names. IDoes anyone has any idea how to go with it?

Thanks in advance,


Edited by: karuna Gangireddy on Sep 11, 2009 6:17 PM