How can get the all sheets data into collection (For Ex : i cant predict how much sheets am getting in single excel file, it may vary depends upon the day).
(In the VBO action, we have to mention the worksheet name & i dont want that). First i have to get all the sheetname in that excel. and need to get as a collection. can anyone help?
(In the VBO action, we have to mention the worksheet name & i dont want that). First i have to get all the sheetname in that excel. and need to get as a collection. can anyone help?