• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to read Data From Excel File Using servlets,jsp

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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..
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The two most popular packages to read Excel files are POI and jExcelApi. You can find links to them on the AccessingFileFormats wiki page.
 
Ranch Hand
Posts: 427
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Use Jakarta POI:

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

http://oscon2006.sourceforge.net/xref/oscon2006/hello/HelloPoi.html
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
how to generates the charts in web application using jsp or servlets.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic