• 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

Calling the Excel file using Java

 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hai friends,
I am doing the program for reading the data from excel.


The above program works well to retrieve the data from excel. But i want to select date_column (see below example) particular cell value.. i.e i want to select the column heading from excel. I want to use the (ex. select empcode,name from {sheet1$] where 15.mar.10='PRESENT' but its not working..

NAME EMPCODE 12.MAR.10 15.MAR.10
------- ---------- ------------ ------------
RAM 7872997 PRESENT ABSENT
GATE 7872998 ABSENT PRESENT

guide me friends..

[edit Jan Cumps: changed all caps title to mixed case]
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
My impression is that the Excel-as-an-ODBC-source thing is not particularly stable or full-featured. Have you considered using a library such as Apache POI or jExcelApi for reading the file?
 
Ganapathy palanisamy
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have tried it, but its giving some error...
i have used the apache 3.6 poi jar file , and i saved c:\program files\apache\webapps\common\lib
but the program says




SO PLEASE PROVIDE ME ACTUAL CODE FOR THAT AND IF JAR FILES IS WRONG SEND ME THE EXACT LINK TO DOWNLOAD IT AND PATH TO SAVE IT...
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please KeepItDown.

c:\program files\apache\webapps\common\lib


What is that supposed to be? Do you really have a web app called "common"? All required jar files of a web app must be in the WEB-INF/lib directory of that web app, and you may need to restart the web app before the libraries can be used.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic