Hi All,
i downloaded the trial version of HXTT Excel Jdbc30.jar.my requirement is to act an excel file(which is in microsoft excel workbook *.xls format) as a database so that i can execute some queires on that file.i am using unix platform.where i have to give the excel filename in the qurey? is this is possible using HXTT EXcel for java?
please provide some help in resolveing this problem.
Thanking You in advance.
Regards,
Rama
|
|
For instance, a.xls at /usr/data, you can use jdbc:excel:////usr/data/a.xls as jdbc url, then "select * from sheet1;"
|
|
You an use jdbc:excel:////usr/data as jdbc url, then "select * from a.sheet1;" too.
|
Main
webmaster@hxtt.com