REading an Excel From JAva

[Raj]

Hi all
I am trying to read an Excel file from a client machine which may or maynot
have Excel Application in it. SO I need to read the Raw data from the excel
file and display it in my application. How do I do this. Can i use FileInputStream
to read raw data? How do I know where the cells end, i mean which cell contains
which data. Has anyone tried this before. Please give me some hints.

TIA
REgards
Raj

[Paul Clapham]

You can't interpret the raw data without knowing the Excel file format, and
even if you did know that it would be a monster job (the Excel object model
contains over 400 classes). What you can do is to set up an ODBC DSN that
refers to the Excel file, then use JDBC to access the data.

Raj <raja05@yahoo.com> wrote in message news:398aeab2$1@news.devx.com...
>
> Hi all
> I am trying to read an Excel file from a client machine which may or
maynot
> have Excel Application in it. SO I need to read the Raw data from the
excel
> file and display it in my application. How do I do this. Can i use
FileInputStream
> to read raw data? How do I know where the cells end, i mean which cell
contains
> which data. Has anyone tried this before. Please give me some hints.
>
> TIA
> REgards
> Raj
>

[Jo Desmet]

IBM alphaworks provides a bean that does some basic access to an excel file.
See:
http://www.alphaworks.ibm.com/alphabeans

"Paul Clapham" <pclapham@core-mark.com> wrote in message
news:398aec88@news.devx.com...
> You can't interpret the raw data without knowing the Excel file format,
and
> even if you did know that it would be a monster job (the Excel object
model
> contains over 400 classes). What you can do is to set up an ODBC DSN that
> refers to the Excel file, then use JDBC to access the data.
>
> Raj <raja05@yahoo.com> wrote in message news:398aeab2$1@news.devx.com...
> >
> > Hi all
> > I am trying to read an Excel file from a client machine which may or
> maynot
> > have Excel Application in it. SO I need to read the Raw data from the
> excel
> > file and display it in my application. How do I do this. Can i use
> FileInputStream
> > to read raw data? How do I know where the cells end, i mean which cell
> contains
> > which data. Has anyone tried this before. Please give me some hints.
> >
> > TIA
> > REgards
> > Raj
> >
>
>