Writing Extracted Web Data to Specific Excel Cell Using UiPath ReFramework

[matheusj]

I’m learning to use the ReFramework with DataTables, but I’m facing an issue when trying to save data extracted from the internet into a specific cell in Excel. I understand that I need to use the Write Cell activity, but I’m unsure how to specify the exact cell number where the data should be written.

I tried using the TransactionItem, but without success. I believe the ideal approach would be to use the TransactionNumber, but I’m having trouble indicating it correctly. Could someone help me with this? What would be the best way to configure writing to the exact cell using the ReFramework?

Thank you!

[ashokkarale]

@matheusj,

Use Write Cell Workbook activity for this like below:

1. Your workbook path from Config
2. Sheet name from Config
3. Cell it will be like this (I’m assuming you are trying to write in A column. You can change as per requirement): "A"+TransactionNumber.ToString
4. CodOrigem

Thanks,
Ashok

[matheusj]

@ashokkarale

• Your workbook path from Config
• Sheet name from Config
• Cell it will be like this (I’m assuming you are trying to write in A column. You can change as per requirement): "A"+TransactionNumber.ToString
• CodOrigem

But I can’t use the transaction number variable because it doesn’t exist within the process workflow, and I don’t know how to import it.

[ashokkarale]

@matheusj,

Here is how to import it.

1. Create TransactionNumber Int32 type, In direction, argument in Process.xaml and save the file
2. Go to Main.xaml and pass the TransactionNumber to Invoke Process workflow.

Thanks,
Ashok

[Anil_G (Anil Gorthi)]

@matheusj

you can create an argument in process.xaml of type int32 and link that with transactionnumber

cheers

[matheusj]

It worked, Thank you!