ExcelUtil

Excel's hard limit on worksheet-name length.

fastexcel has no random row access, so we materialize the sheet to walk up from the bottom. Acceptable since this is used only for sizing.

Replacement for POI's WorkbookUtil.createSafeSheetName. Replaces invalid characters with spaces and truncates to 31 chars.

Creates a new worksheet with a safe name. fastexcel does not expose an "already exists" check, so callers needing collision-free names should track the names they have used and pass a unique value.

Streams a JDBC ResultSet to a worksheet. The ResultSet is closed when done.

Writes the supplied tables of a database to one workbook, one sheet per table.

Imports each named sheet of the workbook into the table of the same name. Sheets are processed in the supplied order to satisfy referential constraints.

Opens a one-row stream just to size the header.

Opens an .xlsx workbook for reading. Returns null on missing file or read error. Caller is responsible for closing the returned ReadableWorkbook.

Translates a fastexcel cell into a "best fit" Java object.

Translates a fastexcel cell into a String.

Translates a fastexcel cell into a value compatible with PreparedStatement.setObject(idx, value) for a column whose JDBC type is jdbcType (a constant from java.sql.Types).

Reads a row into a fixed-length list, padding missing cells with null. fastexcel's Row.getCell throws on out-of-bounds indices (POI returned null), so we bounds-check before reading.

Reads a row coerced to the supplied per-column JDBC types. Cells beyond the row's Row.cellCount are read as null.

Reads an entire sheet as a list of object lists. fastexcel streams rows; the stream is closed when this returns.

Inverse of writeToExcel(Map).

Writes a value to (row, col) of the worksheet. Date/time types receive an Excel format style. fastexcel deduplicates styles internally, so the per-cell style call is cheap (unlike POI).

Writes a Map to a single-sheet workbook. NaN / +Infinity / -Infinity are written as the corresponding strings.