i-net-software / i-net-software/ExcelJConnect

Is ExcelJConnect standard JDBC driver? How to connect to XLSX in such a tool like SQuirreL SQL Client?

Open
#1 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
10
Forks
0
PR merge metrics
No merged PRs in 30d

Description

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

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.