topic Re: troubleshooting tagsets.excelxp. . . Problems during load. . .worksheet settings in Microsoft Integration with SAS

troubleshooting tagsets.excelxp. . . Problems during load. . .worksheet settings

chandler — Fri, 07 Sep 2012 17:01:04 GMT

I produce some reports to place on a server, in ExcelXP worksheets. I can't open the resulting file. It gives the following error.

Problems during load. Worksheet settings.

XML PARSE ERROR: Missing whitespace between attributes

Error occurs at or below this element stack:

<ss:Workbook>

<ss:Worksheet>

<x:WorksheetOptions>

<x:PageSetup>

Here is a sample of the code I'm using.

ods Tagsets.ExcelXP file=\\ROCVNX\Bus_Insights_Reports\Turn Down Report\New Loans Turn Down Report &monyr..xls ;

proc print data=prodlib.NEW_TURN_DOWN_RPT label noobs ;

var bus_name application_id product loan_amt . . .

Re: troubleshooting tagsets.excelxp. . . Problems during load. . .worksheet settings

Reeza — Fri, 07 Sep 2012 18:14:39 GMT

post the code and the results from the log.

I'm assuming you have quotations in your file statement for example?

file="file_path";

Re: troubleshooting tagsets.excelxp. . . Problems during load. . .worksheet settings

LarryWorley — Fri, 07 Sep 2012 19:00:50 GMT

I suspect that this may be a data related issue. But regardless, it is an issue with the tagset. The tagset is generating something Excel does not understand.

In addition to posting the sas code and log, I would look at the XML file ExcelXP tagset is generating. I know it has extension of xls but it is really XML. Use an application to view it which does not attempt to parse the XML, for example notepad. Don't use excel.

Using the XML parsing error info you present you may be able to track down the error. If not then I suggest contacting SAS tech support and in particular the ExcelXp tagset team. Or if you can find someone with expertise in Excel XML standard, they may be able to help you.

I have encountered the missing whitespace error where ExcelXP had used a SAS datavalue which is longer than what Excel expects. The specific example I encountered was trying to create excel tab names which were longer than what excel allows. The tagset apparently failed to check the length of the tab names and excel did not see what it expected.

Also if I remember correctly, Excel generates an error log which may be more helpful than the screen error message,