Whenever you install MS Office on a computer, an Excel ODBC Driver
is also installed. You can then access the Excel file as a Database. Your
table name is the name of the Sheet (Sheet1$, Sheet2$, etc are the default
names, but the user can rename them) and your column names are the text that
appears in first row.
Randy
> -----Original Message-----
> From: Wang, Jianming [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 3:22 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Excel to XML
>
>
> Do you think I can odbc connection to Excel file? I am not
> using MS Access
> but using MS Excel.
>
> My project is to automatically convert all downloaded Excel
> files into XML
> using Java. I can not find any tool for this.
>
> -----Original Message-----
> From: Michael Wentzel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 12:05 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Excel to XML
>
>
> >
> > Jianming Wang
> >
>
> If you're talking strictly data you could make an odbc
> connection and suck out the data that way. If you're
> talking about the whole ball of wax(formatting, precision,
> data, etc.) you are probably going to need to right some
> native(c++) code and use the M$ components to interact
> with excel files. M$ has a knack of slipping little
> things in here and there so that it makes it difficult for
> others to do anything with their stuff(i.e. remember that
> whole M$ jvm/J++ fiasco). Alternately, I'm sure someone
> has written a commercial API to interact directly with
> excel files and get more information than just the data,
> but of course this costs money.
>
> HTH
>
>
> ---
> Michael Wentzel
> Software Developer
> Software As We Think - http://www.aswethink.com
> mailto:[EMAIL PROTECTED]
>
> - Punisher of those who cannot spell dumb!
>
