RE: [U2] Reading Excel worksheets natively from within Universe

2004-05-27 Thread Peter Olson
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 )

RE: [U2] Reading Excel worksheets natively from within Universe

2004-05-27 Thread Mark Eastwood
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

RE: [U2] Reading Excel worksheets natively from within Universe

2004-05-27 Thread Jefferson, Jim
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

RE: [U2] Reading Excel worksheets natively from within Universe

2004-05-27 Thread Tony Gravagno
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