This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Reading a Data Range from an excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reading a Data Range from an excel file" Watch "Reading a Data Range from an excel file" New topic
Author

Reading a Data Range from an excel file

N Jain
Greenhorn

Joined: Mar 26, 2001
Posts: 7
How can we read a particular Data Range or a particular cell's value from an excel sheet in our java program???
Thanks,
N
Adrian Yan
Ranch Hand

Joined: Oct 02, 2000
Posts: 688
If i remember correctly:
"Select * from table where column_name between 1st and 2nd"
N Jain
Greenhorn

Joined: Mar 26, 2001
Posts: 7
Sorry i didn't get the answer of question,
let me elaborate the question :-
say i want to read the value of cell 'A12'
OR say i want to read the Range of cells 'A12-H12'???
Now how to do this?
I think now the question is more clear!
Thanks
Originally posted by Adrian Yan:
If i remember correctly:
"Select * from table where column_name between 1st and 2nd"

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading a Data Range from an excel file
 
Similar Threads
File name for Excel sheel not showing correctly in Japanese locale
How 2 Get reports
regarding excel sheet
How to store a table's data from oracle database into an excel file?
How to store an oracle database table's data to an excel file?