Reading one excel file with 4 sheet

Help Something Else
1

hi. i need to read one excel file with 4 sheets then get specific cell data in each sheet and store the data in specific cell that i get in my 2nd excel.
image

this is the sheets

and this is where i want to store it

image
image1076Ă—488 8.82 KB

3

Hi @ldiaz ,

Maybe you could try Exploring with the below Activities /Steps :

  1. For this Configuration maybe the usage of an Excel Config where we arrange the Sheet name and Specific Cell Address could be helpful when we are retrieving the values in a dynamic manner. An arrangement / configuration could be made in the below manner :
    image

If the Cell Addresses are the same for each sheet, we could avoid the above config and go for a shorter approach within the Studio itself.

  1. Having the config created would help us use Workbook Read Cell Activity in a Loop fetching the data in the config created as above. To Store the cell values we could use a Dictionary(of String, String) where the key would be the sheet name and the value would be the cell value.

  2. Now, we have the cell values that we need to input in another Excel. But we still don’t have the full details as to which cell or where exactly to store it.
    A Similar mapping would be needed like the config mentioned above if there are specific cell address to be used.

Do Note that the “where i want to store” is not completely specified.

Let us know if the above suggestions help you and provide us with a feedback if you were able to proceed further.

1 Like
4

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