How to read two sheets from same excel with different datatable, different name column

[user123mem]

Hi i need to read two sheets from one excel .
This two sheet got different datatable and the ,column name also different.

I try to do like this but somehow it cant read column in DBCollateral.
I try to change the name somehow still got error.

[jack.chan]

can you post screenshot of your excel here

[supermanPunch (Arpan)]

@user123mem

image821×218 4.23 KB

Hi @user123mem ,

Do note that you are using CurrentRow in both the For Each Row Activities, change one of them to CurrentRow1 or some different name and Check if you can do the desired operation.

[Rahul_Unnikrishnan]

Hello,

You can use Get Workbook sheets to get the list of sheet names.
Then use a For each to loop through the array names.
use a Read Range activity to Read the Excel and inside the range you have to give the sheet name(it will be item if you are using for each)

[user123mem]

@supermanPunch

Do note that you are using CurrentRow in both the For Each Row Activities, change one of them to CurrentRow1 or some different name and Check if you can do the desired operation.

Hi i try using your solution but somehow i still hit an error

[user123mem]

@Rahul_Unnikrishnan

Then use a For each to loop through the array names.

Hi can you show me how to do iy

[supermanPunch (Arpan)]

@user123mem

but somehow i still hit an error

@user123mem , What was the Error Message ?

[user123mem]

[supermanPunch (Arpan)]

@user123mem,

Have you used Read Range Activities at the beginning to read the Two Sheets in Excel ?

If not, you would require to use it and provide the required Datatable variable as it’s Output.

[user123mem]

Yes i already use Read Range Activities.
Here is my workflow;

Basically i need to read from two excel and one excel i need to read two sheets together.

DBAppInfo and DBCollateral is from one excel
DBAppInq is another excel

[Rahul_Unnikrishnan]

Share the excel and the requirement here with a screenshot. Will help to create the flow.

[ushu (Usha kiranmai)]

@user123mem

• Are you trying to read App Form Sheet data and storing it in DBAppForm variable. If this is the case then you have to keep the read range activity (which was reading sheet APP Form) before for each row of DBAppForm

• Similar to this are you reading Collateral sheet and storing the data in a DBCollateral Variable. If this the case again you have to keep the read range activity (which was reading sheet Collateral) before for each row of DBCollateral. Check the results