vvOut_toSS error

[edward.thomas]

On upgrading to v5 the cut down code below now gives the following error when I try to open the spreadsheet.

Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 4, column 126328.

We use vvOut_execSqlToSS elsewhere and have had no problem.

     f AB123PF   if   e           k Disk

     d AB123DS         ds                  likerec(AB123R0) dim(32676) inz 


     p downloadSpreadSheet...
     p                 b
     d                 pi


     d Col             ds                  likeDS(vvSSCol)
     d                                     dim(3)inz

     d #wcount         s              6  0 inz(0)

      /free
	   
       // Load Data Structure
       getGridRecords(#wcount);

       // Set Column Headings
       col(1).sqlName  = 'PLIN70';
       col(1).heading  = 'PLine';
       col(2).sqlName  = 'PLDS70';
       col(2).heading  = 'Product Line Description';
       col(3).sqlName  = 'PRDC70';
       col(3).heading  = 'Product Code';
       col(3).colWidth  = 80;

       // Output
       vvOut.rootName = 'discontinueds';
       vvOut.download = 'Y';
       vvOut.file     = 'Discontinued' + %char(%timestamp()) + '.xls';
       vvOut.object='AB123PF';
       vvOut_toSS(vvOut:%addr(AB123DS):#wcount:%addr(Col):3);
       vvOut.success = 'true';

      /end-free
     p                 e

[edward.thomas]

Bundled example

When opening the spreadsheet created by hitting the

'Download to spreadsheet Sample 3' button (this uses vvOut_toSS also)

in

ssdownload.html (from version3.2)

which calls bundled example RPG

Object ID: EXSS01
Version: V5.0
Description: Valence Examples - Spreadsheet Downloads

I get error

'Excel found unreadable content...'

where upon the content has to be repaired

'Repaired Records: Cell information from /xl/worksheets/sheet1.xml part'

Would this be connected?

We use Excel 2007.

[robert.swanson]

Hi Edward,

Could you attach the Excel document that's causing the trouble? We'll take a look at it.

-Rob