Re: PC file Layouts ??

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

John

At 07:34 AM 12/10/97 -0500, you wrote:
>
>Hi All
>
>Ok  I have working RPG programs that can READ from and WRITE to the IFS
>directly
>using API's  (Thanks Jon, Ray, and Ted).
>
>I can make/writeto  .TXT types and .CSV types and can Read from most any
>type.
>
>I would like to read a AS/400 data base file and "Drop" that info straight
>into an Excel  .XLS
>type file.  (I know what you're gonna say,  Good luck).    I have Read in a
>simple spread sheet
>with only 2 rows and 3 columns just to look at the stuff in debug as it was
>comming across.    Weird stuff.  
>
>My question is;  does anyone know how to figure out the "File Layout" of
>various PC file types?
>Most importantly a .XLS spreadsheet type?
>
>It's like ""working with a program described file which only contains
>binary & alpha fields and you don't
>have the layout or manual""      I can reverse engineer what the different
>bytes are but it would take a 
>lot of time.  
>
>Anybody have a clue as to how to go about this??    

One way is to write out the data with tabs (ASCII x08) between fields
(cells) and carriage returns (ASCII x0D) between rows. I believe Excel will
import this directly.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---