i wrote some subroutines that creates the binary excel worksheets ( biff5 format ) in basic. but first i had to figure out how the different versions ( excel, excel97, excel2000 ) ...were structured.
there's a little help on google but not much on the ole2 file structure ( stuff after excel97 ) .i wrote a program to break out the records and convert the data ( numbers ) from ieee floating point to decimal...so to answer your question....a little bit. what do you want to know? email me off line. i hope you like playing with bits :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lee Messenger Sent: Thursday, May 27, 2004 9:19 AM To: [EMAIL PROTECTED] Subject: [U2] Reading Excel worksheets natively from within Universe Good day all, Does anyone have any experience reading MS Excel worksheets natively from within Universe basic? I know I can export the worksheets to csv or text files and then read them but much prefer to be able to read in a more automated fashion. If you have any experience and willing to share some knowledge please let me know. Thank you, Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
