Write Range to Table in Excel

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.