Re: Excel Files

[Ray Ontko <rayo@ONTKO.COM>]

Paige,

> We are currently creating ascii files with a ";" delimiter to get our
> files in to an Excel Spreadsheet.  We are creating an .lis and then the
> user is opening that .lis in Excel.  I am curious to know if there is
> anyone out there that has automated the process of creating the file and
> taking it in to Excel without user intervention.

I have created "csv" (comma-separated, variable field length) files
in which all numeric fields are written using formats similar to
8888888.88, and all string fields are written between double quotes,
and fields are separated by commas.  These can simply be opened by
Excel with minimal fuss by the user.  Microsoft may have a conversion
utility that you can run from the command line; I'm not sure.  Check
their website.

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/