export from filepro to an excel file
Cole, Ken (ABRC)
Ken.Cole at smiths-aerospace.com
Tue Mar 14 15:28:39 PST 2006
Dennis,
In that case look at using Perl, it has such a wide variety of very
good, very useable modules for so many common task like creating xls
files.
Ken
> -----Original Message-----
> From: Dennis Malen [mailto:dmalen at malen.com]
> Sent: Wednesday, 15 March 2006 9:15 AM
> To: Cole, Ken (ABRC); filepro-list at lists.celestial.com
> Subject: Re: export from filepro to an excel file
>
> 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
>
>
>
>
>
******************************************
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