can any one help me out to fix this

hyper_link = “=HYPERLINK(“test.xls#Sheet2!A1”, “Sheet2”)”
worksheet.write_url( 4+ j , 4 , hyper_link, format_bold)

above one is the code to give hyperlink for the text in Sheet1

once I clicked the Sheet2 link it should goes to Sheet2

I have tried and I got the text HYPERLINK(“test.xls#Sheet2!A1”,
“Sheet2”) in the generated excel but I want this as link

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs