How to copy hyperlink data from excel document to word document

[Karthik_Chandra_Sirimalla]

Hello,

I’m working on a usecase where I have to copy the data from a excel which has hyperlinks in a column to a word document.

I have the excel data in a table format. Hence I need to copy the data as it is in word document.

Any leads or help is much appreciated.

Thanks,
Karthik.

[Anil_G (Anil Gorthi)]

@Karthik_Chandra_Sirimalla

first use read range and save to dt

and thena dd table to word usign work activities

try without preserve format in reading to get hyperlink

[SorenB]

Hello @Karthik_Chandra_Sirimalla

You could read the Excel File using “Read Range Workbook”-activity, and the iterate the rows with “For Each Row in Data Table”.
Then you simply append the text to the Word document (remember to set “Empty field” = None).

Regards
Soren

[Karthik_Chandra_Sirimalla]

Hi @Anil_G , I have tried your approach but it isn’t working.

[Karthik_Chandra_Sirimalla]

Hi @SorenB, Can you please suggest background approach.

[SorenB]

Hello @Karthik_Chandra_Sirimalla

I am unsure what you mean.
Could you elaborate on what the use case is, how data is recieved and how the output is expected?

Regards
Soren

[Karthik_Chandra_Sirimalla]

I’m reading couple of excels from sharepoint and the data of these excel files have hyperlinks in them. So I want to read the data from excel and write the data into a word document in the form of a table.

I’m attaching screenshots for your reference.

[SorenB]

Hello @Karthik_Chandra_Sirimalla

You could use the activity “Copy/Paste Range” inside an “Excel Application Scope”, to copy your links from Excel.
Then use simple “Keyboard Shortcuts” inside an “Word Application Scope” to write and format the copied content as a table.

Take a look at the example below.
You can download the files at the end.

Excel Copy.xaml (11.9 KB)
links.xlsx (9.3 KB)

Best regards
Soren

[Karthik_Chandra_Sirimalla]

Hey @SorenB , Thanks for the solution.

The solution you provided looks promising but I have another challenge. I need to paste the table by replacing placeholders in word document. I have been trying to solve this challenge by myself by making use of your solution but I’m not able to do it.

[SorenB]

Hello @Karthik_Chandra_Sirimalla

Again you could use “Keyboard Shortcuts” to make the cursor jump to the correct location.

• In your Word Template you could insert an empty table (just 1 row/cell).
• Use “Keyboard Shortcuts” to press F5 (Search and Replace)
• Use a “Click” activity with inputtype “Simulate” to click “Table”
• Type tablenumber 0 with a “Type Into” activity
• “Click” Go to

Best regards
Soren