Horcrux7
commented
1 day ago What you means with "standard JDBC driver"?
- It implements the JDBC interface
- But it is only read only, this means not standard conform.
- We have only implements a subset that it work with our application. But you can make PR to improve it.
I tried to set up ExcelJConnect in SQuirreL SQL Client
I have never test the driver with this tool.
No data. I tried SQL SELECT: select * from "Sheet1", but no luck.
This will not work. The driver make the sheet available as procedures and not as tables. You can try: {call Sheet1} if you enter SQL. But the tool should list the available procedures. We have implements it as procedures to make it simple without complex SQL parsing and filtering.
Or is ExcelJConnect targeted only for Java code as a component, library as seen in https://github.com/i-net-software/ExcelJConnect Usage chapter?
I am unclear what you means. If you use its inside of SQuirreL SQL then it is also only component, library.
I am looking for some simple, free, read only XLSX JDBC driver. Well known XLSX drivers are full of capabilities, most of such capabilities not needed by me, but all of such (two) drivers are quite expensive, especially for my purposes.
That we have written it. The question is which features do you need?
Hello, developers,
may I ask You, if ExcelJConnect is standard JDBC driver? How to connect to XLSX in such a tool like SQuirreL SQL Client or any other Java database GUI tool? I tried to set up ExcelJConnect in SQuirreL SQL Client, but when tried to select any data, I have no luck (message like Unsupported operation appears). JDBC URL is "jdbc:inetexcel:C:\temp\test.xlsx?hasHeaderRow=false", connected without errors, but that is all. No data. I tried SQL SELECT: select * from "Sheet1", but no luck.
Or is ExcelJConnect targeted only for Java code as a component, library as seen in https://github.com/i-net-software/ExcelJConnect Usage chapter?
I am looking for some simple, free, read only XLSX JDBC driver. Well known XLSX drivers are full of capabilities, most of such capabilities not needed by me, but all of such (two) drivers are quite expensive, especially for my purposes.
Thank You for Your answer in advance, Stepan