Hello, excuse me, the use of 4.2 hxtt excel, I have two questions, please help me to answer.
The problems are as follows:
1. Is the URL written directly to the specific xlsx, such as: jdbc:excel :/c:/data/aa/xlsx;
2. When I use select * from sheet, how can I get the name of this sheet? I have many Excel to judge whether the Excel can be opened normally. But now, there is a problem that I don't know the name of my sheet. How can I query this table with SQL statement without knowing the name of the sheet?
|
������������������������:)
|
Main
webmaster@hxtt.com