Read from Excel sheet where sheet name varies or unknown

Help
1

Hi, how do I use Read Cell activity to capture content of cell, where the exact name of the sheet varies or is unknown?

I just know that I have to capture from the first sheet, second sheet, etc. However as we are dependent on the Excel sheet format that clients send back, the name of the worksheets can vary from file to file.

2

@DEATHFISH,

Create one variable of type workbook for Excel application scope activity and say it as ‘WB’.

To read from 1st sheet: WB.getSheets(0)

To read from 2nd sheet: WB.getSheets(1)

1 Like
3

Hi @DEATHFISH

Check out the attached workflow… I have done something similar to get some of my stuff working… The activities on the very top are the ones that you need here…

SheetNames.xaml (13.0 KB)

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.