I would like to know how I can set the driver properties, specifically firstRowHasNames = false, when using HXTT Excel with hibernate/spring. I've read your documentation and appreciate that I can pass a java.util.Properties instance when opening a connection, but I can't identify how to set properties when using hibernate, which hides the connection details. I've looked at your hibernate example but it doesn't help in this instance. I've tried setting a 'firstRowHasNames' property in the hibernate driver - but I get a no such property error. I've also tried creating a java.util.Properties instance and setting a 'properties' driver property - again no success.
|
You can use it in jdbc url, for instance, jdbc:excel:////testdb?firstRowHasNames=false;maxScanRows=12
|