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.
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
Comment