topic Re: Simple Transformation - Hyperlink in Excel - Syntax in Application Development and Automation Discussions

Simple Transformation - Hyperlink in Excel - Syntax

Former Member — Sat, 24 Apr 2010 19:25:26 GMT

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.

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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Sandra_Rossi — Sat, 24 Apr 2010 21:13:21 GMT

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]

Re: Simple Transformation - Hyperlink in Excel - Syntax

Former Member — Sat, 24 Apr 2010 22:35:56 GMT

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>

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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Sandra_Rossi — Sun, 25 Apr 2010 13:22:17 GMT


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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Former Member — Sun, 25 Apr 2010 13:51:02 GMT

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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Sandra_Rossi — Sun, 25 Apr 2010 13:59:32 GMT

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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Former Member — Sun, 25 Apr 2010 14:08:46 GMT

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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Sandra_Rossi — Sun, 25 Apr 2010 15:33:04 GMT

I mean, in this forum

Re: Simple Transformation - Hyperlink in Excel - Syntax

Former Member — Sun, 25 Apr 2010 15:35:19 GMT

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

Re: Simple Transformation - Hyperlink in Excel - Syntax

Former Member — Tue, 04 Jan 2011 11:51:06 GMT

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