This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Calling the Excel file using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Calling the Excel file using Java" Watch "Calling the Excel file using Java" New topic
Author

Calling the Excel file using Java

Ganapathy palanisamy
Greenhorn

Joined: May 29, 2008
Posts: 22
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]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41180
    
  45
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?


Ping & DNS - my free Android networking tools app
Ganapathy palanisamy
Greenhorn

Joined: May 29, 2008
Posts: 22
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
Marshal

Joined: Mar 22, 2005
Posts: 41180
    
  45
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling the Excel file using Java
 
Similar Threads
Reading an Excel file using Java
The specified DSN contains an architecture mismatch between the Driver and Application
How to insert data into excel file using java code?
JSP
Readin excel files from Java & output