REading an Excel From JAva


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: REading an Excel From JAva

  1. #1
    Raj Guest

    REading an Excel From JAva


    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


  2. #2
    Paul Clapham Guest

    Re: REading an Excel From JAva

    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
    >




  3. #3
    Jo Desmet Guest

    Re: REading an Excel From JAva

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

    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center