• 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
  • Tim Cooke
  • paul wheaton
  • Liutauras Vilda
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Scott Selikoff
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
  • Frits Walraven
Bartenders:
  • Stephan van Hulst
  • Carey Brown

Picking specific values from the Excel sheet

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Everyone
I wud appreciate your help for the following concern:-
I want to pick values from a formated excel sheet ...ie only few cell values from [sheet1] ...similar is the case of picking values from different sheets..
Certainly I can't do like
---- ResultSet rs = st.executeQuery( "Select * from [Sheet1$]" );
---rs.getString(1);

As I can not give the col name since it is a formatted sheet . and obvsly no chance of gettin the desired output
Now can anyone of guide me how to proceed?? i.e to pick values from certain specific cells
Thanks in advance
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There is nothing in JSP for working directly with MS-Office products.
You'll need to find some 3rd party libraries such as Jakarta POI

Moving to Other Open Source Projects.
 
sharma kapil
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Ben
thanks for your reply .
I need a little bit more clarification on the same ... I am not very sure of using the 3rd party libraries....i tried searching on the site but in vain ...can you please guide me little more?
The website is leading me to "Apache Cocoon" & i have no idea about this.
Do I need to download some 3rd party libraries for the same?
 
My honeysuckle is blooming this year! Now to fertilize this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic