• 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
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

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?
 
reply
    Bookmark Topic Watch Topic
  • New Topic