RE: [U2] Reading Excel worksheets natively from within Universe
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 questiona 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
RE: [U2] Reading Excel worksheets natively from within Universe
If you're running UV on Windows - I think (never actually tried it) you can setup Excel worksheets as ODBC Data Sources; then use BCI to pull the data directly with a Basic program. -Original Message- From: Lee Messenger [mailto:[EMAIL PROTECTED] 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 any attachments, may contain information that is protected by law as privileged and confidential, and is transmitted for the sole use of the intended recipient. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying or retention of this e-mail or the information contained herein is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by telephone or reply e-mail, and permanently delete this e-mail from your computer system. Thank you. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Reading Excel worksheets natively from within Universe
I've used the documentation at openoffice.org (search there for excel file format) to help write code to read/write Excel directly from Arev applications (old version without all the fancy new stuff in OpenInsight), and this would be equally possible from UV. But it's a brute-force approach and I'd only recommend it after all other options are exhausted. Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Messenger Sent: Thursday, May 27, 2004 8: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 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Reading Excel worksheets natively from within Universe
While I am no longer offering NebulAnalysis at the moment, you can see from our web page that I have considerable experience with controlling Excel directly from MV. In lieu of product, we can offer consultation and development services for tight Excel integration, using NebulAnalysis as the tool of choice. People keep asking me to offer NebulAnalysis again, but I've never been able to get the critical mass of business required to keep it going. The price was super reasonable at a couple hundred bucks, but somehow people think they can do the same thing themselves with AccuTerm or wIntegrate at an even lower cost. God love um, have fun. http://nebula-rnd.com/products/analysis.htm Inquiries welcome. Regards, Tony Lee Messenger asked Does anyone have any experience reading MS Excel worksheets natively from within Universe basic? --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users