I wanted to double check to see if there are any utilities or mechanisms to take a spool file and convert it to an XLS. We currently use Compleo to do this but I am interested in getting rid of Compleo due to the complications behind the spool to xls process.
Requirements:
1. The end format has to be a spreadsheet (not pdf, not Word, not csv, not text, again csv is NOT an option)
2. Only minimal effort can be spent on modifying the legacy programs to output to XLS (no rewrites to build an SQL for vvOut_execSqlToSS). I can foresee an opportunity to write to a PF record layout in lieu of a PRTF layout so that vvOut_execSqlToSS
3. Some of our reports have 500,000+ rows
4. We "can" use Valence 4.1, 4.2, or 5.0.
Requirements:
1. The end format has to be a spreadsheet (not pdf, not Word, not csv, not text, again csv is NOT an option)
2. Only minimal effort can be spent on modifying the legacy programs to output to XLS (no rewrites to build an SQL for vvOut_execSqlToSS). I can foresee an opportunity to write to a PF record layout in lieu of a PRTF layout so that vvOut_execSqlToSS
3. Some of our reports have 500,000+ rows
4. We "can" use Valence 4.1, 4.2, or 5.0.
Comment