Package com.northconcepts.datapipeline.excel
package com.northconcepts.datapipeline.excel
Read and write Microsoft Excel documents.
-
ClassDescriptionRepresents the styling properties that can be applied to an Excel cell.A functional interface for applying styling to Excel cells based on their location.Represents a color that can be used in Excel cells.Excel-compatible indexed color palette (BIFF legacy)The in-memory abstraction for an Excel workbook.Selects the Excel library (Apache POI or JXL) and workbook format an
ExcelDocumentuses.Provides access to Excel-specific metadata attached to aField.Represents font styling options for Excel cells.Represents a hyperlink that can be attached to an Excel cell.A functional interface that createsExcelHyperlinkinstances based on aFieldLocation.Enumeration of the types of hyperlinks supported in Excel.Obtains records from a Microsoft Excel document.Indicates how to handle failures when evaluating cell formulas/expressions.Writes records to a Microsoft Excel document.Strategy for text values longer thanExcelWriter.MAX_CELL_LENGTHcharacters, the most an Excel cell can hold.Provider forExcelDocument.ProviderType.POI_SXSSF: writes .xlsx files with Apache POI's streaming SXSSF API, keeping the last 1000 rows in memory and the rest in compressed temporary files.Read-only provider forExcelDocument.ProviderType.POI_XSSFB: reads binary .xlsb sheets from aFile, returning each cell as its formatted string.Provider forExcelDocument.ProviderType.POI_XSSF_SAX: opens .xlsx files read-only and only from aFile; new workbooks are written as withExcelDocument.ProviderType.POI_XSSF.