Hi,
We have purchased Excel_Core_JDBC20.jar,HXTT_Common_JDBC20.jar files recently. When I am trying to upload an Excel file. I am not getting the first record. I think, the jar file assumes first row as column header/column name. But, we have a scenario like user can upload an excel file without header's (the data will be available from very first row). Please provide your suggessions
|
You can use firstRowHasNames=false connection property.
firstRowHasNames: Indicates whether the first row of worksheet data contains column names. If you use an int value n, it will use the n row of worksheet data contains column names, and data row start from the n+1 row. Default value: true
|
|
It worked. Thanks for your support
|
Main
webmaster@hxtt.com