Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Simple Transformation - Hyperlink in Excel - Syntax

Former Member
0 Kudos

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:... ?

1 ACCEPTED SOLUTION

Sandra_Rossi
Active Contributor
0 Kudos

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]

9 REPLIES 9

Sandra_Rossi
Active Contributor
0 Kudos

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]

0 Kudos

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.

0 Kudos

<tt:attribute name="ss:HRef">mailto:<tt:value ref="EMAIL"/></tt:attribute>

0 Kudos

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

0 Kudos

I hope you'll become experienced soon and answer ST questions in that forum, it misses experienced people to help others

0 Kudos

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

0 Kudos

I mean, in this forum

Former Member
0 Kudos

Thanks, just wanted to make sure I was posting to the correct place.

Former Member
0 Kudos

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