LB

Hello togehter,

I am trying to implemented a report which exports attributes and other information for each model, which is selcted.

The information is exportet to Excel.

I am working with the "standard?" ooutfile templates:

ooutfile.DefineF("Tabelleninhalt", "Arial",10, Constants.C_BLACK, Constants.C_TRANSPARENT,  Constants.FMT_LEFT, 0, 0, 0, 0, 0, 0);
...       
ooutfile.TableCellF(link_string, 20, "Tabelleninhalt");

All content ist shown in Excel as plain text.

Is it somehow possible to convert a text explicitely to a link somehow. So that Excel shows it in light-blue and you can klick on it?

I tried arround with Constants.FMT_LINKTARGET, this didnt help.

I added the "Formula" as text "=HYPERLINK(....)" but Exel showend me then the formula as text...

Can anybody help?

Thank you,

Levin Brunner

by Amol Patil
Posted on Thu, 09/19/2013 - 19:14

Hello Levin,

 

Use the method OutputLink(), if you are using standard output API.

However, for excel output it is always better to use the excel workbook API.

 

Regards,

Amol Patil

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock