Simple Transformation - Hyperlink in Excel - Syntax

[Former Member]

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

[Sandra_Rossi]

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]

[Former Member]

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.

[Sandra_Rossi]

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

[Former Member]

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

[Sandra_Rossi]

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

[Former Member]

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

[Sandra_Rossi]

I mean, in this forum

[Former Member]

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

[Former Member]

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