export from filepro to an excel file

[Dennis Malen]

Ken,

We are currently in the process of upgrading to newer hardware running AIX 
and upgrading to their latest operating system, 5.3. It is our understanding 
that we will be able to run Perl on it.

Dennis
----- Original Message ----- 
From: "Cole, Ken (ABRC)" <Ken.Cole at smiths-aerospace.com>
To: <filepro-list at lists.celestial.com>
Sent: Tuesday, March 14, 2006 5:51 PM
Subject: RE: export from filepro to an excel file



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.
******************************************
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list