topic Re: ExcelXp Tagset sheet_name removes '/' in ODS and Base Reporting

ExcelXp Tagset sheet_name removes '/'

MaryR — Thu, 19 Nov 2015 00:54:18 GMT

I'm using SAS 9.2

When using the ExcelXp tagset, when I place a '/' in the SHEET_NAME, it is replaced by a space in the XML file. Is there a way to avoid this?

Sample code:

ods tagsets.ExcelXP path="C:\" file="my report.xml" style=Journal;

ods tagsets.ExcelXP options(sheet_name="Mostly 3/4 or Better" sheet_interval='None');

proc report data=sashelp.class headline missing nowd split='^^^';

run;

ods tagsets.ExcelXP close;

Thanks in advance!

Jagadishkatam — Thu, 19 Nov 2015 01:32:32 GMT

This is a drawback in excel sheet naming convention, which is the reason why you cannot have that special character

There are few rules when naming worksheets.

The name must be unique within a single workbook.
A worksheet name cannot exceed 31 characters.
You can use all alphanumeric characters but not the following special characters:
\ , / , * , ? , : , [ , ].
You can use spaces, underscores (_) and periods (.) in the name as word separators.

SASKiwi — Thu, 19 Nov 2015 01:40:34 GMT

If you are not on the latest tagset version v1.131, download it from here and check if you still get the same problem: