Inserting table from excel to new word document


#1

Hi,
I want to insert a table from excel sheet to new word document. pls help me on this


#2

Hi @Ananda5

I would personally try to use Excel Application Scope. Within it, I would use Select Range activity to select the range of the table. Then I would use Send hotkey activity to send CTRL+C (to copy the data).

You can then paste the data into Word by using Send hotkey activity set to CTRL+V (to paste the data)

Of course, this solution assumes that the table is of static size. But there are of course workarounds for situations when it would be dynamic:

  • you could read the table using Read Range activity, see how big it is and use that information as variables for your Select Range activity
  • you could use VBA scripting to capture the active range from the Excel