Hi,
There is a utility called, jxl, you can download that and put in your classpath.
Then following code will get the data from excel file. Importing this jar will do, and
I am not sure new version of weblogic do have this in built. This works fine and
efficient... simple to code too..Hope this helps...
Smita...
Workbook workbook = Workbook.getWorkbook(new java.io.File(fileName));
Sheet sheet = workbook.getSheet(0);
int rows = sheet.getRows();
int columns = sheet.getColumns();
for(int i=0; i<rows; i++)
{
Cell cell = sheet.getCell(0,i);
String type =cell.getContents();
cell = sheet.getCell(1,i);
String name =cell.getContents();
cell = sheet.getCell(2,i);
String revision =cell.getContents();
System.out.println(type + " : " + name + " : " + revision);
}
Arthur Alexander <[EMAIL PROTECTED]>:
> Quick search of GOOGLE returned this link:
>
>
> http://www.javaworld.com/javaworld/javaqa/2001-08/02-qa-0824-excel2.html
>
> ----- Original Message -----
> From: Balaji Nagarajan <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 23, 2002 6:34 AM
> Subject: Re: java and excel
>
>
> > Hi,
> > I hope this solves the problem. you can use
> > the microsoft's ODBC driver for Excel sheet and read individual
> columns as
> > if they are contained in a database table.Alternately, you can save
> the
> > excel sheet as a csv(comma separated values) format and use
> Microsoft's
> text
> > driver(ODBC).
> > regards,
> > balaji.
> > ----- Original Message -----
> > From: "Kesav, Ramesh" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 23, 2002 3:20 PM
> > Subject: java and excel
> >
> >
> > > Hi all,
> > >
> > > This may be out of topic but i need itvery urgently.
> > > i have an excel file with 4 sheets containing many data.
> > > is it possible to read a particular sheet's contents (column wise)
> > >
> > >
> > > Regards
> > > Ramesh Kesavanarayanan
> > > [EMAIL PROTECTED]
> > >
> > >
> >
> ===========================================================================
> > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > > For digest: mailto [EMAIL PROTECTED] with body: "set
> JSP-INTEREST
> > DIGEST".
> > > Some relevant FAQs on JSP/Servlets can be found at:
> > >
> > > http://archives.java.sun.com/jsp-interest.html
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.jsp
> > > http://www.jguru.com/faq/index.jsp
> > > http://www.jspinsider.com
> >
> >
> ===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://archives.java.sun.com/jsp-interest.html
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.jsp
> > http://www.jguru.com/faq/index.jsp
> > http://www.jspinsider.com
> >
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
>
-------------------------------------------------
Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
Know more at http://mail.sify.com
Take the shortest route to success!
Click here to know how http://education.sify.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
