Insert Hyperlinks in an Excel Sheet without Excel Application Scope

Help Studio
,
1

Hello, I want to insert hyperlinks in an Excel Sheet but I can’t use Excel Application Scope because Excel is not installed. I already tried few things using Workbook activities but I didn’t find any answer.

2

Hy @Jeanr, welcome to the UiPath Community

I believe it is not possible to do that. “Write Cell” Activity writes plain text in Excel only :frowning:

Regards

3

InsertHyperlinksInExcel.zip (16.6 KB)
Hi,
Please refer the attached file. It may helps you
If your hyperlinks are getting dynamically, you need to add those values to a data table and user “Write Range” workbook activity

4

Hy @Venugopal24, @Jeanr,

I tried to do that, but it prints as plain text in excel, and not as hyperlinks :frowning:

5

Hi @Jeanr, Welcome to UiPath community!

It would be ideal to have Excel installed to make things a bit easier for you.
Here are a couple of not-so-easy suggestions to consider:

  1. A code-based approach by using libraries that enable Excel manipulation. (Read here)
  2. You could use Excel Online and automate on the web interface, although that is a whole other can of worms.

I hope the first suggestion helps.
Cheers.

6

Thank you for your answers, I’ll see to install Excel, I think it’s the easier way

Regards