The SAS Output Delivery System and reporting techniques

Is there a way to change the tabcolor for select tabs in *.xlsx files with ods tagsets.excelxp?

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Is there a way to change the tabcolor for select tabs in *.xlsx files with ods tagsets.excelxp?

Is there a way to change the tabcolor for select tabs in *.xlsx files with ods tagsets.excelxp?


Accepted Solutions
Solution
‎05-09-2014 04:23 PM
SAS Employee
Posts: 87

Re: Is there a way to change the tabcolor for select tabs in *.xlsx files with ods tagsets.excelxp?

The ExcelXP tagset does not have an option to modify the tab color currently, however, this has been added to the pre-production Excel destination available beginning with SAS 9.4M1. The sample below demonstrates modifying the ExcelXP tagset to add this functionality.

http://support.sas.com/kb/45249

View solution in original post


All Replies
Solution
‎05-09-2014 04:23 PM
SAS Employee
Posts: 87

Re: Is there a way to change the tabcolor for select tabs in *.xlsx files with ods tagsets.excelxp?

The ExcelXP tagset does not have an option to modify the tab color currently, however, this has been added to the pre-production Excel destination available beginning with SAS 9.4M1. The sample below demonstrates modifying the ExcelXP tagset to add this functionality.

http://support.sas.com/kb/45249

Post a Question
Discussion Stats
  • 1 reply
  • 293 views
  • 0 likes
  • 2 in conversation