import Sheet To Table
Copies the rows from the sheet to the table. The copy is assumed to start at row 1, column 1 (i.e. cell A1) and proceed to the right for the number of columns in the table and the number of rows of the sheet. The copy is from the perspective of the table. That is, all columns of a row of the table are attempted to be filled from a corresponding row of the sheet. If the row of the sheet does not have cell values for the corresponding column, then the cell is interpreted as a null value when being placed in the corresponding column. It is up to the client to ensure that the cells in a row of the sheet are data type compatible with the corresponding column in the table. Any rows that cannot be transfer in their entirety are logged to the supplied PrintWriter
Parameters
the sheet that has the data to transfer to the ResultSet
the table to copy into
the number of columns in the sheet to copy into the table
the name of the schema containing the tabel
indicates the number of rows to skip from the top of the sheet. Use 1 (default) if the sheet has a header row
the number of rows to accumulate in a batch before completing a transfer
a file to hold the rows that are not transferred in a string representation