Home » Developing U++ » UppHub » [SEMI-SOLVED] OfficeAutomation : How to Set Hyperlink to a Excel cell?
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell? [message #33030 is a reply to message #33023] |
Sat, 02 July 2011 12:32   |
|
I try to add Method HyperLink to OfficeAutomation. But it not work
Where is my mistake?
bool MSSheet::Hyperlink(int col, int row, String hypertext, String hyperaddress) {
if (!App)
return false;
VariantOle x, y;
x.Int4(col);
y.Int4(row);
if (!(Sheet = Ole::GetObject(App, "ActiveSheet")))
return false;
ObjectOle Hyperlinks = Ole::GetObject(Sheet, "Hyperlinks");
ObjectOle Cell1 = Ole::GetObject(Sheet, "Cells", x, y);
VariantOle vCell;
vCell.ObjectOle(Cell1);
ObjectOle Link = Ole::GetObject(Hyperlinks, "Add", vCell);
String d;
if (Link != NULL) d= "Not Null"; else d="Null";
PromptOK("After assing & link is "+d);
VariantOle vAddr,vText;
vAddr.BString(hyperaddress);
vText.BString(hypertext);
Ole::SetValue(Link, "Address", vAddr) ;
Ole::SetValue(Link, "TextToDisplay", vText) ;
return true;
}
Please help!
SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}
[Updated on: Sat, 02 July 2011 12:38] Report message to a moderator
|
|
|
 |
|
[SEMI-SOLVED] OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Mon, 11 July 2011 17:25
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Mon, 11 July 2011 23:03
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: ratah on Tue, 12 July 2011 14:44
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: ratah on Tue, 12 July 2011 14:46
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Wed, 13 July 2011 09:50
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Wed, 13 July 2011 15:37
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Wed, 13 July 2011 17:05
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Fri, 20 September 2013 10:35
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: ratah on Mon, 23 September 2013 13:22
|
 |
|
Re: OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: ratah on Wed, 13 July 2011 14:23
|
 |
|
Re: [SEMI-SOLVED] OfficeAutomation : How to Set Hyperlink to a Excel cell?
By: koldo on Mon, 23 September 2013 16:11
|
Goto Forum:
Current Time: Tue Jun 03 03:17:10 CEST 2025
Total time taken to generate the page: 0.02800 seconds
|