GeeCON Prague 2014*
The moose likes Other Open Source Projects and the fly likes How to read Data From Excel File Using servlets,jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "How to read Data From Excel File Using servlets,jsp" Watch "How to read Data From Excel File Using servlets,jsp" New topic
Author

How to read Data From Excel File Using servlets,jsp

nagavenkata prasadch
Greenhorn

Joined: Apr 21, 2006
Posts: 2
Requirements:
1) Read data from Excel File : Suppose the File contains: Empnumber, Empname, and Salary columuns.. There will be thousands of rows.

-> we have to read data from Excel file and validate the data( i.e, the Empnumber must be varchar, Empname must be character, and Salary must be numeric).
-> if the data is valid then store the data in the database table1.

-> if the data is not valid then find out the location of the invalid data with index number and the column which is invalid and store the invalid data with index number in a database table2.

This can be done using servlets,jsp,javascript


Expecting a reply soon from all of you guys.. I will be thankful to all of you if you give me a solution..


nvprasadch
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61315
    
  66

There is nothing in servlets or JSP that will help you read the Excel file. That is the domain of other tools.

You would use servlets and JSP to upload a file from a client system, but the actual reading of the file is independent of whether it's in a web app, a Swing app or even a command line application.

As such, I've moved this to the Other Open Source forum, where tools such as POI are discussed.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42040
    
  64
The two most popular packages to read Excel files are POI and jExcelApi. You can find links to them on the AccessingFileFormats wiki page.


Ping & DNS - my free Android networking tools app
Sean Sullivan
Ranch Hand

Joined: Sep 09, 2001
Posts: 427
Use Jakarta POI:

http://oscon2006.sourceforge.net/sullivan-poi-jackcess-oscon2006.ppt

http://oscon2006.sourceforge.net/xref/oscon2006/hello/HelloPoi.html
durgaprasad polaki
Greenhorn

Joined: Apr 26, 2011
Posts: 2
hi sir i am using poi for read data from excel sheet but i wand retrive specific data means i want real only g3 cell data .
durgaprasad polaki
Greenhorn

Joined: Apr 26, 2011
Posts: 2
how to generates the charts in web application using jsp or servlets.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to read Data From Excel File Using servlets,jsp