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 )
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
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
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