ods tagsets.excelxp issue

[anandbillava]

I have used ods tagsets.excelxp lot of times and never had any issues. But recently I am using it in a new instance of SAS and following things are not working. I have used similar code in the past and never had issues.

The styles using ods escapechar does not work. e.g. title1 "^S={color=CX5F9EA0} Note #2: URGENT " ; 

The hyperlink to other sheets using url option (creating format) is not working

Can you please let me know what could be the issue. Is it something to do with excel or SAS version. I am using SAS 9.4 M7 Version (windows).

[Tom]

Did you set the ODS ESCAPECHAR to ^ ?

Also I believe that method is deprecated and you should probably be using the newer syntax, which I believe involves *ESC* instead of an escape character.

[Ksharp]

1)

Could you use ODS EXCEL to instead of ODS TAGSETS.EXCELXP ?

2)

If you are using TITLE statement, using option LINK= instead of url= style :

title j=l link="#目录!A1"  "(*ESC*)S={textdecoration=underline color=blue }返回目录";

[anandbillava]

I tried that as well. I am trying to create link for column. Used format and also used an example from forum which worked for others. but not working for me. I am suspecting it may be something to do with my SAS and excel.

[anandbillava]

ODS excel has limitation. It cannot create report with large number of records and columns. It throws memory error. Thats a known limitation

[Kathryn_SAS]

I see that you opened a case with Technical Support. Based on that, I would suggest changing the file extension to XML. When I make that change to your code, it works as expected for me.

ods tagsets.excelxp file='try_hyper.xml' style=sasweb
options(sheet_name='Main');

If you continue to have problems, I would also suggest sending your log to the Technical Support case so that we can confirm if you are running the most current version of the tagset.

[anandbillava]

Hi, Can you please remove that folder name from you last post. I accidentally sent it. I try to use that option as well. Created xml, html. No luck so far.

[anandbillava]

I will wait for tech support to respond to my email and then will send the log.