I want to insert a table from excel sheet to new word document. pls help me on this
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