04-24-2010 8:25 PM
Hi, I created an Excel Workbook with multiple worksheets and within each worksheet is a column of email addresses. I am trying to create a hyperlink to this email address but am running into trouble with its syntax. a static value works; however, I cannot write this statement using variables.
<Cell ss:HRef="mailto:Wwwwwwww@xxxxxx" ss:StyleID="s75">
<Data ss:Type="String">
<tt:value ref="EMAIL"/>
</Data>
</Cell>
The above will display the correct email address within the cell; however, upon double-clicking the cell, I get an email document pointing to the mailto: reference. The above is within a table loop to generate the worksheet. I would like to have the mailto HRef value to contain the same value as the EMAIL variable.
What would the syntax be for the HRef="mailto:... ?
04-24-2010 10:13 PM
Maybe something like that:
<Cell>
<tt:attribute name="ss:HRef" value-ref="EMAIL"/>
<tt:attribute name="ss:StyleID">s75</tt:attribute>
</Cell>
[sap library - simple transformation - tt:attribute|http://help.sap.com/saphelp_nw04s/helpdata/EN/18/d16240e85cef6fe10000000a1550b0/frameset.htm]
04-24-2010 10:13 PM
Maybe something like that:
<Cell>
<tt:attribute name="ss:HRef" value-ref="EMAIL"/>
<tt:attribute name="ss:StyleID">s75</tt:attribute>
</Cell>
[sap library - simple transformation - tt:attribute|http://help.sap.com/saphelp_nw04s/helpdata/EN/18/d16240e85cef6fe10000000a1550b0/frameset.htm]
04-24-2010 11:35 PM
Thanks for the information and reference link.
I used your example and got a little closer... Now, the email address is in the cell, hyperlinked and when clicked it will open a new email message. However, the to: field is blank, so the email address variable is not being used correctly.
Here is my revised logic:
<Cell>
<tt:attribute name="ss:HRef='mailto:'" value-ref="EMAIL"/>
<tt:attribute name="ss:StyleID">s75</tt:attribute>
<Data ss:Type="String">
<tt:value ref="EMAIL"/>
</Data>
</Cell>
The EMAIL variable is populating the cell correctly,so it does have values; however, when used with the HRef='mailto:' attribute it does not produce the email in the "To:" field.
04-25-2010 2:22 PM
<tt:attribute name="ss:HRef">mailto:<tt:value ref="EMAIL"/></tt:attribute>
04-25-2010 2:51 PM
Thank you for helping me with this.
I am new to using simple transformations and had this one last issue on an ABAP report I was creating, so I appreciate you help in solving this. I will use the link you provided and other materials I gathered and get myself up to speed. Developing an Excel spreadsheet using simple transformations has been fun and an improvement for me over using other methods SAP has provided.
John
04-25-2010 2:59 PM
I hope you'll become experienced soon and answer ST questions in that forum, it misses experienced people to help others
04-25-2010 3:08 PM
Which forum would that be? When I created the original message, I did not notice a forum that related to ST and upon searching topics, I found most transformation questions were being answered in the ABAP General forum.
Thanks
John
04-25-2010 4:33 PM
04-25-2010 4:35 PM
Thanks, just wanted to make sure I was posting to the correct place.
01-04-2011 11:51 AM
Hi ,
Are you saving your excel as an xml spread sheet ? or just ordinary xls?
Could you also please enlighten about some guides to write the simple transformation?
Regards
Mithun