aspose file tools*
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 Spring in Action this week in the Spring 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