How to read multiple excel sheets

Help Activities
, ,
1

Hie all hope doing very well actually i have an excel file which have multiple sheets and i want to read that multiple sheets like excel file name is test.xlsx and have 3 sheet sheet1,sheet2,sheet3 and i want to read it one by one so how can i read them

2

Hi @singh_sumit ,

Use Get workbook sheets activity. It will return all the Sheet names in List of String.

You can then use for each to loop and read each sheet.

image
image554×569 12.3 KB

Try this. Hope it helps.

3 Likes
3

@singh_sumit

You can use use excel file activity and inside that use for each excel sheet activity to go through all sheets…

If you know the sheetnames use read rnage with each sheetname

Hope this helps

Cheers

4

Hi @singh_sumit
Look into the thread reading multiple sheets and consolidate into one sheet

Regards
Mohini Sonule

5

Yes it work… actually i tried that same thing but that read range i got confused thanks for the help

1 Like
6

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