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

Help StudioX
,
1

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

image
image821×218 4.23 KB

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

2

can you post screenshot of your excel here

3

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.

4

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)

5

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

6

Hi can you show me how to do iy

7

@user123mem , What was the Error Message ?

8

image

9

@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.

10

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

image
image1239×737 23.4 KB

11

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

12

@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

13

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