How do i read excel file with the specified key

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