Forum: Ruby-Forum.com Hyperlink

54ef391d48d57b0d5979f60fb0cbd8dd?d=identicon&s=25 Manigandan Ramadoss (rmanigandan)
on 2009-03-11 13:44
hi

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
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.