Novice RPA user here. Do we have the ability to write a range within a table in excel? I would the data that I’m reading to be written on the second row of the table (to accommodate header). I was thinking I could reference the table name in the starting cell destination. Any help would be greatly appreciated!
Hi @jenn.cruz
You can try use Write DataTable To Excel like this
where dt_invoices_table is a DataTable already populated in your workflow
Thank you. The problem with designating “A200” is that the row won’t always be the starting point given there is data above the table.
Check the “Append” box and then don’t designate .Range just give it Excel.Sheet(“sheetname”)
Hi,
Can you try the following sample?
First, find cell address of “Current qrt bookings” using Find/ReplaceValue activity.
Then calculate start address of the table from the above address (row number + 2)
strStartAddress = System.Text.RegularExpressions.Regex.Match(strAddress,"[A-Z]+").Value+(CInt(System.Text.RegularExpressions.Regex.Match(strAddress,"\d+").Value)+2).ToString
Finally, write datatable without header from it.
Sample
Sample20231129-1.zip (9.5 KB)
Regards,
Thank you! This helped!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.