Exporting column data as link

Exporting column data as link

Posted by: parmarkinjalk on 15 May 2020, 12:24 am EST

• 

  parmarkinjalk

  • Post Options:
  • Link
    Copy

  Posted 15 May 2020, 12:24 am EST

  Hi Team,

  I have a column which has a link(URL E.g-http://abc.com/webtop/drl/objectId/09023928862cd00c ) in it. When I export this column the url is exported as plain text and not as a Link. is there a way we can export it as a Link and not just plain text.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 15 May 2020, 6:33 am EST

  Hi Kinjalk,

  In the formatItem callback of the FlexGridXslxConverter, you may set the link property of the xlsxCell accordingly.

  https://www.grapecity.com/wijmo/api/classes/wijmo_xlsx.workbookcell.html#link

  Regards,
  
  Ashwin

• 

  parmarkinjalk

  • Post Options:
  • Link
    Copy

  Posted 16 May 2020, 1:02 am EST

  Hi Ashwin,

  Thanks for the quick reply. I am not able to figure out how to implement the above solution. Could you please provide a example in angular using gridXlsx.FlexGridXlsxConverter.saveAsync. Thanks.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 18 May 2020, 1:33 am EST

  Hi,

  Refer to the sample link below that demonstrates how to use xlsxCell.link:

  https://stackblitz.com/edit/angular-1fdqzn-zmcdpp

  ~regards