BookmarkSubscribeRSS Feed
chandler
Fluorite | Level 6

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 . . .
2 REPLIES 2
Reeza
Super User

post the code and the results from the log.

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

file="file_path";

LarryWorley
Fluorite | Level 6

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,


sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 2 replies
  • 2113 views
  • 0 likes
  • 3 in conversation