Fill Excel file with fixed rows based on other excel

Hello,

I need to fill a “Master Excel File” based on three other files.
That Master File has some fixed rows and the data from the others files needs to be between each fixed row.
Im new to RPA, how can I do this?
Thank you !

1 Like

Hi @C.Santiago

Can you show more deails like putting some screenshots or sample of your excel the input and the ouput.

cheers :smiley:
Happy learning :smiley:

1 Like

Hi @pattyricarte!
Sure thing! :slight_smile:
Let’s Say I need to input 10 records bellow 1, 24 records between 1 and 2, and so on, and this records are from another files with the same layout
Screenshot_1

1 Like

Hi @C.Santiago

The idea for that if you can get the index of the fixed rows. and set it to writecell actitivties to input the value between those fixed rows.

Sample:
dt1.Rows.IndexOf(row).ToString

image

cheers :smiley:

Happy learning :smiley:

1 Like

@pattyricarte Thank you for your help, but if i input the index there, it will be something like “A3” let’s say, no ?
That way the wouldn’t the Write Cell Function write on the specific line, and not bellow ?
Because the ideia it’s to input the data without overwrite the others fixed rows :confused:
Thank you once more!
Br.
Carlos.