Any idea where to download this? I can't find it with Google.
(*Chris*)
----- Original Message -----
From: "Smita Kotnis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 7:06 AM
Subject: Re: [JSP-INTEREST] java and excel
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
