export from filepro to an excel file
Cole, Ken (ABRC)
Ken.Cole at smiths-aerospace.com
Tue Mar 14 14:51:13 PST 2006
Dennis,
If there is a version of Perl for AIX, the simplest way is to export to
CSV, write a Perl script to convert the CSV to an actual xls file.
Using the Spreadsheet::WriteExcel Perl module you can create an actual
xls workbook with multiple work sheets, fully formatted columns, add
formula, column widths, etc.
We have a Perl script we call csv2xls and we run it from a filePro
system command in say @wgt or @done processing. It takes 3 parameters,
the csv file name, a format file name and the output file name. The
format file tells the program how to format each column in the csv file
for excel.
Ken
> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf
> Of Dennis Malen
> Sent: Wednesday, 15 March 2006 8:12 AM
> To: filepro-list at lists.celestial.com
> Subject: export from filepro to an excel file
>
> I know this topic has been discussed before.
>
> We currently create an export file with:
>
> export multi exp=/tmp/bouncchk.xls r=1 f=1
>
> Even though we we add the extension ".xls" the file that is
> created is really SYLK (Symbolic Link).
>
> We use multi as opposed to comma delimited because if we are
> transferring a social security number that has a leading "0"
> it chops it off. That does not happen with multi. We FTP the
> file to our server and open the file in excel.
>
> The only problem we have with multi and comma delimited is
> that if we are transferring a number such as "37.50" excel
> picks up the number as "37.5".
> If we send "37.00" excel shows it as "37".
>
> We know that we can go into excel after the file is created
> and reformat the column as a decimal. Time is money and we
> don't want to have to do this.
>
> Does anyone know of any way to overcome this problem.
>
> We are on filePro 4.8 (going to 5.0 shortly) and on IBM AIX Unix.
>
> Thanks,
>
> Dennis Malen
> 516.479.5912
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
******************************************
The information contained in, or attached to, this e-mail, may contain confidential information and is intended solely for the use of the individual or entity to whom they are addressed and may be subject to legal privilege. If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager. Please do not copy it for any purpose, or disclose its contents to any other person. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company. The recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email.
******************************************
More information about the Filepro-list
mailing list