Converting text URL to active Links

Aspose.Cells Product Family
1

Hi Team,

Iam using Aspose.cells java to create excel files by reading the CSV. In the CSV i have column of URLs. Is there any way to convert this text column with URL data to active links(Hyper links).

Thanks,
Fathima Farhana Y

2

Hi Fathima,


Thank you for considering Aspose APIs.

Please note, CSV is a simple text file containing string values, separated by commas (or other delimiters). If you wish to store the result back in CSV format then I am afraid, you cannot make any of the URLs as active hyperlinks. However, if you wish to store the result in any of the supported spreadsheet formats then you can use the HyperlinkCollection.add method to add hyperlinks at specified location (cell) as active hyperlinks. Please go through the detailed article on this subject.