How to Read Range with the name start with "JAN****"

Help Studio
1

Hi, as now i got a few sheet with different name in excel, for the read range how do i let the bot to read the data sheet which start with the word i wanted such as “JAN”.

2

You can use the output for workbook in Excel Application Scope say Wb
Then Use Wb.GetSheets will give u list of sheets
So Using for each u can iterate that list
And using if u can read that sheets only
say in For Each ListOfSheet
If item.tostring.startswith(“JAN”)
then Read range

1 Like
3

since i got a few diffent sheet name can i just put item.tostring.startswith(“JAN”)in the read range?

4

As you will get those sheets names in a list so u can iterate them in
For Each activity
so it will iterate one by one sheet

5

alright thank, do u familiar with copy more sheet data to excel?

6

Can u explain more

7

Now i got a few sheet to let the user to select, thn the selected sheet will copied to excel B.The next time the user select the next sheet,it will append on below

8

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