How to create hyperlink in excel document with ax ++?

[Recep]

Hello;

I need to create a hyperlink in a cell inside the xxcel document. How can I do this with x ++?

Thanks.

[Recep]

I used the hyperlink formula in the Excel document. I dynamically create a formula from within Axapta and write it as value to the corresponding cell.

[kunal_patel]

Hello Recep,

it would be great if you share example , will be helpful for many others having the same problem

[Recep]

worksheet.name(strfmt("%1 Page",pageNumber));

//in mainWorkSheet

cells.item(row,5).value("=HYPERLINK("#"&"’" & “+strfmt(”%1",pageNumber)+" &" Page"& “’!A1”;“Graphic”)")

[kunal_patel]

thank you Recep,
it will be very helpful to other people with same issue