Thats interesting. How do they take care of different versions of Excel that come out each year?
I can suggest one more approach also. Microsoft Excel now a days supports export to xml to get the developers out of the vagaries of native formats. So you can read that exported XML, read only the info that you want and scrap the unnecessary nodes(can write an XSL :) ). /Suresh >>-----Original Message----- >>From: Cindee Carr [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, August 03, 2004 6:01 PM >>To: [EMAIL PROTECTED] >>Subject: Re: How Can i read Data from MicroSoft Excel Sheet.... >> >> >> >>earlier this year i had the same challenge of reading and writing to excel >>with java. >> >>if found this article on the web which turned me onto the opensource "POI" >>apache project: >> http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html >> >>here is the Apache POI Website ... http://jakarta.apache.org/poi/ >> >>their documentation was very good and the product was very easy to use. i >>have since used it on a couple projects with very good results. >> >>Cindee Carr >> >> >> >> >> "Suresh Babu Koya" >> <[EMAIL PROTECTED] To: >>[EMAIL PROTECTED] >> >> M> cc: >> Sent by: "A mailing Subject: Re: >>How Can i read >>Data from MicroSoft Excel Sheet.... >> list for discussion >> about Sun >> Microsystem's Java >> Servlet API >> Technology." >> <[EMAIL PROTECTED] >> VA.SUN.COM> >> 08/03/2004 06:28 AM >> Please respond to >> skoya >> >> >> >> >> >>Create a datasource and there are so many drivers to parse the >>Excel or CSV >>file. >>That is the standard way. >> >>You need not change much code if you ever move to a database. >> >>/Suresh >> >>>>-----Original Message----- >>>>From: A mailing list for discussion about Sun Microsystem's Java Servlet >>>>API Technology. [mailto:[EMAIL PROTECTED] Behalf Of >>>>Partha Ranjan Das >>>>Sent: Tuesday, August 03, 2004 3:39 PM >>>>To: [EMAIL PROTECTED] >>>>Subject: Re: How Can i read Data from MicroSoft Excel Sheet.... >>>> >>>> >>>>Save it as a comma-separated value file and parse that file. >>>> >>>>Partha >>>> >>>> ---------- >>>> From: Nagendra Shukla [SMTP:[EMAIL PROTECTED] >>>> Sent: Tuesday, August 03, 2004 2:59 PM >>>> To: [EMAIL PROTECTED] >>>> Subject: How Can i read Data from MicroSoft Excel Sheet.... >>>> >>>> Hi All, >>>> >>>> i am faceing problem while i am reading data from >>MicroSoft Excel >>>>Sheet. >>>> Please help me. >>>> >>>> Thanks, >>>> Nagendra >>>> Nagendra Shukla >>>> >>>> >>>>__________________________________________________________________ >>>>_________ >>>> To unsubscribe, send email to [EMAIL PROTECTED] and include >>in >>>>the body >>>> of the message "signoff SERVLET-INTEREST". >>>> >>>> Archives: >>>>http://archives.java.sun.com/archives/servlet-interest.html >>>> Resources: >>>>http://java.sun.com/products/servlet/external-resources.html >>>> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html >>>>********************************************************************* >>>>Disclaimer: The information in this e-mail and any attachments is >>>>confidential / privileged. It is intended solely for the addressee or >>>>addressees. If you are not the addressee indicated in this >>>>message, you may >>>>not copy or deliver this message to anyone. In such case, you >>>>should destroy >>>>this message and kindly notify the sender by reply email. Please advise >>>>immediately if you or your employer does not consent to Internet email >>for >>>>messages of this kind. >>>>********************************************************************* >>>> >>>>__________________________________________________________________ >>>>_________ >>>>To unsubscribe, send email to [EMAIL PROTECTED] and include >>>>in the body >>>>of the message "signoff SERVLET-INTEREST". >>>> >>>>Archives: http://archives.java.sun.com/archives/servlet-interest.html >>>>Resources: http://java.sun.com/products/servlet/external-resources.html >>>>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html >>>> >> >>__________________________________________________________________ >>_________ >>To unsubscribe, send email to [EMAIL PROTECTED] and include >>in the body >>of the message "signoff SERVLET-INTEREST". >> >>Archives: http://archives.java.sun.com/archives/servlet-interest.html >>Resources: http://java.sun.com/products/servlet/external-resources.html >>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html >> >> >> >> >> >> >> >>The information contained in this message may be CONFIDENTIAL and >>is for the >>intended addressee only. Any unauthorized use, dissemination of the >>information, or copying of this message is prohibited. If you are not the >>intended addressee, please notify the sender immediately and delete this >>message. >> >> ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
