I see a few similar posts about this, but none have helped my issue. Basically, I need to move tables from a list of excel files all into one master word file. Please see attached xaml + details below.
I would really appreciate any thoughts on how to successfully do this, as I’m leaning toward leaving this part manual or trying to layer in some kind of R or powershell script to get this to work.
Details: I need to iterate through a folder filled with excel documents, each containing a table with some pretty specific formatting (would be nearly impossible to recreate after pasting in Word due to the variability of sections in the table). The loop works fine, my issue is actually copy and pasting the tables.
Currently I have:
ctrl + a, ctrl + a (to get the entire excel sheet, not just top section), ctrl + c, “Get From Clipboard” activity in the origin excel sheets,
then ctrl + v in the Word doc.
When I run the process I have defined currently, nothing gets pasted into the Word doc.
If I put a breakpoint right before the ctrl + v activity, then manually click ctrl + v, a full page of text gets pasted into the target word doc, (see example below)
example of manual paste from uipath ctrl + c:<?xml version="1.0" encoding="utf-16"?><ClipboardData Version="1.0" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:p="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=mscorlib"
excel copy - word paste.zip (45.4 KB)