• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

vvOut_toSS error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • vvOut_toSS error

    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.


    Code:
         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

  • #2
    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.

    Comment


    • #3
      Hi Edward,

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

      -Rob

      Comment

      Working...
      X