[Download-List] Download Excel Format

[Jeff Colvin]

I'm having issues getting DOWNLOAD version 8.00 to work for the Excel (XLSX) format using UniVerse.  I copied the csv2xlsx.pl Perl script from the distribution list over to my /usr/local/bin directory.

I set up VOC DOWNLOAD.CONFIG:
001: X
002: XLSX.ACTIVE=TRUE
003: XLSX.COMMAND=perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i %input -o %output
004: XLSX.INPUT.SEPARATOR=TAB
005: XLSX.INPUT.SUFFIX=TAB
006: XLSX.WORKING.DIRECTORY=&HOLD&
007: XLSX.DELETE.WORKING.RECORD=TRUE

>SSELECT DLTESTFILE
>>DOWNLOAD DLTESTFILE @COUNTER @ID TEXT.FIELD DATE.FIELD.MV MONEY.FIELD.MV NUMERIC.FIELD VFIELD HEADING FIELD.NAMES FORMAT XLSX FILE &HOLD& DOWNLOAD.XLSX OVERWRITING

DOWNLOAD version 8.00
Using input file DLTESTFILE
Output to file &HOLD& DOWNLOAD.tab

Executing perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i &HOLD&/DOWNLOAD.TAB -o &HOLD&/DOWNLOAD.XLSX
This command is not available on this platform

7 records processed.


I'm not sure if this is a testing, configuration, or a Perl issue.


Jeff Colvin
Senior Programmer Analyst
Mission Petroleum Carriers
832-615-0717
[cid:image002.png at 01D0BE2B.8E2E1400]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150714/e690c459/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 530 bytes
Desc: image001.gif
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150714/e690c459/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 13524 bytes
Desc: image002.png
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150714/e690c459/attachment.png>