Hi Team,
I have a workbook called abc.xlsx .the workbook can contain multiple excel sheets.So i want to read excel file which starts with “K”.Can you please teach me how to do this functionality.
Thanks in advance
Hi Team,
I have a workbook called abc.xlsx .the workbook can contain multiple excel sheets.So i want to read excel file which starts with “K”.Can you please teach me how to do this functionality.
Thanks in advance
There are two types of read range activities, one in and excel scope and the other in workbook. You’ll want to use the workbook read range so you can specify the sheetname in properties.
if you have multiple excel sheets (starts with K) then first you get all the worksheet names and them in loop and for every excel sheets check for first index letter is K or not then you can read
Activity - Get Workbook Sheet
refer this