Free Support Forum - aspose.com

Adding hyperlinks while using ImportDataTable()

Hi Team,

I am using ASPOSE.Cells library. And using ImportDataTable(), I am importing data from datatable to excel sheet. Now my requirement is that I want to show some hyperlinks on certain columns. How can I do this.

Your help is appreciated.

Thanks.

Hi,


Well, Aspose.Cells will fetch pure/raw data (without any style/formatting) resided in your data source and paste data into the cells of a worksheet by using ImportDataTable method. You have to add hyperlinks to link your desired data accordingly via the related Aspose.Cells API after you have imported data into the worksheet cells, see the document for your reference:
http://www.aspose.com/docs/display/cellsnet/Adding+Hyperlinks+to+Link+Data

Thank you.