A B C D E F G H I L M N O P Q R S T U V W X

A

AbstractCell - Class in cn.idev.excel.metadata

cell

AbstractCell() - Constructor for class cn.idev.excel.metadata.AbstractCell

AbstractCellStyleStrategy - Class in cn.idev.excel.write.style

Cell style strategy

AbstractCellStyleStrategy() - Constructor for class cn.idev.excel.write.style.AbstractCellStyleStrategy

AbstractCellValueTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Value Handler

AbstractCellValueTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.AbstractCellValueTagHandler

AbstractCellWriteHandler - Class in cn.idev.excel.write.handler

Deprecated.

Please use it directly CellWriteHandler

AbstractCellWriteHandler() - Constructor for class cn.idev.excel.write.handler.AbstractCellWriteHandler

Deprecated.

AbstractColumnWidthStyleStrategy - Class in cn.idev.excel.write.style.column

Column width style strategy

AbstractColumnWidthStyleStrategy() - Constructor for class cn.idev.excel.write.style.column.AbstractColumnWidthStyleStrategy

AbstractExcelReaderParameterBuilder<T extends AbstractExcelReaderParameterBuilder,C extends ReadBasicParameter> - Class in cn.idev.excel.read.builder

Build ExcelBuilder

AbstractExcelReaderParameterBuilder() - Constructor for class cn.idev.excel.read.builder.AbstractExcelReaderParameterBuilder

AbstractExcelWriteExecutor - Class in cn.idev.excel.write.executor

Excel write Executor

AbstractExcelWriteExecutor(WriteContext) - Constructor for class cn.idev.excel.write.executor.AbstractExcelWriteExecutor

AbstractExcelWriterParameterBuilder<T extends AbstractExcelWriterParameterBuilder,C extends WriteBasicParameter> - Class in cn.idev.excel.write.builder

Build ExcelBuilder

AbstractExcelWriterParameterBuilder() - Constructor for class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

AbstractHeadColumnWidthStyleStrategy - Class in cn.idev.excel.write.style.column

Returns the column width according to each column header

AbstractHeadColumnWidthStyleStrategy() - Constructor for class cn.idev.excel.write.style.column.AbstractHeadColumnWidthStyleStrategy

AbstractHolder - Class in cn.idev.excel.metadata

Write/read holder

AbstractHolder(BasicParameter, AbstractHolder) - Constructor for class cn.idev.excel.metadata.AbstractHolder

AbstractIgnoreExceptionReadListener<T> - Class in cn.idev.excel.event

Deprecated.

Use directly ReadListener

AbstractIgnoreExceptionReadListener() - Constructor for class cn.idev.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

AbstractMergeStrategy - Class in cn.idev.excel.write.merge

Merge strategy

AbstractMergeStrategy() - Constructor for class cn.idev.excel.write.merge.AbstractMergeStrategy

AbstractParameterBuilder<T extends AbstractParameterBuilder,C extends BasicParameter> - Class in cn.idev.excel.metadata

ExcelBuilder

AbstractParameterBuilder() - Constructor for class cn.idev.excel.metadata.AbstractParameterBuilder

AbstractReadHolder - Class in cn.idev.excel.read.metadata.holder

Read Holder

AbstractReadHolder(ReadBasicParameter, AbstractReadHolder) - Constructor for class cn.idev.excel.read.metadata.holder.AbstractReadHolder

AbstractRowHeightStyleStrategy - Class in cn.idev.excel.write.style.row

Set the row height strategy

AbstractRowHeightStyleStrategy() - Constructor for class cn.idev.excel.write.style.row.AbstractRowHeightStyleStrategy

AbstractRowWriteHandler - Class in cn.idev.excel.write.handler

Deprecated.

Please use it directly RowWriteHandler

AbstractRowWriteHandler() - Constructor for class cn.idev.excel.write.handler.AbstractRowWriteHandler

Deprecated.

AbstractSheetWriteHandler - Class in cn.idev.excel.write.handler

Deprecated.

Please use it directly SheetWriteHandler

AbstractSheetWriteHandler() - Constructor for class cn.idev.excel.write.handler.AbstractSheetWriteHandler

Deprecated.

AbstractVerticalCellStyleStrategy - Class in cn.idev.excel.write.style

Use the same style for the column

AbstractVerticalCellStyleStrategy() - Constructor for class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

AbstractWorkbookWriteHandler - Class in cn.idev.excel.write.handler

Deprecated.

Please use it directly WorkbookWriteHandler

AbstractWorkbookWriteHandler() - Constructor for class cn.idev.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

AbstractWriteHolder - Class in cn.idev.excel.write.metadata.holder

Write holder configuration

AbstractWriteHolder(WriteBasicParameter, AbstractWriteHolder) - Constructor for class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

AbstractXlsRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Abstract xls record handler

AbstractXlsRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.AbstractXlsRecordHandler

AbstractXlsxTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Abstract tag handler

AbstractXlsxTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.AbstractXlsxTagHandler

add(Collection<?>) - Method in class cn.idev.excel.write.executor.ExcelWriteAddExecutor

addContent(Collection<?>, WriteSheet) - Method in interface cn.idev.excel.write.ExcelBuilder

Deprecated.

please useExcelBuilder.addContent(Collection, WriteSheet, WriteTable)

addContent(Collection<?>, WriteSheet, WriteTable) - Method in interface cn.idev.excel.write.ExcelBuilder

WorkBook increase value

addContent(Collection<?>, WriteSheet) - Method in class cn.idev.excel.write.ExcelBuilderImpl

addContent(Collection<?>, WriteSheet, WriteTable) - Method in class cn.idev.excel.write.ExcelBuilderImpl

addFormat(String, Format) - Method in class cn.idev.excel.metadata.format.DataFormatter

Adds a new format to the available formats.

addLast(CellWriteHandler) - Method in class cn.idev.excel.write.handler.chain.CellHandlerExecutionChain

addLast(RowWriteHandler) - Method in class cn.idev.excel.write.handler.chain.RowHandlerExecutionChain

addLast(SheetWriteHandler) - Method in class cn.idev.excel.write.handler.chain.SheetHandlerExecutionChain

addLast(WorkbookWriteHandler) - Method in class cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain

addMergedRegion(CellRangeAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

addMergedRegionUnsafe(CellRangeAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

addOlePackage(byte[], String, String, String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

addPicture(byte[], int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

addToolPack(UDFFinder) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

addValidationData(DataValidation) - Method in class cn.idev.excel.metadata.csv.CsvSheet

afterCellCreate(CellWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterCellCreate(WriteSheetHolder, WriteTableHolder, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractCellWriteHandler

Deprecated.

afterCellCreate(CellWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called after the cell is created

afterCellCreate(WriteSheetHolder, WriteTableHolder, Cell, Head, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called after the cell is created

afterCellCreate(CellWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.CellHandlerExecutionChain

afterCellDataConverted(CellWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterCellDataConverted(WriteSheetHolder, WriteTableHolder, WriteCellData<?>, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractCellWriteHandler

Deprecated.

afterCellDataConverted(CellWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called after the cell data is converted

afterCellDataConverted(WriteSheetHolder, WriteTableHolder, WriteCellData<?>, Cell, Head, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called after the cell data is converted

afterCellDataConverted(CellWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.CellHandlerExecutionChain

afterCellDataConverted(WriteSheetHolder, WriteTableHolder, WriteCellData<?>, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.handler.EscapeHexCellWriteHandler

afterCellDispose(CellWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterCellDispose(WriteSheetHolder, WriteTableHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractCellWriteHandler

Deprecated.

afterCellDispose(CellWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called after all operations on the cell have been completed

afterCellDispose(WriteSheetHolder, WriteTableHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called after all operations on the cell have been completed

afterCellDispose(CellWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.CellHandlerExecutionChain

afterCellDispose(CellWriteHandlerContext) - Method in class cn.idev.excel.write.handler.impl.FillStyleCellWriteHandler

afterCellDispose(CellWriteHandlerContext) - Method in class cn.idev.excel.write.merge.AbstractMergeStrategy

afterCellDispose(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractCellStyleStrategy

afterCellDispose(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.column.AbstractColumnWidthStyleStrategy

afterRowCreate(RowWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterRowCreate(WriteSheetHolder, WriteTableHolder, Row, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractRowWriteHandler

Deprecated.

afterRowCreate(RowWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.RowHandlerExecutionChain

afterRowCreate(RowWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.RowWriteHandler

Called after the row is created

afterRowCreate(WriteSheetHolder, WriteTableHolder, Row, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.RowWriteHandler

Called after the row is created

afterRowDispose(RowWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterRowDispose(WriteSheetHolder, WriteTableHolder, Row, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractRowWriteHandler

Deprecated.

afterRowDispose(RowWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.RowHandlerExecutionChain

afterRowDispose(RowWriteHandlerContext) - Method in class cn.idev.excel.write.handler.impl.DefaultRowWriteHandler

afterRowDispose(RowWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.RowWriteHandler

Called after all operations on the row have been completed.

afterRowDispose(WriteSheetHolder, WriteTableHolder, Row, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.RowWriteHandler

Called after all operations on the row have been completed.

afterRowDispose(RowWriteHandlerContext) - Method in class cn.idev.excel.write.merge.LoopMergeStrategy

afterRowDispose(RowWriteHandlerContext) - Method in class cn.idev.excel.write.style.row.AbstractRowHeightStyleStrategy

afterSheetCreate(SheetWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterSheetCreate(SheetWriteHandlerContext, boolean) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in class cn.idev.excel.write.handler.AbstractSheetWriteHandler

Deprecated.

afterSheetCreate(SheetWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.SheetHandlerExecutionChain

afterSheetCreate(SheetWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.SheetWriteHandler

Called after the sheet is created

afterSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in interface cn.idev.excel.write.handler.SheetWriteHandler

Called after the sheet is created

afterSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in class cn.idev.excel.write.merge.OnceAbsoluteMergeStrategy

afterWorkbookCreate(WorkbookWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterWorkbookCreate(WorkbookWriteHandlerContext, boolean) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterWorkbookCreate(WriteWorkbookHolder) - Method in class cn.idev.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

afterWorkbookCreate(WorkbookWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain

afterWorkbookCreate(WorkbookWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.WorkbookWriteHandler

Called after the workbook is created

afterWorkbookCreate(WriteWorkbookHolder) - Method in interface cn.idev.excel.write.handler.WorkbookWriteHandler

Called after the workbook is created

afterWorkbookDispose(WorkbookWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

afterWorkbookDispose(WriteWorkbookHolder) - Method in class cn.idev.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

afterWorkbookDispose(WorkbookWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain

afterWorkbookDispose(WriteWorkbookHolder) - Method in class cn.idev.excel.write.handler.impl.DimensionWorkbookWriteHandler

afterWorkbookDispose(WriteWorkbookHolder) - Method in class cn.idev.excel.write.handler.impl.WriteSheetWorkbookWriteHandler

afterWorkbookDispose(WorkbookWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.WorkbookWriteHandler

Called after all operations on the workbook have been completed

afterWorkbookDispose(WriteWorkbookHolder) - Method in interface cn.idev.excel.write.handler.WorkbookWriteHandler

Called after all operations on the workbook have been completed

analysis(List<ReadSheet>, Boolean) - Method in interface cn.idev.excel.analysis.ExcelAnalyser

parse the sheet

analysis(List<ReadSheet>, Boolean) - Method in class cn.idev.excel.analysis.ExcelAnalyserImpl

Performs the analysis of the Excel file based on the specified sheets or all sheets.

AnalysisCell - Class in cn.idev.excel.write.metadata.fill

Read the cells of the template while populating the data.

AnalysisCell() - Constructor for class cn.idev.excel.write.metadata.fill.AnalysisCell

analysisContext() - Method in interface cn.idev.excel.analysis.ExcelAnalyser

get the analysis context.

analysisContext() - Method in class cn.idev.excel.analysis.ExcelAnalyserImpl

Retrieves the context object used during the Excel analysis process.

AnalysisContext - Interface in cn.idev.excel.context

A context is the main anchorage point of a excel reader.

analysisContext() - Method in class cn.idev.excel.ExcelReader

Context for the entire execution process

AnalysisContextImpl - Class in cn.idev.excel.context

AnalysisContextImpl(ReadWorkbook, ExcelTypeEnum) - Constructor for class cn.idev.excel.context.AnalysisContextImpl

AnalysisEventListener<T> - Class in cn.idev.excel.event

Receives the return of each piece of data parsed

AnalysisEventListener() - Constructor for class cn.idev.excel.event.AnalysisEventListener

analysisEventProcessor() - Method in interface cn.idev.excel.context.AnalysisContext

Event processor

analysisEventProcessor() - Method in class cn.idev.excel.context.AnalysisContextImpl

AnalysisEventProcessor - Interface in cn.idev.excel.read.processor

Event processor

ANNOTATION_DEFINE_STYLE - Static variable in class cn.idev.excel.constant.OrderConstant

Annotation style definition

applyFont(int, int, short) - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

applyFont(int, int, Font) - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

applyFont(Font) - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

applyFont(short) - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

applyFont(int, int, WriteFont) - Method in class cn.idev.excel.metadata.data.RichTextStringData

Applies a font to the specified characters of a string.

applyFont(WriteFont) - Method in class cn.idev.excel.metadata.data.RichTextStringData

Sets the font of the entire string.

AT - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

ATTRIBUTE_LOCATION - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

location attribute

ATTRIBUTE_R - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

r attribute

ATTRIBUTE_REF - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

ref attribute

ATTRIBUTE_RID - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

rId attribute

ATTRIBUTE_S - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

s attribute

ATTRIBUTE_T - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

t attribute

autoCloseStream(Boolean) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Default true

autoCloseStream(Boolean) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Default true

AutoConverter - Class in cn.idev.excel.converters

An empty converter.It's automatically converted by type.

AutoConverter() - Constructor for class cn.idev.excel.converters.AutoConverter

automaticMergeHead(Boolean) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Whether to automatically merge headers.Default is true.

automaticMergeHead() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

automaticMergeHead() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Whether need automatic merge headers.

autoSizeColumn(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

autoSizeColumn(int, boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

autoTrim(Boolean) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

Automatic trim includes sheet name and content

B

BACKSLASH - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

BACKSPACE - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

BasicParameter - Class in cn.idev.excel.metadata

Basic parameter

BasicParameter() - Constructor for class cn.idev.excel.metadata.BasicParameter

BATCH_COUNT - Static variable in class cn.idev.excel.cache.Ehcache

BATCH_COUNT - Static variable in class cn.idev.excel.read.listener.PageReadListener

Default single handle the amount of data

BeanMapUtils - Class in cn.idev.excel.util

bean utils

BeanMapUtils() - Constructor for class cn.idev.excel.util.BeanMapUtils

BeanMapUtils.FastExcelNamingPolicy - Class in cn.idev.excel.util

beforeCellCreate(CellWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

beforeCellCreate(WriteSheetHolder, WriteTableHolder, Row, Head, Integer, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractCellWriteHandler

Deprecated.

beforeCellCreate(CellWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called before create the cell

beforeCellCreate(WriteSheetHolder, WriteTableHolder, Row, Head, Integer, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.CellWriteHandler

Called before create the cell

beforeCellCreate(CellWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.CellHandlerExecutionChain

beforeRowCreate(RowWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

beforeRowCreate(WriteSheetHolder, WriteTableHolder, Integer, Integer, Boolean) - Method in class cn.idev.excel.write.handler.AbstractRowWriteHandler

Deprecated.

beforeRowCreate(RowWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.RowHandlerExecutionChain

beforeRowCreate(RowWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.RowWriteHandler

Called before create the row

beforeRowCreate(WriteSheetHolder, WriteTableHolder, Integer, Integer, Boolean) - Method in interface cn.idev.excel.write.handler.RowWriteHandler

Called before create the row

beforeSheetCreate(SheetWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

beforeSheetCreate(SheetWriteHandlerContext, boolean) - Static method in class cn.idev.excel.util.WriteHandlerUtils

beforeSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in class cn.idev.excel.write.handler.AbstractSheetWriteHandler

Deprecated.

beforeSheetCreate(SheetWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.SheetHandlerExecutionChain

beforeSheetCreate(SheetWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.SheetWriteHandler

Called before create the sheet

beforeSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in interface cn.idev.excel.write.handler.SheetWriteHandler

Called before create the sheet

beforeWorkbookCreate(WorkbookWriteHandlerContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

beforeWorkbookCreate(WorkbookWriteHandlerContext, boolean) - Static method in class cn.idev.excel.util.WriteHandlerUtils

beforeWorkbookCreate() - Method in class cn.idev.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

beforeWorkbookCreate(WorkbookWriteHandlerContext) - Method in class cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain

beforeWorkbookCreate(WorkbookWriteHandlerContext) - Method in interface cn.idev.excel.write.handler.WorkbookWriteHandler

Called before create the workbook

beforeWorkbookCreate() - Method in interface cn.idev.excel.write.handler.WorkbookWriteHandler

Called before create the workbook

BigDecimalBooleanConverter - Class in cn.idev.excel.converters.bigdecimal

BigDecimal and boolean converter This converter is responsible for converting between Java type BigDecimal and Excel's boolean type.

BigDecimalBooleanConverter() - Constructor for class cn.idev.excel.converters.bigdecimal.BigDecimalBooleanConverter

BigDecimalNumberConverter - Class in cn.idev.excel.converters.bigdecimal

Converter for handling the conversion between BigDecimal and Excel number types.

BigDecimalNumberConverter() - Constructor for class cn.idev.excel.converters.bigdecimal.BigDecimalNumberConverter

BigDecimalStringConverter - Class in cn.idev.excel.converters.bigdecimal

Converter for handling the conversion between BigDecimal and Excel string types.

BigDecimalStringConverter() - Constructor for class cn.idev.excel.converters.bigdecimal.BigDecimalStringConverter

BigIntegerBooleanConverter - Class in cn.idev.excel.converters.biginteger

BigInteger and boolean converter

BigIntegerBooleanConverter() - Constructor for class cn.idev.excel.converters.biginteger.BigIntegerBooleanConverter

BigIntegerNumberConverter - Class in cn.idev.excel.converters.biginteger

BigInteger and number converter

BigIntegerNumberConverter() - Constructor for class cn.idev.excel.converters.biginteger.BigIntegerNumberConverter

BigIntegerStringConverter - Class in cn.idev.excel.converters.biginteger

BigDecimal and string converter

BigIntegerStringConverter() - Constructor for class cn.idev.excel.converters.biginteger.BigIntegerStringConverter

BlankRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

BlankRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.BlankRecordHandler

BofRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

BofRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.BofRecordHandler

BooleanBooleanConverter - Class in cn.idev.excel.converters.booleanconverter

Boolean and boolean converter

BooleanBooleanConverter() - Constructor for class cn.idev.excel.converters.booleanconverter.BooleanBooleanConverter

BooleanEnum - Enum in cn.idev.excel.enums

Default values cannot be used for annotations.

BooleanNumberConverter - Class in cn.idev.excel.converters.booleanconverter

Boolean and number converter

BooleanNumberConverter() - Constructor for class cn.idev.excel.converters.booleanconverter.BooleanNumberConverter

BooleanStringConverter - Class in cn.idev.excel.converters.booleanconverter

Boolean and string converter

BooleanStringConverter() - Constructor for class cn.idev.excel.converters.booleanconverter.BooleanStringConverter

BooleanUtils - Class in cn.idev.excel.util

BoolErrRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

BoolErrRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.BoolErrRecordHandler

BorderStyleEnum - Enum in cn.idev.excel.enums.poi

The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.

BoundSheetRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

BoundSheetRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.BoundSheetRecordHandler

BoxingByteArrayImageConverter - Class in cn.idev.excel.converters.bytearray

Boxing Byte array and image converter

BoxingByteArrayImageConverter() - Constructor for class cn.idev.excel.converters.bytearray.BoxingByteArrayImageConverter

build(ColumnWidth) - Static method in class cn.idev.excel.metadata.property.ColumnWidthProperty

build(DateTimeFormat) - Static method in class cn.idev.excel.metadata.property.DateTimeFormatProperty

build(HeadFontStyle) - Static method in class cn.idev.excel.metadata.property.FontProperty

build(ContentFontStyle) - Static method in class cn.idev.excel.metadata.property.FontProperty

build(ContentLoopMerge) - Static method in class cn.idev.excel.metadata.property.LoopMergeProperty

build(NumberFormat) - Static method in class cn.idev.excel.metadata.property.NumberFormatProperty

build(OnceAbsoluteMerge) - Static method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

build(HeadRowHeight) - Static method in class cn.idev.excel.metadata.property.RowHeightProperty

build(ContentRowHeight) - Static method in class cn.idev.excel.metadata.property.RowHeightProperty

build(HeadStyle) - Static method in class cn.idev.excel.metadata.property.StyleProperty

build(ContentStyle) - Static method in class cn.idev.excel.metadata.property.StyleProperty

build() - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

build() - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

build() - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

build() - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

build() - Method in class cn.idev.excel.write.builder.ExcelWriterTableBuilder

build(StyleProperty, FontProperty) - Static method in class cn.idev.excel.write.metadata.style.WriteCellStyle

The source is not empty merge the data to the target.

buildCellStyle(Workbook, CellStyle, WriteCellStyle) - Static method in class cn.idev.excel.util.StyleUtil

Build cell style

buildChain(WriteHandler, boolean) - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

buildDataFormat(Workbook, DataFormatData) - Static method in class cn.idev.excel.util.StyleUtil

buildFont(Workbook, Font, WriteFont) - Static method in class cn.idev.excel.util.StyleUtil

buildFromCellType(String) - Static method in enum cn.idev.excel.enums.CellDataTypeEnum

Build data types

buildKey(Class<?>) - Static method in class cn.idev.excel.converters.ConverterKeyBuild

buildKey(Class<?>, CellDataTypeEnum) - Static method in class cn.idev.excel.converters.ConverterKeyBuild

buildRichTextString(WriteWorkbookHolder, RichTextStringData) - Static method in class cn.idev.excel.util.StyleUtil

BUILTIN_FORMATS_ALL_LANGUAGES - Static variable in class cn.idev.excel.constant.BuiltinFormats

BUILTIN_FORMATS_CN - Static variable in class cn.idev.excel.constant.BuiltinFormats

BUILTIN_FORMATS_MAP_CN - Static variable in class cn.idev.excel.constant.BuiltinFormats

BUILTIN_FORMATS_MAP_US - Static variable in class cn.idev.excel.constant.BuiltinFormats

BUILTIN_FORMATS_US - Static variable in class cn.idev.excel.constant.BuiltinFormats

BuiltinFormats - Class in cn.idev.excel.constant

Excel's built-in format conversion.Currently only supports Chinese.

BuiltinFormats() - Constructor for class cn.idev.excel.constant.BuiltinFormats

byId(int) - Static method in enum cn.idev.excel.metadata.data.ClientAnchorData.AnchorType

return the AnchorType corresponding to the code

ByteArrayImageConverter - Class in cn.idev.excel.converters.bytearray

Byte array and image converter

ByteArrayImageConverter() - Constructor for class cn.idev.excel.converters.bytearray.ByteArrayImageConverter

ByteBooleanConverter - Class in cn.idev.excel.converters.byteconverter

Byte and boolean converter

ByteBooleanConverter() - Constructor for class cn.idev.excel.converters.byteconverter.ByteBooleanConverter

ByteNumberConverter - Class in cn.idev.excel.converters.byteconverter

Byte and number converter

ByteNumberConverter() - Constructor for class cn.idev.excel.converters.byteconverter.ByteNumberConverter

ByteOrderMarkEnum - Enum in cn.idev.excel.enums

byte order mark

ByteStringConverter - Class in cn.idev.excel.converters.byteconverter

Byte and string converter

ByteStringConverter() - Constructor for class cn.idev.excel.converters.byteconverter.ByteStringConverter

C

CacheLocationEnum - Enum in cn.idev.excel.enums

cache location

Cell - Interface in cn.idev.excel.metadata

Cell

CELL_FORMULA_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

CELL_INLINE_STRING_VALUE_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

When the data is "inlineStr" his tag is "t"

CELL_RANGE_SPLIT - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

Cell range split

CELL_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

CELL_VALUE_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

CellData<T> - Class in cn.idev.excel.metadata.data

Excel internal cell data.

CellData() - Constructor for class cn.idev.excel.metadata.data.CellData

CellDataTypeEnum - Enum in cn.idev.excel.enums

excel internal data type

CellExtra - Class in cn.idev.excel.metadata

Cell extra information.

CellExtra(CellExtraTypeEnum, String, String) - Constructor for class cn.idev.excel.metadata.CellExtra

CellExtra(CellExtraTypeEnum, String, Integer, Integer) - Constructor for class cn.idev.excel.metadata.CellExtra

CellExtra(CellExtraTypeEnum, String, Integer, Integer, Integer, Integer) - Constructor for class cn.idev.excel.metadata.CellExtra

CellExtraTypeEnum - Enum in cn.idev.excel.enums

Extra data type

CellFormulaTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Handler

CellFormulaTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.CellFormulaTagHandler

CellHandlerExecutionChain - Class in cn.idev.excel.write.handler.chain

Execute the cell handler chain

CellHandlerExecutionChain(CellWriteHandler) - Constructor for class cn.idev.excel.write.handler.chain.CellHandlerExecutionChain

cellHandlerExecutionChain - Variable in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

Execute the cell handler chain

CellInlineStringValueTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell inline string value handler

CellInlineStringValueTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.CellInlineStringValueTagHandler

cellIterator() - Method in class cn.idev.excel.metadata.csv.CsvRow

CellRange - Class in cn.idev.excel.metadata

CellRange(int, int, int, int) - Constructor for class cn.idev.excel.metadata.CellRange

CellTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Handler

CellTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.CellTagHandler

CellValueTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Value Handler

CellValueTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.CellValueTagHandler

CellWriteHandler - Interface in cn.idev.excel.write.handler

intercepts handle cell creation

CellWriteHandlerContext - Class in cn.idev.excel.write.handler.context

cell context

CellWriteHandlerContext(WriteContext, WriteWorkbookHolder, WriteSheetHolder, WriteTableHolder, Row, Integer, Cell, Integer, Integer, Head, List<WriteCellData<?>>, WriteCellData<?>, Boolean, ExcelContentProperty) - Constructor for class cn.idev.excel.write.handler.context.CellWriteHandlerContext

characters(XlsxReadContext, char[], int, int) - Method in class cn.idev.excel.analysis.v07.handlers.AbstractCellValueTagHandler

characters(XlsxReadContext, char[], int, int) - Method in class cn.idev.excel.analysis.v07.handlers.AbstractXlsxTagHandler

characters(XlsxReadContext, char[], int, int) - Method in class cn.idev.excel.analysis.v07.handlers.CellFormulaTagHandler

characters(char[], int, int) - Method in class cn.idev.excel.analysis.v07.handlers.sax.SharedStringsTableHandler

characters(char[], int, int) - Method in class cn.idev.excel.analysis.v07.handlers.sax.XlsxRowHandler

characters(XlsxReadContext, char[], int, int) - Method in interface cn.idev.excel.analysis.v07.handlers.XlsxTagHandler

Read data

charset(Charset) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

charset.

charset(Charset) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

charset.

checkEmpty() - Method in class cn.idev.excel.metadata.data.CellData

Ensure that the object does not appear null

checkNotNull(T) - Static method in class cn.idev.excel.util.ListUtils

Ensures that an object reference passed as a parameter to the calling method is not null.

CLASS_CONTENT_CACHE - Static variable in class cn.idev.excel.util.ClassUtils

The cache configuration information for each of the class

ClassUtils - Class in cn.idev.excel.util

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements.

ClassUtils() - Constructor for class cn.idev.excel.util.ClassUtils

ClassUtils.ContentPropertyKey - Class in cn.idev.excel.util

ClassUtils.FieldCacheKey - Class in cn.idev.excel.util

clearFormatting() - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

ClientAnchorData - Class in cn.idev.excel.metadata.data

A client anchor is attached to an excel worksheet.

ClientAnchorData() - Constructor for class cn.idev.excel.metadata.data.ClientAnchorData

ClientAnchorData.AnchorType - Enum in cn.idev.excel.metadata.data

clone() - Method in class cn.idev.excel.metadata.data.DataFormatData

clone() - Method in class cn.idev.excel.metadata.data.FormulaData

clone() - Method in class cn.idev.excel.metadata.data.ReadCellData

clone() - Method in class cn.idev.excel.write.metadata.style.WriteFont

cloneSheet(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

cloneStyleFrom(CellStyle) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

close() - Method in class cn.idev.excel.ExcelReader

close() - Method in class cn.idev.excel.ExcelWriter

close() - Method in class cn.idev.excel.metadata.csv.CsvSheet

close() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

cn.idev.excel - package cn.idev.excel

cn.idev.excel.analysis - package cn.idev.excel.analysis

cn.idev.excel.analysis.csv - package cn.idev.excel.analysis.csv

cn.idev.excel.analysis.v03 - package cn.idev.excel.analysis.v03

cn.idev.excel.analysis.v03.handlers - package cn.idev.excel.analysis.v03.handlers

cn.idev.excel.analysis.v07 - package cn.idev.excel.analysis.v07

cn.idev.excel.analysis.v07.handlers - package cn.idev.excel.analysis.v07.handlers

cn.idev.excel.analysis.v07.handlers.sax - package cn.idev.excel.analysis.v07.handlers.sax

cn.idev.excel.annotation - package cn.idev.excel.annotation

cn.idev.excel.annotation.format - package cn.idev.excel.annotation.format

cn.idev.excel.annotation.write.style - package cn.idev.excel.annotation.write.style

cn.idev.excel.cache - package cn.idev.excel.cache

cn.idev.excel.cache.selector - package cn.idev.excel.cache.selector

cn.idev.excel.constant - package cn.idev.excel.constant

cn.idev.excel.context - package cn.idev.excel.context

cn.idev.excel.context.csv - package cn.idev.excel.context.csv

cn.idev.excel.context.xls - package cn.idev.excel.context.xls

cn.idev.excel.context.xlsx - package cn.idev.excel.context.xlsx

cn.idev.excel.converters - package cn.idev.excel.converters

cn.idev.excel.converters.bigdecimal - package cn.idev.excel.converters.bigdecimal

cn.idev.excel.converters.biginteger - package cn.idev.excel.converters.biginteger

cn.idev.excel.converters.booleanconverter - package cn.idev.excel.converters.booleanconverter

cn.idev.excel.converters.bytearray - package cn.idev.excel.converters.bytearray

cn.idev.excel.converters.byteconverter - package cn.idev.excel.converters.byteconverter

cn.idev.excel.converters.date - package cn.idev.excel.converters.date

cn.idev.excel.converters.doubleconverter - package cn.idev.excel.converters.doubleconverter

cn.idev.excel.converters.file - package cn.idev.excel.converters.file

cn.idev.excel.converters.floatconverter - package cn.idev.excel.converters.floatconverter

cn.idev.excel.converters.inputstream - package cn.idev.excel.converters.inputstream

cn.idev.excel.converters.integer - package cn.idev.excel.converters.integer

cn.idev.excel.converters.localdate - package cn.idev.excel.converters.localdate

cn.idev.excel.converters.localdatetime - package cn.idev.excel.converters.localdatetime

cn.idev.excel.converters.longconverter - package cn.idev.excel.converters.longconverter

cn.idev.excel.converters.shortconverter - package cn.idev.excel.converters.shortconverter

cn.idev.excel.converters.string - package cn.idev.excel.converters.string

cn.idev.excel.converters.url - package cn.idev.excel.converters.url

cn.idev.excel.enums - package cn.idev.excel.enums

cn.idev.excel.enums.poi - package cn.idev.excel.enums.poi

cn.idev.excel.event - package cn.idev.excel.event

cn.idev.excel.exception - package cn.idev.excel.exception

cn.idev.excel.metadata - package cn.idev.excel.metadata

cn.idev.excel.metadata.csv - package cn.idev.excel.metadata.csv

cn.idev.excel.metadata.data - package cn.idev.excel.metadata.data

cn.idev.excel.metadata.format - package cn.idev.excel.metadata.format

cn.idev.excel.metadata.property - package cn.idev.excel.metadata.property

cn.idev.excel.read.builder - package cn.idev.excel.read.builder

cn.idev.excel.read.listener - package cn.idev.excel.read.listener

cn.idev.excel.read.metadata - package cn.idev.excel.read.metadata

cn.idev.excel.read.metadata.holder - package cn.idev.excel.read.metadata.holder

cn.idev.excel.read.metadata.holder.csv - package cn.idev.excel.read.metadata.holder.csv

cn.idev.excel.read.metadata.holder.xls - package cn.idev.excel.read.metadata.holder.xls

cn.idev.excel.read.metadata.holder.xlsx - package cn.idev.excel.read.metadata.holder.xlsx

cn.idev.excel.read.metadata.property - package cn.idev.excel.read.metadata.property

cn.idev.excel.read.processor - package cn.idev.excel.read.processor

cn.idev.excel.support - package cn.idev.excel.support

cn.idev.excel.util - package cn.idev.excel.util

cn.idev.excel.write - package cn.idev.excel.write

cn.idev.excel.write.builder - package cn.idev.excel.write.builder

cn.idev.excel.write.executor - package cn.idev.excel.write.executor

cn.idev.excel.write.handler - package cn.idev.excel.write.handler

cn.idev.excel.write.handler.chain - package cn.idev.excel.write.handler.chain

cn.idev.excel.write.handler.context - package cn.idev.excel.write.handler.context

cn.idev.excel.write.handler.impl - package cn.idev.excel.write.handler.impl

cn.idev.excel.write.merge - package cn.idev.excel.write.merge

cn.idev.excel.write.metadata - package cn.idev.excel.write.metadata

cn.idev.excel.write.metadata.fill - package cn.idev.excel.write.metadata.fill

cn.idev.excel.write.metadata.holder - package cn.idev.excel.write.metadata.holder

cn.idev.excel.write.metadata.style - package cn.idev.excel.write.metadata.style

cn.idev.excel.write.property - package cn.idev.excel.write.property

cn.idev.excel.write.style - package cn.idev.excel.write.style

cn.idev.excel.write.style.column - package cn.idev.excel.write.style.column

cn.idev.excel.write.style.row - package cn.idev.excel.write.style.row

CollectionRowData - Class in cn.idev.excel.write.metadata

A collection row of data.

CollectionRowData(Collection<?>) - Constructor for class cn.idev.excel.write.metadata.CollectionRowData

ColumnWidth - Annotation Type in cn.idev.excel.annotation.write.style

Set the width of the table

columnWidth(Head, Integer) - Method in class cn.idev.excel.write.style.column.AbstractHeadColumnWidthStyleStrategy

Returns the column width corresponding to each column head.

columnWidth(Head, Integer) - Method in class cn.idev.excel.write.style.column.SimpleColumnWidthStyleStrategy

ColumnWidthProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

ColumnWidthProperty(Integer) - Constructor for class cn.idev.excel.metadata.property.ColumnWidthProperty

combineExcelContentProperty(ExcelContentProperty, ExcelContentProperty) - Static method in class cn.idev.excel.util.ClassUtils

COMMA - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

CommentData - Class in cn.idev.excel.metadata.data

comment

CommentData() - Constructor for class cn.idev.excel.metadata.data.CommentData

ConfigurationHolder - Interface in cn.idev.excel.metadata

Get the corresponding holder

CONTENT_CACHE - Static variable in class cn.idev.excel.util.ClassUtils

The cache configuration information for each of the class

contentCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head.

contentCellStyle(Head) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head

ContentFontStyle - Annotation Type in cn.idev.excel.annotation.write.style

Custom content styles.

ContentLoopMerge - Annotation Type in cn.idev.excel.annotation.write.style

The regions of the loop merge

ContentPropertyKey() - Constructor for class cn.idev.excel.util.ClassUtils.ContentPropertyKey

ContentRowHeight - Annotation Type in cn.idev.excel.annotation.write.style

Set the height of each table

ContentStyle - Annotation Type in cn.idev.excel.annotation.write.style

Custom content styles

convert(CellWriteHandlerContext) - Method in class cn.idev.excel.write.executor.AbstractExcelWriteExecutor

Converter<T> - Interface in cn.idev.excel.converters

Convert between Java objects and excel objects

converterAndSet(CellWriteHandlerContext) - Method in class cn.idev.excel.write.executor.AbstractExcelWriteExecutor

Transform the data and then to set into the cell

ConverterKey() - Constructor for class cn.idev.excel.converters.ConverterKeyBuild.ConverterKey

ConverterKeyBuild - Class in cn.idev.excel.converters

Converter unique key.Consider that you can just use class as the key.

ConverterKeyBuild() - Constructor for class cn.idev.excel.converters.ConverterKeyBuild

ConverterKeyBuild.ConverterKey - Class in cn.idev.excel.converters

converterMap() - Method in class cn.idev.excel.metadata.AbstractHolder

converterMap() - Method in interface cn.idev.excel.metadata.ConfigurationHolder

What converter does the currently operated cell need to execute

ConverterUtils - Class in cn.idev.excel.util

Converting objects

convertToExcelData(BigDecimal, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalBooleanConverter

Converts Java type BigDecimal to Excel cell data.

convertToExcelData(BigDecimal, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalNumberConverter

Converts a BigDecimal object to Excel cell data.

convertToExcelData(BigDecimal, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalStringConverter

Converts a BigDecimal object to Excel cell data in string format.

convertToExcelData(BigInteger, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.biginteger.BigIntegerBooleanConverter

convertToExcelData(BigInteger, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.biginteger.BigIntegerNumberConverter

convertToExcelData(BigInteger, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.biginteger.BigIntegerStringConverter

convertToExcelData(Boolean, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.booleanconverter.BooleanBooleanConverter

convertToExcelData(Boolean, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.booleanconverter.BooleanNumberConverter

convertToExcelData(Boolean, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.booleanconverter.BooleanStringConverter

convertToExcelData(Byte[], ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bytearray.BoxingByteArrayImageConverter

convertToExcelData(byte[], ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bytearray.ByteArrayImageConverter

convertToExcelData(Byte, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.byteconverter.ByteBooleanConverter

convertToExcelData(Byte, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.byteconverter.ByteNumberConverter

convertToExcelData(Byte, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.byteconverter.ByteStringConverter

convertToExcelData(T, ExcelContentProperty, GlobalConfiguration) - Method in interface cn.idev.excel.converters.Converter

Convert Java objects to excel objects

convertToExcelData(WriteConverterContext<T>) - Method in interface cn.idev.excel.converters.Converter

Convert Java objects to excel objects

convertToExcelData(Date, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.date.DateDateConverter

convertToExcelData(Date, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.date.DateNumberConverter

convertToExcelData(Date, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.date.DateStringConverter

convertToExcelData(Double, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.doubleconverter.DoubleBooleanConverter

convertToExcelData(Double, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.doubleconverter.DoubleNumberConverter

convertToExcelData(Double, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.doubleconverter.DoubleStringConverter

convertToExcelData(File, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.file.FileImageConverter

convertToExcelData(Float, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.floatconverter.FloatBooleanConverter

convertToExcelData(WriteConverterContext<Float>) - Method in class cn.idev.excel.converters.floatconverter.FloatNumberConverter

convertToExcelData(Float, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.floatconverter.FloatStringConverter

convertToExcelData(InputStream, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.inputstream.InputStreamImageConverter

convertToExcelData(Integer, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.integer.IntegerBooleanConverter

convertToExcelData(WriteConverterContext<Integer>) - Method in class cn.idev.excel.converters.integer.IntegerNumberConverter

convertToExcelData(Integer, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.integer.IntegerStringConverter

convertToExcelData(LocalDate, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdate.LocalDateDateConverter

convertToExcelData(LocalDate, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdate.LocalDateNumberConverter

convertToExcelData(LocalDate, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdate.LocalDateStringConverter

convertToExcelData(LocalDateTime, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeDateConverter

convertToExcelData(LocalDateTime, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeNumberConverter

convertToExcelData(LocalDateTime, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeStringConverter

convertToExcelData(Long, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.longconverter.LongBooleanConverter

convertToExcelData(WriteConverterContext<Long>) - Method in class cn.idev.excel.converters.longconverter.LongNumberConverter

convertToExcelData(Long, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.longconverter.LongStringConverter

convertToExcelData(Short, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.shortconverter.ShortBooleanConverter

convertToExcelData(WriteConverterContext<Short>) - Method in class cn.idev.excel.converters.shortconverter.ShortNumberConverter

convertToExcelData(Short, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.shortconverter.ShortStringConverter

convertToExcelData(String, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringBooleanConverter

convertToExcelData(String, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringErrorConverter

convertToExcelData(String, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringImageConverter

convertToExcelData(String, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringNumberConverter

convertToExcelData(String, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringStringConverter

convertToExcelData(URL, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.url.UrlImageConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalBooleanConverter

Converts Excel cell data to Java type BigDecimal.

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalNumberConverter

Converts Excel cell data to a BigDecimal object.

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalStringConverter

Converts Excel cell data to a BigDecimal object.

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.biginteger.BigIntegerBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.biginteger.BigIntegerNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.biginteger.BigIntegerStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.booleanconverter.BooleanBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.booleanconverter.BooleanNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.booleanconverter.BooleanStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.byteconverter.ByteBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.byteconverter.ByteNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.byteconverter.ByteStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in interface cn.idev.excel.converters.Converter

Convert excel objects to Java objects

convertToJavaData(ReadConverterContext<?>) - Method in interface cn.idev.excel.converters.Converter

Convert excel objects to Java objects

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.date.DateNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.date.DateStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.doubleconverter.DoubleBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.doubleconverter.DoubleNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.doubleconverter.DoubleStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.floatconverter.FloatBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.floatconverter.FloatNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.floatconverter.FloatStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.integer.IntegerBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.integer.IntegerNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.integer.IntegerStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdate.LocalDateNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdate.LocalDateStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.longconverter.LongBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.longconverter.LongNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.longconverter.LongStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.shortconverter.ShortBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.shortconverter.ShortNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.shortconverter.ShortStringConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringBooleanConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringErrorConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringNumberConverter

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class cn.idev.excel.converters.string.StringStringConverter

convertToJavaObject(ReadCellData<?>, Field, ExcelContentProperty, Map<ConverterKeyBuild.ConverterKey, Converter<?>>, AnalysisContext, Integer, Integer) - Static method in class cn.idev.excel.util.ConverterUtils

Convert it into a Java object

convertToJavaObject(ReadCellData<?>, Field, Class<?>, Class<?>, ExcelContentProperty, Map<ConverterKeyBuild.ConverterKey, Converter<?>>, AnalysisContext, Integer, Integer) - Static method in class cn.idev.excel.util.ConverterUtils

Convert it into a Java object

convertToStringMap(Map<Integer, ReadCellData<?>>, AnalysisContext) - Static method in class cn.idev.excel.util.ConverterUtils

Convert it into a String map

CoordinateData - Class in cn.idev.excel.metadata.data

coordinate.

CoordinateData() - Constructor for class cn.idev.excel.metadata.data.CoordinateData

copy(InputStream, OutputStream) - Static method in class cn.idev.excel.util.IoUtils

Copies bytes

copyBasicParameter(ReadSheet) - Method in class cn.idev.excel.read.metadata.ReadSheet

CountTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Handler

CountTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.CountTagHandler

CR - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

line break

create(Object) - Static method in class cn.idev.excel.util.BeanMapUtils

Helper method to create a new BeanMap.

createCacheTmpFile() - Static method in class cn.idev.excel.util.FileUtils

createCell(int) - Method in class cn.idev.excel.metadata.csv.CsvRow

createCell(int, CellType) - Method in class cn.idev.excel.metadata.csv.CsvRow

createCell(Row, int) - Static method in class cn.idev.excel.util.WorkBookUtil

createCell(Row, int, CellStyle) - Static method in class cn.idev.excel.util.WorkBookUtil

createCell(Row, int, CellStyle, String) - Static method in class cn.idev.excel.util.WorkBookUtil

createCell(Row, int, String) - Static method in class cn.idev.excel.util.WorkBookUtil

createCellStyle() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createCellStyle(WriteCellStyle, CellStyle, CellDataTypeEnum) - Method in class cn.idev.excel.write.metadata.holder.WriteWorkbookHolder

create a cell style.

createCellWriteHandlerContext(WriteContext, Row, Integer, Head, Integer, Integer, Boolean, ExcelContentProperty) - Static method in class cn.idev.excel.util.WriteHandlerUtils

createDataFormat() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createDataFormat(DataFormatData, boolean) - Method in class cn.idev.excel.write.metadata.holder.WriteWorkbookHolder

create a data format.

createDirectory(File) - Static method in class cn.idev.excel.util.FileUtils

createDrawingPatriarch() - Method in class cn.idev.excel.metadata.csv.CsvSheet

createEvaluationWorkbook() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createFont() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createFont(WriteFont, Font, boolean) - Method in class cn.idev.excel.write.metadata.holder.WriteWorkbookHolder

create a font.

createFreezePane(int, int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

createFreezePane(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

createName() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createPoiFilesDirectory() - Static method in class cn.idev.excel.util.FileUtils

createRow(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

createRow(Sheet, int) - Static method in class cn.idev.excel.util.WorkBookUtil

createRowWriteHandlerContext(WriteContext, Integer, Integer, Boolean) - Static method in class cn.idev.excel.util.WriteHandlerUtils

createSheet() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createSheet(String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

createSheet(Workbook, String) - Static method in class cn.idev.excel.util.WorkBookUtil

createSheetWriteHandlerContext(WriteContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

createSplitPane(int, int, int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

createSplitPane(int, int, int, int, PaneType) - Method in class cn.idev.excel.metadata.csv.CsvSheet

createTempDirectory(String) - Method in class cn.idev.excel.util.FastExcelTempFileCreationStrategy

createTempFile(String, String) - Method in class cn.idev.excel.util.FastExcelTempFileCreationStrategy

createTmpFile(String) - Static method in class cn.idev.excel.util.FileUtils

createWorkBook(WriteWorkbookHolder) - Static method in class cn.idev.excel.util.WorkBookUtil

createWorkbookWriteHandlerContext(WriteContext) - Static method in class cn.idev.excel.util.WriteHandlerUtils

CRLF - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

csv() - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

csv() - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

CsvCell - Class in cn.idev.excel.metadata.csv

csv cell

CsvCell(CsvWorkbook, CsvSheet, CsvRow, Integer, CellType) - Constructor for class cn.idev.excel.metadata.csv.CsvCell

CsvCellStyle - Class in cn.idev.excel.metadata.csv

csv cell style

CsvCellStyle(Short) - Constructor for class cn.idev.excel.metadata.csv.CsvCellStyle

CsvConstant - Class in cn.idev.excel.metadata.csv

Constant definitions for CSV file processing.

CsvDataFormat - Class in cn.idev.excel.metadata.csv

format data

CsvDataFormat(Locale) - Constructor for class cn.idev.excel.metadata.csv.CsvDataFormat

CsvExcelReadExecutor - Class in cn.idev.excel.analysis.csv

CSV Excel Read Executor, responsible for reading and processing CSV files.

CsvExcelReadExecutor(CsvReadContext) - Constructor for class cn.idev.excel.analysis.csv.CsvExcelReadExecutor

csvFormat - Variable in class cn.idev.excel.metadata.csv.CsvSheet

format

CsvReadContext - Interface in cn.idev.excel.context.csv

A context is the main anchorage point of a ls xls reader.

CsvReaderBuilder - Class in cn.idev.excel.read.builder

Builder for CSV file reading

CsvReaderBuilder(ReadWorkbook) - Constructor for class cn.idev.excel.read.builder.CsvReaderBuilder

csvReadSheetHolder() - Method in interface cn.idev.excel.context.csv.CsvReadContext

All information about the sheet you are currently working on.

csvReadSheetHolder() - Method in class cn.idev.excel.context.csv.DefaultCsvReadContext

CsvReadSheetHolder - Class in cn.idev.excel.read.metadata.holder.csv

sheet holder

CsvReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class cn.idev.excel.read.metadata.holder.csv.CsvReadSheetHolder

csvReadWorkbookHolder() - Method in interface cn.idev.excel.context.csv.CsvReadContext

All information about the workbook you are currently working on.

csvReadWorkbookHolder() - Method in class cn.idev.excel.context.csv.DefaultCsvReadContext

CsvReadWorkbookHolder - Class in cn.idev.excel.read.metadata.holder.csv

Workbook holder

CsvReadWorkbookHolder(ReadWorkbook) - Constructor for class cn.idev.excel.read.metadata.holder.csv.CsvReadWorkbookHolder

CsvRichTextString - Class in cn.idev.excel.metadata.csv

rich text string

CsvRichTextString(String) - Constructor for class cn.idev.excel.metadata.csv.CsvRichTextString

CsvRow - Class in cn.idev.excel.metadata.csv

csv row

CsvRow(CsvWorkbook, CsvSheet, Integer) - Constructor for class cn.idev.excel.metadata.csv.CsvRow

CsvSheet - Class in cn.idev.excel.metadata.csv

csv sheet

CsvSheet(CsvWorkbook, Appendable) - Constructor for class cn.idev.excel.metadata.csv.CsvSheet

CsvWorkbook - Class in cn.idev.excel.metadata.csv

csv workbook

CsvWorkbook(Appendable, Locale, Boolean, Boolean, Charset, Boolean) - Constructor for class cn.idev.excel.metadata.csv.CsvWorkbook

CsvWriterBuilder - Class in cn.idev.excel.write.builder

Builder for CSV file writing

CsvWriterBuilder(WriteWorkbook) - Constructor for class cn.idev.excel.write.builder.CsvWriterBuilder

currentReadHolder() - Method in interface cn.idev.excel.context.AnalysisContext

The current read operation corresponds to the readSheetHolder or readWorkbookHolder

currentReadHolder() - Method in class cn.idev.excel.context.AnalysisContextImpl

currentSheet(ReadSheet) - Method in interface cn.idev.excel.context.AnalysisContext

Select the current table

currentSheet(ReadSheet) - Method in class cn.idev.excel.context.AnalysisContextImpl

currentSheet(WriteSheet, WriteTypeEnum) - Method in interface cn.idev.excel.context.WriteContext

If the current sheet already exists, select it; if not, create it

currentSheet(WriteSheet, WriteTypeEnum) - Method in class cn.idev.excel.context.WriteContextImpl

Sets the current sheet for writing.

currentTable(WriteTable) - Method in interface cn.idev.excel.context.WriteContext

If the current table already exists, select it; if not, create it

currentTable(WriteTable) - Method in class cn.idev.excel.context.WriteContextImpl

Sets the current table for writing.

currentWriteHolder() - Method in interface cn.idev.excel.context.WriteContext

Configuration of currently operated cell.

currentWriteHolder() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the current write holder.

CUSTOM_HEIGHT - Static variable in class cn.idev.excel.util.PoiUtils

Whether to customize the height

customHeight(Row) - Static method in class cn.idev.excel.util.PoiUtils

Whether to customize the height

customObject(Object) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

This object can be read in the Listener ReadListener.invoke(Object, AnalysisContext) AnalysisContext.getCustom()

D

DataFormatData - Class in cn.idev.excel.metadata.data

data format

DataFormatData() - Constructor for class cn.idev.excel.metadata.data.DataFormatData

dataFormatData(int) - Method in class cn.idev.excel.read.metadata.holder.xlsx.XlsxReadWorkbookHolder

DataFormatter - Class in cn.idev.excel.metadata.format

Written with reference to DataFormatter.Made some optimizations for date conversion.

DataFormatter(Boolean, Locale, Boolean) - Constructor for class cn.idev.excel.metadata.format.DataFormatter

Creates a formatter using the given locale.

DATE_FORMAT_10 - Static variable in class cn.idev.excel.util.DateUtils

DATE_FORMAT_14 - Static variable in class cn.idev.excel.util.DateUtils

DATE_FORMAT_16 - Static variable in class cn.idev.excel.util.DateUtils

DATE_FORMAT_16_FORWARD_SLASH - Static variable in class cn.idev.excel.util.DateUtils

DATE_FORMAT_17 - Static variable in class cn.idev.excel.util.DateUtils

DATE_FORMAT_19 - Static variable in class cn.idev.excel.util.DateUtils

DATE_FORMAT_19_FORWARD_SLASH - Static variable in class cn.idev.excel.util.DateUtils

DateDateConverter - Class in cn.idev.excel.converters.date

Date and date converter

DateDateConverter() - Constructor for class cn.idev.excel.converters.date.DateDateConverter

DateNumberConverter - Class in cn.idev.excel.converters.date

Date and number converter

DateNumberConverter() - Constructor for class cn.idev.excel.converters.date.DateNumberConverter

DateStringConverter - Class in cn.idev.excel.converters.date

Date and string converter

DateStringConverter() - Constructor for class cn.idev.excel.converters.date.DateStringConverter

DateTimeFormat - Annotation Type in cn.idev.excel.annotation.format

Convert date format.

DateTimeFormatProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

DateTimeFormatProperty(String, Boolean) - Constructor for class cn.idev.excel.metadata.property.DateTimeFormatProperty

DateUtils - Class in cn.idev.excel.util

Date utils

DateWindow1904RecordHandler - Class in cn.idev.excel.analysis.v03.handlers

DateWindow1904Record Handler

DateWindow1904RecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.DateWindow1904RecordHandler

DAY_MILLISECONDS - Static variable in class cn.idev.excel.util.DateUtils

DEBUG_CACHE_MISS_SIZE - Static variable in class cn.idev.excel.cache.Ehcache

DEBUG_WRITE_SIZE - Static variable in class cn.idev.excel.cache.Ehcache

declaredExcelContentProperty(Map<?, ?>, Class<?>, String, ConfigurationHolder) - Static method in class cn.idev.excel.util.ClassUtils

Calculate the configuration information for the class

declaredFields(Class<?>, ConfigurationHolder) - Static method in class cn.idev.excel.util.ClassUtils

Parsing field in the class

DEFAULT_DEFINE_STYLE - Static variable in class cn.idev.excel.constant.OrderConstant

The system's own style

DEFAULT_ORDER - Static variable in class cn.idev.excel.constant.OrderConstant

default order.

DEFAULT_WRITE_HANDLER_LIST - Static variable in class cn.idev.excel.write.handler.DefaultWriteHandlerLoader

DefaultAnalysisEventProcessor - Class in cn.idev.excel.read.processor

Analysis event

DefaultAnalysisEventProcessor() - Constructor for class cn.idev.excel.read.processor.DefaultAnalysisEventProcessor

defaultClassGeneric - Static variable in class cn.idev.excel.util.ConverterUtils

DefaultConverterLoader - Class in cn.idev.excel.converters

Load default handler

DefaultConverterLoader() - Constructor for class cn.idev.excel.converters.DefaultConverterLoader

DefaultCsvReadContext - Class in cn.idev.excel.context.csv

A context is the main anchorage point of a ls xls reader.

DefaultCsvReadContext(ReadWorkbook, ExcelTypeEnum) - Constructor for class cn.idev.excel.context.csv.DefaultCsvReadContext

defaultDateFormat - Static variable in class cn.idev.excel.util.DateUtils

defaultImageType - Static variable in class cn.idev.excel.util.FileTypeUtils

Default image type

defaultLocalDateFormat - Static variable in class cn.idev.excel.util.DateUtils

DefaultRowWriteHandler - Class in cn.idev.excel.write.handler.impl

Default row handler.

DefaultRowWriteHandler() - Constructor for class cn.idev.excel.write.handler.impl.DefaultRowWriteHandler

DefaultStyle - Class in cn.idev.excel.write.style

The default styles

DefaultStyle() - Constructor for class cn.idev.excel.write.style.DefaultStyle

DefaultWriteHandlerLoader - Class in cn.idev.excel.write.handler

Load default handler

DefaultWriteHandlerLoader() - Constructor for class cn.idev.excel.write.handler.DefaultWriteHandlerLoader

DefaultXlsReadContext - Class in cn.idev.excel.context.xls

A context is the main anchorage point of a ls xls reader.

DefaultXlsReadContext(ReadWorkbook, ExcelTypeEnum) - Constructor for class cn.idev.excel.context.xls.DefaultXlsReadContext

DefaultXlsxReadContext - Class in cn.idev.excel.context.xlsx

A context is the main anchorage point of a ls xls reader.

DefaultXlsxReadContext(ReadWorkbook, ExcelTypeEnum) - Constructor for class cn.idev.excel.context.xlsx.DefaultXlsxReadContext

DEFINE_STYLE - Static variable in class cn.idev.excel.constant.OrderConstant

Define style.

delete(File) - Static method in class cn.idev.excel.util.FileUtils

delete file

DELETE_FILES_ON_EXIT - Static variable in class cn.idev.excel.util.FastExcelTempFileCreationStrategy

To use files.deleteOnExit after clean JVM exit, set the -Dpoi.delete.tmp.files.on.exit JVM property

delimiter(String) - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

Sets the delimiter character

delimiter(String) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

Sets the delimiter character

destroy() - Method in class cn.idev.excel.cache.Ehcache

destroy() - Method in class cn.idev.excel.cache.MapCache

destroy() - Method in interface cn.idev.excel.cache.ReadCache

Called when the excel read is complete

destroy() - Method in class cn.idev.excel.cache.XlsCache

DIMENSION_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

DimensionWorkbookWriteHandler - Class in cn.idev.excel.write.handler.impl

Handle the problem of unable to write dimension.

DimensionWorkbookWriteHandler() - Constructor for class cn.idev.excel.write.handler.impl.DimensionWorkbookWriteHandler

doAfterAllAnalysed(AnalysisContext) - Method in class cn.idev.excel.event.SyncReadListener

doAfterAllAnalysed(AnalysisContext) - Method in class cn.idev.excel.read.listener.ModelBuildEventListener

doAfterAllAnalysed(AnalysisContext) - Method in class cn.idev.excel.read.listener.PageReadListener

doAfterAllAnalysed(AnalysisContext) - Method in interface cn.idev.excel.read.listener.ReadListener

if have something to do after all analysis

doFill(Object) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

doFill(Object, FillConfig) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

doFill(Supplier<Object>) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

doFill(Supplier<Object>, FillConfig) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

doRead() - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

doRead() - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

Sax read

doReadAll() - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

doReadAllSync() - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Synchronous reads return results

doReadSync() - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

synchronous read and returns the results

doReadSync() - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

Synchronous reads return results

DOUBLE_QUOTE - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

DoubleBooleanConverter - Class in cn.idev.excel.converters.doubleconverter

Double and boolean converter

DoubleBooleanConverter() - Constructor for class cn.idev.excel.converters.doubleconverter.DoubleBooleanConverter

DoubleNumberConverter - Class in cn.idev.excel.converters.doubleconverter

Double and number converter

DoubleNumberConverter() - Constructor for class cn.idev.excel.converters.doubleconverter.DoubleNumberConverter

DoubleStringConverter - Class in cn.idev.excel.converters.doubleconverter

Double and string converter

DoubleStringConverter() - Constructor for class cn.idev.excel.converters.doubleconverter.DoubleStringConverter

doWrite(Collection<?>) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

doWrite(Supplier<Collection<?>>) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

doWrite(Collection<?>) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

doWrite(Supplier<Collection<?>>) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

doWrite(Collection<?>) - Method in class cn.idev.excel.write.builder.ExcelWriterTableBuilder

doWrite(Supplier<Collection<?>>) - Method in class cn.idev.excel.write.builder.ExcelWriterTableBuilder

DummyRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

DummyRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.DummyRecordHandler

E

EasyExcel - Class in cn.idev.excel

This is actually FastExcelFactory, and short names look better.

EasyExcel() - Constructor for class cn.idev.excel.EasyExcel

Ehcache - Class in cn.idev.excel.cache

Default cache

Ehcache(Integer) - Constructor for class cn.idev.excel.cache.Ehcache

Deprecated.

Ehcache(Integer, Integer) - Constructor for class cn.idev.excel.cache.Ehcache

EMPTY - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

EMPTY - Static variable in class cn.idev.excel.metadata.property.ExcelContentProperty

EMPTY - Static variable in class cn.idev.excel.util.StringUtils

The empty String "".

endElement(XlsxReadContext, String) - Method in class cn.idev.excel.analysis.v07.handlers.AbstractXlsxTagHandler

endElement(XlsxReadContext, String) - Method in class cn.idev.excel.analysis.v07.handlers.CellFormulaTagHandler

endElement(XlsxReadContext, String) - Method in class cn.idev.excel.analysis.v07.handlers.CellTagHandler

endElement(XlsxReadContext, String) - Method in class cn.idev.excel.analysis.v07.handlers.RowTagHandler

endElement(String, String, String) - Method in class cn.idev.excel.analysis.v07.handlers.sax.SharedStringsTableHandler

endElement(String, String, String) - Method in class cn.idev.excel.analysis.v07.handlers.sax.XlsxRowHandler

endElement(XlsxReadContext, String) - Method in interface cn.idev.excel.analysis.v07.handlers.XlsxTagHandler

End handle

endRow(AnalysisContext) - Method in interface cn.idev.excel.read.processor.AnalysisEventProcessor

End row

endRow(AnalysisContext) - Method in class cn.idev.excel.read.processor.DefaultAnalysisEventProcessor

Ends the processing of a row.

endSheet(AnalysisContext) - Method in interface cn.idev.excel.read.processor.AnalysisEventProcessor

Notify after all analysed

endSheet(AnalysisContext) - Method in class cn.idev.excel.read.processor.DefaultAnalysisEventProcessor

EOF - Static variable in class cn.idev.excel.util.IoUtils

EofRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

EofRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.EofRecordHandler

equals(CharSequence, CharSequence) - Static method in class cn.idev.excel.util.StringUtils

Compares two CharSequences, returning true if they represent equal sequences of characters.

equals(Object) - Method in class cn.idev.excel.write.metadata.fill.AnalysisCell

escape(Character) - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

Sets the escape character.

escape(Character) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

Sets the escape character.

EscapeHexCellWriteHandler - Class in cn.idev.excel.write.handler

A cell write handler that escapes _x[0-9A-Fa-f]{4}_ format strings to prevent POI from automatically decoding them.

EscapeHexCellWriteHandler() - Constructor for class cn.idev.excel.write.handler.EscapeHexCellWriteHandler

EternalReadCacheSelector - Class in cn.idev.excel.cache.selector

Choose a eternal cache

EternalReadCacheSelector(ReadCache) - Constructor for class cn.idev.excel.cache.selector.EternalReadCacheSelector

EX_CACHE - Static variable in class cn.idev.excel.util.FileUtils

EXCEL_MATH_CONTEXT - Static variable in class cn.idev.excel.constant.FastExcelConstants

Excel by default with 15 to store Numbers, and the double in Java can use to store number 17, led to the accuracy will be a problem.

ExcelAnalyser - Interface in cn.idev.excel.analysis

Excel file analyser

ExcelAnalyserImpl - Class in cn.idev.excel.analysis

A class that implements the ExcelAnalyser interface for analyzing Excel files.

ExcelAnalyserImpl(ReadWorkbook) - Constructor for class cn.idev.excel.analysis.ExcelAnalyserImpl

ExcelAnalysisException - Exception in cn.idev.excel.exception

ExcelAnalysisException() - Constructor for exception cn.idev.excel.exception.ExcelAnalysisException

ExcelAnalysisException(String) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisException

ExcelAnalysisException(String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisException

ExcelAnalysisException(Throwable) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisException

ExcelAnalysisStopException - Exception in cn.idev.excel.exception

Throw the exception when you need to stop This exception will stop the entire excel parsing.

ExcelAnalysisStopException() - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopException(String) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopException(String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopException(Throwable) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopSheetException - Exception in cn.idev.excel.exception

Throw the exception when you need to stop This exception will only stop the parsing of the current sheet.

ExcelAnalysisStopSheetException() - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopSheetException

ExcelAnalysisStopSheetException(String) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopSheetException

ExcelAnalysisStopSheetException(String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopSheetException

ExcelAnalysisStopSheetException(Throwable) - Constructor for exception cn.idev.excel.exception.ExcelAnalysisStopSheetException

ExcelBuilder - Interface in cn.idev.excel.write

ExcelBuilderImpl - Class in cn.idev.excel.write

ExcelBuilderImpl(WriteWorkbook) - Constructor for class cn.idev.excel.write.ExcelBuilderImpl

ExcelCommonException - Exception in cn.idev.excel.exception

ExcelCommonException() - Constructor for exception cn.idev.excel.exception.ExcelCommonException

ExcelCommonException(String) - Constructor for exception cn.idev.excel.exception.ExcelCommonException

ExcelCommonException(String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelCommonException

ExcelCommonException(Throwable) - Constructor for exception cn.idev.excel.exception.ExcelCommonException

ExcelContentProperty - Class in cn.idev.excel.metadata.property

ExcelContentProperty() - Constructor for class cn.idev.excel.metadata.property.ExcelContentProperty

ExcelDataConvertException - Exception in cn.idev.excel.exception

Data convert exception

ExcelDataConvertException(Integer, Integer, CellData<?>, ExcelContentProperty, String) - Constructor for exception cn.idev.excel.exception.ExcelDataConvertException

ExcelDataConvertException(Integer, Integer, CellData<?>, ExcelContentProperty, String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelDataConvertException

excelExecutor() - Method in interface cn.idev.excel.analysis.ExcelAnalyser

Acquisition excel executor

excelExecutor() - Method in class cn.idev.excel.analysis.ExcelAnalyserImpl

Retrieves the executor used for performing the Excel analysis.

excelExecutor() - Method in class cn.idev.excel.ExcelReader

Current executor

ExcelGeneralNumberFormat - Class in cn.idev.excel.metadata.format

Written with reference to ExcelGeneralNumberFormat.

ExcelGeneralNumberFormat(Locale, boolean) - Constructor for class cn.idev.excel.metadata.format.ExcelGeneralNumberFormat

ExcelGenerateException - Exception in cn.idev.excel.exception

ExcelGenerateException(String) - Constructor for exception cn.idev.excel.exception.ExcelGenerateException

ExcelGenerateException(String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelGenerateException

ExcelGenerateException(Throwable) - Constructor for exception cn.idev.excel.exception.ExcelGenerateException

ExcelHeadProperty - Class in cn.idev.excel.metadata.property

Define the header attribute of excel

ExcelHeadProperty(ConfigurationHolder, Class<?>, List<List<String>>) - Constructor for class cn.idev.excel.metadata.property.ExcelHeadProperty

ExcelIgnore - Annotation Type in cn.idev.excel.annotation

Ignore convert excel

ExcelIgnoreUnannotated - Annotation Type in cn.idev.excel.annotation

Ignore all unannotated fields.

ExcelProperty - Annotation Type in cn.idev.excel.annotation

ExcelReader - Class in cn.idev.excel

Excel readers are all read in event mode.

ExcelReader(ReadWorkbook) - Constructor for class cn.idev.excel.ExcelReader

ExcelReaderBuilder - Class in cn.idev.excel.read.builder

Build ExcelReader

ExcelReaderBuilder() - Constructor for class cn.idev.excel.read.builder.ExcelReaderBuilder

ExcelReaderSheetBuilder - Class in cn.idev.excel.read.builder

Build sheet

ExcelReaderSheetBuilder() - Constructor for class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

ExcelReaderSheetBuilder(ExcelReader) - Constructor for class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

ExcelReadExecutor - Interface in cn.idev.excel.analysis

Excel file Executor

excelReadHeadProperty() - Method in class cn.idev.excel.read.metadata.holder.AbstractReadHolder

excelReadHeadProperty() - Method in interface cn.idev.excel.read.metadata.holder.ReadHolder

What ExcelReadHeadProperty does the currently operated cell need to execute

ExcelReadHeadProperty - Class in cn.idev.excel.read.metadata.property

Define the header attribute of excel

ExcelReadHeadProperty(ConfigurationHolder, Class, List<List<String>>) - Constructor for class cn.idev.excel.read.metadata.property.ExcelReadHeadProperty

ExcelRuntimeException - Exception in cn.idev.excel.exception

Excel Exception

ExcelRuntimeException() - Constructor for exception cn.idev.excel.exception.ExcelRuntimeException

ExcelRuntimeException(String) - Constructor for exception cn.idev.excel.exception.ExcelRuntimeException

ExcelRuntimeException(String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelRuntimeException

ExcelRuntimeException(Throwable) - Constructor for exception cn.idev.excel.exception.ExcelRuntimeException

excelType(ExcelTypeEnum) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

excelType(ExcelTypeEnum) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

ExcelTypeEnum - Enum in cn.idev.excel.support

ExcelWriteAddExecutor - Class in cn.idev.excel.write.executor

Add the data into excel

ExcelWriteAddExecutor(WriteContext) - Constructor for class cn.idev.excel.write.executor.ExcelWriteAddExecutor

ExcelWriteDataConvertException - Exception in cn.idev.excel.exception

Data convert exception

ExcelWriteDataConvertException(CellWriteHandlerContext, String) - Constructor for exception cn.idev.excel.exception.ExcelWriteDataConvertException

ExcelWriteDataConvertException(CellWriteHandlerContext, String, Throwable) - Constructor for exception cn.idev.excel.exception.ExcelWriteDataConvertException

ExcelWriteExecutor - Interface in cn.idev.excel.write.executor

Excel write Executor

ExcelWriteFillExecutor - Class in cn.idev.excel.write.executor

Fill the data into excel

ExcelWriteFillExecutor(WriteContext) - Constructor for class cn.idev.excel.write.executor.ExcelWriteFillExecutor

ExcelWriteFillExecutor.UniqueDataFlagKey - Class in cn.idev.excel.write.executor

excelWriteHeadProperty() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

excelWriteHeadProperty() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

What 'ExcelWriteHeadProperty' does the currently operated cell need to execute

ExcelWriteHeadProperty - Class in cn.idev.excel.write.property

Define the header attribute of excel

ExcelWriteHeadProperty(ConfigurationHolder, Class<?>, List<List<String>>) - Constructor for class cn.idev.excel.write.property.ExcelWriteHeadProperty

ExcelWriter - Class in cn.idev.excel

Excel Writer This tool is used to write value out to Excel via POI.

ExcelWriter(WriteWorkbook) - Constructor for class cn.idev.excel.ExcelWriter

Create new writer

ExcelWriterBuilder - Class in cn.idev.excel.write.builder

Build ExcelWriter

ExcelWriterBuilder() - Constructor for class cn.idev.excel.write.builder.ExcelWriterBuilder

ExcelWriterSheetBuilder - Class in cn.idev.excel.write.builder

Build sheet

ExcelWriterSheetBuilder() - Constructor for class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

ExcelWriterSheetBuilder(ExcelWriter) - Constructor for class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

ExcelWriterTableBuilder - Class in cn.idev.excel.write.builder

Build sheet

ExcelWriterTableBuilder() - Constructor for class cn.idev.excel.write.builder.ExcelWriterTableBuilder

ExcelWriterTableBuilder(ExcelWriter, WriteSheet) - Constructor for class cn.idev.excel.write.builder.ExcelWriterTableBuilder

ExcelXmlConstants - Class in cn.idev.excel.constant

ExcelXmlConstants() - Constructor for class cn.idev.excel.constant.ExcelXmlConstants

excludeColumnFieldNames(Collection<String>) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Ignore the custom columns.

excludeColumnFieldNames() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

excludeColumnFieldNames() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Ignore the custom columns.

excludeColumnFiledNames(Collection<String>) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Deprecated.

use AbstractExcelWriterParameterBuilder.excludeColumnFieldNames(Collection)

excludeColumnIndexes(Collection<Integer>) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Ignore the custom columns.

excludeColumnIndexes() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

excludeColumnIndexes() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Ignore the custom columns.

execute() - Method in class cn.idev.excel.analysis.csv.CsvExcelReadExecutor

Overrides the execute method to parse and process CSV files.

execute() - Method in interface cn.idev.excel.analysis.ExcelReadExecutor

Read the sheet.

execute() - Method in class cn.idev.excel.analysis.v03.XlsListSheetListener

Executes the event-based processing of the XLS file.

execute() - Method in class cn.idev.excel.analysis.v03.XlsSaxAnalyser

Executes the parsing process for the Excel file.

execute() - Method in class cn.idev.excel.analysis.v07.XlsxSaxAnalyser

extra(CellExtra, AnalysisContext) - Method in class cn.idev.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

The current method is called when extra information is returned

extra(CellExtra, AnalysisContext) - Method in interface cn.idev.excel.read.listener.ReadListener

The current method is called when extra information is returned

extra(AnalysisContext) - Method in interface cn.idev.excel.read.processor.AnalysisEventProcessor

Read extra information

extra(AnalysisContext) - Method in class cn.idev.excel.read.processor.DefaultAnalysisEventProcessor

extraRead(CellExtraTypeEnum) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Read some extra information, not by default

F

FastExcel - Class in cn.idev.excel

This is actually FastExcelFactory, and short names look better.

FastExcel() - Constructor for class cn.idev.excel.FastExcel

FastExcelConstants - Class in cn.idev.excel.constant

Used to store constant

FastExcelConstants() - Constructor for class cn.idev.excel.constant.FastExcelConstants

FastExcelFactory - Class in cn.idev.excel

Reader and writer factory class

FastExcelFactory() - Constructor for class cn.idev.excel.FastExcelFactory

FastExcelNamingPolicy() - Constructor for class cn.idev.excel.util.BeanMapUtils.FastExcelNamingPolicy

FastExcelTempFileCreationStrategy - Class in cn.idev.excel.util

In the scenario where `poifiles` are cleaned up, the DefaultTempFileCreationStrategy will throw a java.nio.file.NoSuchFileException.

FastExcelTempFileCreationStrategy() - Constructor for class cn.idev.excel.util.FastExcelTempFileCreationStrategy

Creates the strategy so that it creates the temporary files in the default directory.

FastExcelTempFileCreationStrategy(File) - Constructor for class cn.idev.excel.util.FastExcelTempFileCreationStrategy

Creates the strategy allowing to set the

FF - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

FIELD_CACHE - Static variable in class cn.idev.excel.util.ClassUtils

memory cache

FieldCache - Class in cn.idev.excel.metadata

filed cache

FieldCache() - Constructor for class cn.idev.excel.metadata.FieldCache

FieldUtils - Class in cn.idev.excel.util

FieldUtils() - Constructor for class cn.idev.excel.util.FieldUtils

FieldWrapper - Class in cn.idev.excel.metadata

filed wrapper

FieldWrapper() - Constructor for class cn.idev.excel.metadata.FieldWrapper

file(InputStream) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Read InputStream

file(File) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Read file

file(String) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Read file

file(OutputStream) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

file(File) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

file(String) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

filedCacheLocation(CacheLocationEnum) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

The cache used when parsing fields such as head.

FileImageConverter - Class in cn.idev.excel.converters.file

File and image converter

FileImageConverter() - Constructor for class cn.idev.excel.converters.file.FileImageConverter

FileTypeUtils - Class in cn.idev.excel.util

file type utils

FileTypeUtils() - Constructor for class cn.idev.excel.util.FileTypeUtils

FileUtils - Class in cn.idev.excel.util

fill(Object, WriteSheet) - Method in class cn.idev.excel.ExcelWriter

Fill value to a sheet

fill(Object, FillConfig, WriteSheet) - Method in class cn.idev.excel.ExcelWriter

Fill value to a sheet

fill(Supplier<Object>, WriteSheet) - Method in class cn.idev.excel.ExcelWriter

Fill value to a sheet

fill(Supplier<Object>, FillConfig, WriteSheet) - Method in class cn.idev.excel.ExcelWriter

Fill value to a sheet

fill(Object, FillConfig, WriteSheet) - Method in interface cn.idev.excel.write.ExcelBuilder

WorkBook fill value

fill(Object, FillConfig, WriteSheet) - Method in class cn.idev.excel.write.ExcelBuilderImpl

fill(Object, FillConfig) - Method in class cn.idev.excel.write.executor.ExcelWriteFillExecutor

FILL_STYLE - Static variable in class cn.idev.excel.constant.OrderConstant

Sorting of styles written to cells.

FillConfig - Class in cn.idev.excel.write.metadata.fill

Fill config

FillConfig() - Constructor for class cn.idev.excel.write.metadata.fill.FillConfig

fillDataFormat(WriteCellData<?>, String, String) - Static method in class cn.idev.excel.util.WorkBookUtil

fillImage(CellWriteHandlerContext, List<ImageData>) - Method in class cn.idev.excel.write.executor.AbstractExcelWriteExecutor

FillPatternTypeEnum - Enum in cn.idev.excel.enums.poi

The enumeration value indicating the style of fill pattern being used for a cell format.

FillStyleCellWriteHandler - Class in cn.idev.excel.write.handler.impl

fill cell style.

FillStyleCellWriteHandler() - Constructor for class cn.idev.excel.write.handler.impl.FillStyleCellWriteHandler

FillWrapper - Class in cn.idev.excel.write.metadata.fill

Multiple lists are supported when packing

FillWrapper(Collection) - Constructor for class cn.idev.excel.write.metadata.fill.FillWrapper

FillWrapper(String, Collection) - Constructor for class cn.idev.excel.write.metadata.fill.FillWrapper

finalize() - Method in class cn.idev.excel.ExcelReader

Prevents calls to ExcelReader.finish() from freeing the cache

finalize() - Method in class cn.idev.excel.ExcelWriter

Prevents calls to ExcelWriter.finish() from freeing the cache

findFont(boolean, short, short, String, boolean, boolean, short, byte) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

finish() - Method in interface cn.idev.excel.analysis.ExcelAnalyser

Complete the entire read file.Release the cache and close stream

finish() - Method in class cn.idev.excel.analysis.ExcelAnalyserImpl

Cleans up resources used during the analysis process, including closing streams, destroying caches, and deleting temporary files.

finish(boolean) - Method in interface cn.idev.excel.context.WriteContext

close

finish(boolean) - Method in class cn.idev.excel.context.WriteContextImpl

Finishes the write process and releases resources.

finish() - Method in class cn.idev.excel.ExcelReader

Complete the entire read file.Release the cache and close stream.

finish() - Method in class cn.idev.excel.ExcelWriter

Close IO

finish(boolean) - Method in interface cn.idev.excel.write.ExcelBuilder

Close io

finish(boolean) - Method in class cn.idev.excel.write.ExcelBuilderImpl

FloatBooleanConverter - Class in cn.idev.excel.converters.floatconverter

Float and boolean converter

FloatBooleanConverter() - Constructor for class cn.idev.excel.converters.floatconverter.FloatBooleanConverter

FloatNumberConverter - Class in cn.idev.excel.converters.floatconverter

Float and number converter

FloatNumberConverter() - Constructor for class cn.idev.excel.converters.floatconverter.FloatNumberConverter

FloatStringConverter - Class in cn.idev.excel.converters.floatconverter

Float and string converter

FloatStringConverter() - Constructor for class cn.idev.excel.converters.floatconverter.FloatStringConverter

flushData() - Method in class cn.idev.excel.metadata.csv.CsvSheet

Font - Class in cn.idev.excel.metadata

Deprecated.

please use WriteFont

Font() - Constructor for class cn.idev.excel.metadata.Font

Deprecated.

FontProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

FontProperty() - Constructor for class cn.idev.excel.metadata.property.FontProperty

format(BigDecimal, Short, String) - Method in class cn.idev.excel.metadata.format.DataFormatter

Format data.

format(Object, StringBuffer, FieldPosition) - Method in class cn.idev.excel.metadata.format.ExcelGeneralNumberFormat

format(Date) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(Date, String) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(LocalDateTime, String, Locale) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(LocalDate, String) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(LocalDate, String, Locale) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(LocalDateTime, String) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(BigDecimal, Boolean, String) - Static method in class cn.idev.excel.util.DateUtils

Format date

format(BigDecimal, Short, String, GlobalConfiguration) - Static method in class cn.idev.excel.util.NumberDataFormatterUtils

Format number data.

format(BigDecimal, Short, String, Boolean, Locale, Boolean) - Static method in class cn.idev.excel.util.NumberDataFormatterUtils

Format number data.

format(Number, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

format

formatToCellData(Number, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

format

formatToCellDataString(Number, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

format

FormulaData - Class in cn.idev.excel.metadata.data

formula

FormulaData() - Constructor for class cn.idev.excel.metadata.data.FormulaData

FormulaRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

FormulaRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.FormulaRecordHandler

G

GENERAL - Static variable in class cn.idev.excel.constant.BuiltinFormats

get(Integer) - Method in class cn.idev.excel.cache.Ehcache

get(Integer) - Method in class cn.idev.excel.cache.MapCache

get(Integer) - Method in interface cn.idev.excel.cache.ReadCache

Get value

get(Integer) - Method in class cn.idev.excel.cache.XlsCache

get(int) - Method in class cn.idev.excel.write.metadata.CollectionRowData

get(int) - Method in class cn.idev.excel.write.metadata.MapRowData

get(int) - Method in interface cn.idev.excel.write.metadata.RowData

Returns the value to which the specified key is mapped, or null if this map contains no mapping for the key.

getActiveCell() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getActiveSheetIndex() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getAlignment() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getAllInterfaces(Class<?>) - Static method in class cn.idev.excel.util.ClassUtils

Gets a List of all interfaces implemented by the given class and its superclasses.

getAllNames() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getAllPictures() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getAnalysisContext() - Method in class cn.idev.excel.ExcelReader

Deprecated.

please use ExcelReader.analysisContext()

getArrayFormulaRange() - Method in class cn.idev.excel.metadata.csv.CsvCell

getAutobreaks() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getBooleanCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getBorderBottom() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getBorderLeft() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getBorderRight() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getBorderTop() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getBottomBorderColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getBuiltinFormat(Short, String, Locale) - Static method in class cn.idev.excel.constant.BuiltinFormats

getCachedFormulaResultType() - Method in class cn.idev.excel.metadata.csv.CsvCell

getCachePath() - Static method in class cn.idev.excel.util.FileUtils

getCell(int) - Method in class cn.idev.excel.metadata.csv.CsvRow

getCell(int, Row.MissingCellPolicy) - Method in class cn.idev.excel.metadata.csv.CsvRow

getCellComment() - Method in class cn.idev.excel.metadata.csv.CsvCell

getCellComment(CellAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getCellComments() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getCellCoordinate(Integer, Integer, Integer) - Static method in class cn.idev.excel.util.StyleUtil

getCellFormula() - Method in class cn.idev.excel.metadata.csv.CsvCell

getCellMap() - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

getCellReferenceType() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getCellStyle() - Method in class cn.idev.excel.metadata.csv.CsvCell

getCellStyleAt(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getCellType() - Method in class cn.idev.excel.metadata.csv.CsvCell

getCol(String, Integer) - Static method in class cn.idev.excel.util.PositionUtils

getCollectionData() - Method in class cn.idev.excel.write.metadata.fill.FillWrapper

getColumnBreaks() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getColumnExtend() - Method in class cn.idev.excel.metadata.property.LoopMergeProperty

getColumnIndex() - Method in interface cn.idev.excel.metadata.Cell

Column index

getColumnIndex() - Method in class cn.idev.excel.metadata.csv.CsvCell

getColumnOutlineLevel(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getColumnStyle(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getColumnWidth(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getColumnWidthInPixels(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getCoordinate(Integer) - Static method in class cn.idev.excel.util.StyleUtil

getCreationHelper() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getCurrentRowAnalysisResult() - Method in interface cn.idev.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readRowHolder()

getCurrentRowAnalysisResult() - Method in class cn.idev.excel.context.AnalysisContextImpl

getCurrentRowAnalysisResult() - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

getCurrentRowNum() - Method in interface cn.idev.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readRowHolder()

getCurrentRowNum() - Method in class cn.idev.excel.context.AnalysisContextImpl

getCurrentSheet() - Method in interface cn.idev.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeSheetHolder()

getCurrentSheet() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the current sheet being written.

getCustom() - Method in interface cn.idev.excel.context.AnalysisContext

Custom attribute

getCustom() - Method in class cn.idev.excel.context.AnalysisContextImpl

getDataFormat() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getDataFormatString() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getDataValidationHelper() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getDataValidations() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getDateCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getDefaultColumnWidth() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getDefaultRowHeight() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getDefaultRowHeightInPoints() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getDisplayGuts() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getDrawingPatriarch() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getEachRow() - Method in class cn.idev.excel.metadata.property.LoopMergeProperty

getErrorCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getExcelType() - Method in interface cn.idev.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readWorkbookHolder()

getExcelType() - Method in class cn.idev.excel.context.AnalysisContextImpl

getField(Class<?>, String) - Static method in class cn.idev.excel.util.FieldUtils

Gets an accessible Field by name respecting scope.

getField(Class<?>, String, boolean) - Static method in class cn.idev.excel.util.FieldUtils

Gets an accessible Field by name, breaking scope if requested.

getFieldClass(Map, String, Object) - Static method in class cn.idev.excel.util.FieldUtils

getFieldClass(Object) - Static method in class cn.idev.excel.util.FieldUtils

getFillBackgroundColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFillBackgroundColorColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFillForegroundColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFillForegroundColorColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFillPattern() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFirstCellNum() - Method in class cn.idev.excel.metadata.csv.CsvRow

getFirstColumnIndex() - Method in class cn.idev.excel.metadata.CellExtra

getFirstColumnIndex() - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

getFirstRowIndex() - Method in class cn.idev.excel.metadata.CellExtra

getFirstRowIndex() - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

getFirstRowNum() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getFirstVisibleTab() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getFitToPage() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getFontAt(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getFontHeightInPoints() - Method in class cn.idev.excel.metadata.Font

Deprecated.

getFontIndex() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFontIndexAsInt() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getFontName() - Method in class cn.idev.excel.metadata.Font

Deprecated.

getFooter() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getForceFormulaRecalculation() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getForceFormulaRecalculation() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getFormat(String) - Method in class cn.idev.excel.metadata.csv.CsvDataFormat

getFormat(short) - Method in class cn.idev.excel.metadata.csv.CsvDataFormat

getFormat() - Method in class cn.idev.excel.metadata.property.NumberFormatProperty

getGlobalConfiguration() - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

getHeader() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getHeight() - Method in class cn.idev.excel.metadata.csv.CsvRow

getHeight() - Method in class cn.idev.excel.metadata.property.RowHeightProperty

getHeightInPoints() - Method in class cn.idev.excel.metadata.csv.CsvRow

getHidden() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getHorizontallyCenter() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getHyperlink() - Method in class cn.idev.excel.metadata.csv.CsvCell

getHyperlink(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getHyperlink(CellAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getHyperlinkList() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getHyperlinkType(HyperlinkData.HyperlinkType) - Static method in class cn.idev.excel.util.StyleUtil

getImageType(byte[]) - Static method in class cn.idev.excel.util.FileTypeUtils

getImageTypeFormat(byte[]) - Static method in class cn.idev.excel.util.FileTypeUtils

getIndention() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getIndex() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getIndexOfFormattingRun(int) - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

getInputStream() - Method in interface cn.idev.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readWorkbookHolder()

getInputStream() - Method in class cn.idev.excel.context.AnalysisContextImpl

getJavaCalendar(double, boolean, TimeZone, boolean) - Static method in class cn.idev.excel.util.DateUtils

Get EXCEL date as Java Calendar with given time zone.

getJavaDate(double, boolean) - Static method in class cn.idev.excel.util.DateUtils

Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.util.Date.

getLastCellNum() - Method in class cn.idev.excel.metadata.csv.CsvRow

getLastColumnIndex() - Method in class cn.idev.excel.metadata.CellExtra

getLastColumnIndex() - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

getLastRowIndex() - Method in class cn.idev.excel.metadata.CellExtra

getLastRowIndex() - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

getLastRowNum() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getLeftBorderColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getLeftCol() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getList() - Method in class cn.idev.excel.event.SyncReadListener

getLocalDate(double, boolean) - Static method in class cn.idev.excel.util.DateUtils

Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.time.LocalDate.

getLocalDateTime(double, boolean) - Static method in class cn.idev.excel.util.DateUtils

Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.time.LocalDateTime.

getLocalDateTimeCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getLocked() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getMargin(short) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getMargin(PageMargin) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getMergedRegion(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getMergedRegions() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getMissingCellPolicy() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getName(String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getName() - Method in class cn.idev.excel.write.metadata.fill.FillWrapper

getNames(String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getNewRowIndexAndStartDoWrite() - Method in class cn.idev.excel.write.metadata.holder.WriteSheetHolder

Get the last line of index, you have to make sure that the data is written next

getNumberOfFonts() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getNumberOfFontsAsInt() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getNumberOfNames() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getNumberOfSheets() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getNumCellStyles() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getNumericCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getNumMergedRegions() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getNumRows() - Method in class cn.idev.excel.read.metadata.ReadSheet

getOrCreateStyle() - Method in class cn.idev.excel.metadata.data.WriteCellData

Returns or creates a new style for the cell.

getOutlineLevel() - Method in class cn.idev.excel.metadata.csv.CsvRow

getOutputStream() - Method in interface cn.idev.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeWorkbookHolder() ()}

getOutputStream() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the output stream for writing the Excel file.

getPaneInformation() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getPhysicalNumberOfCells() - Method in class cn.idev.excel.metadata.csv.CsvRow

getPhysicalNumberOfRows() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getPoiFilesPath() - Static method in class cn.idev.excel.util.FileUtils

getPrintArea(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getPrintSetup() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getProtect() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getQuotePrefixed() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getRepeatingColumns() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getRepeatingRows() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getRichStringCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getRightBorderColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getRotation() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getRoundingMode() - Method in class cn.idev.excel.metadata.property.NumberFormatProperty

getRow() - Method in class cn.idev.excel.metadata.csv.CsvCell

getRow(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

getRow(String) - Static method in class cn.idev.excel.util.PositionUtils

getRowBreaks() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getRowByRowTagt(String, Integer) - Static method in class cn.idev.excel.util.PositionUtils

getRowIndex() - Method in interface cn.idev.excel.metadata.Cell

Row index

getRowIndex() - Method in class cn.idev.excel.metadata.csv.CsvCell

getRowIndex() - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

getRowNum() - Method in class cn.idev.excel.metadata.csv.CsvRow

getRowStyle() - Method in class cn.idev.excel.metadata.csv.CsvRow

getRowSumsBelow() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getRowSumsRight() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getRowType() - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

getScenarioProtect() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getSheet() - Method in class cn.idev.excel.metadata.csv.CsvCell

getSheet() - Method in class cn.idev.excel.metadata.csv.CsvRow

getSheet(String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getSheetAt(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getSheetConditionalFormatting() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getSheetIndex(String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getSheetIndex(Sheet) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getSheetName() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getSheetName(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getSheetName() - Method in class cn.idev.excel.read.metadata.ReadSheet

getSheetNo() - Method in class cn.idev.excel.read.metadata.ReadSheet

getSheetVisibility(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getShrinkToFit() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getSpreadsheetVersion() - Method in class cn.idev.excel.metadata.csv.CsvCell

getSpreadsheetVersion() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

getString() - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

getStringCellValue() - Method in class cn.idev.excel.metadata.csv.CsvCell

getTag() - Method in class cn.idev.excel.util.BeanMapUtils.FastExcelNamingPolicy

getTempFilePrefix() - Static method in class cn.idev.excel.util.FileUtils

getText() - Method in class cn.idev.excel.metadata.CellExtra

getTopBorderColor() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getTopRow() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getTotal() - Method in class cn.idev.excel.read.metadata.holder.ReadSheetHolder

Deprecated.

getTotalCount() - Method in interface cn.idev.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readRowHolder()

getTotalCount() - Method in class cn.idev.excel.context.AnalysisContextImpl

getType() - Method in class cn.idev.excel.metadata.CellExtra

getVerticalAlignment() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getVerticallyCenter() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getWidth() - Method in class cn.idev.excel.metadata.property.ColumnWidthProperty

getWorkbook() - Method in interface cn.idev.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeWorkbookHolder() ()}

getWorkbook() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the workbook being written.

getWorkbook() - Method in class cn.idev.excel.metadata.csv.CsvSheet

getWrapText() - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

getZeroHeight() - Method in class cn.idev.excel.metadata.csv.CsvRow

globalConfiguration() - Method in class cn.idev.excel.metadata.AbstractHolder

globalConfiguration() - Method in interface cn.idev.excel.metadata.ConfigurationHolder

Some global variables

GlobalConfiguration - Class in cn.idev.excel.metadata

Global configuration

GlobalConfiguration() - Constructor for class cn.idev.excel.metadata.GlobalConfiguration

groupColumn(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

groupRow(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

H

Handler - Interface in cn.idev.excel.event

Intercepts handle some business logic

hashCode() - Method in class cn.idev.excel.write.metadata.fill.AnalysisCell

hasHead() - Method in class cn.idev.excel.metadata.property.ExcelHeadProperty

hasNext(AnalysisContext) - Method in class cn.idev.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

hasNext(AnalysisContext) - Method in interface cn.idev.excel.read.listener.ReadListener

Verify that there is another piece of data.You can stop the read by returning false

head(List<List<String>>) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

You can only choose one of the AbstractParameterBuilder.head(List) and AbstractParameterBuilder.head(Class)

head(Class<?>) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

You can only choose one of the AbstractParameterBuilder.head(List) and AbstractParameterBuilder.head(Class)

Head - Class in cn.idev.excel.metadata

excel head

Head(Integer, Field, String, List<String>, Boolean, Boolean) - Constructor for class cn.idev.excel.metadata.Head

headCellRangeList() - Method in class cn.idev.excel.write.property.ExcelWriteHeadProperty

Calculate all cells that need to be merged

headCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head

headCellStyle(Head) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head

HeadFontStyle - Annotation Type in cn.idev.excel.annotation.write.style

Custom header styles.

headIfNotNull(Class<?>) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

HeadKindEnum - Enum in cn.idev.excel.enums

The types of header

HeadRowHeight - Annotation Type in cn.idev.excel.annotation.write.style

Set the height of each table

headRowNumber(Integer) - Method in class cn.idev.excel.read.builder.AbstractExcelReaderParameterBuilder

Count the number of added heads when read sheet.

HeadStyle - Annotation Type in cn.idev.excel.annotation.write.style

Custom header styles

Holder - Interface in cn.idev.excel.metadata

Get the corresponding holder

HolderEnum - Enum in cn.idev.excel.enums

The types of holder

holderType() - Method in interface cn.idev.excel.metadata.Holder

What holder is the return

holderType() - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

holderType() - Method in class cn.idev.excel.read.metadata.holder.ReadSheetHolder

holderType() - Method in class cn.idev.excel.read.metadata.holder.ReadWorkbookHolder

holderType() - Method in class cn.idev.excel.write.metadata.holder.WriteSheetHolder

holderType() - Method in class cn.idev.excel.write.metadata.holder.WriteTableHolder

holderType() - Method in class cn.idev.excel.write.metadata.holder.WriteWorkbookHolder

HorizontalAlignmentEnum - Enum in cn.idev.excel.enums.poi

The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.

HorizontalCellStyleStrategy - Class in cn.idev.excel.write.style

Use the same style for the row

HorizontalCellStyleStrategy() - Constructor for class cn.idev.excel.write.style.HorizontalCellStyleStrategy

HorizontalCellStyleStrategy(WriteCellStyle, List<WriteCellStyle>) - Constructor for class cn.idev.excel.write.style.HorizontalCellStyleStrategy

HorizontalCellStyleStrategy(WriteCellStyle, WriteCellStyle) - Constructor for class cn.idev.excel.write.style.HorizontalCellStyleStrategy

HOURS_PER_DAY - Static variable in class cn.idev.excel.util.DateUtils

HYPERLINK_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

HyperlinkData - Class in cn.idev.excel.metadata.data

hyperlink

HyperlinkData() - Constructor for class cn.idev.excel.metadata.data.HyperlinkData

HyperlinkData.HyperlinkType - Enum in cn.idev.excel.metadata.data

HyperlinkRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

HyperlinkRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.HyperlinkRecordHandler

HyperlinkTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Handler

HyperlinkTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.HyperlinkTagHandler

I

IgnorableXlsRecordHandler - Interface in cn.idev.excel.analysis.v03

Need to ignore the current handler without reading the current sheet.

ignore(String, Integer) - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

ignore(String, Integer) - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Is to determine if a field needs to be ignored

ignoreEmptyRow(Boolean) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Ignore empty rows.Default is true.

IgnoreExceptionReadListener<T> - Interface in cn.idev.excel.read.listener

Interface to listen for read results

ignoreHiddenSheet(Boolean) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Ignore hiddene sheet.Default is false.

ImageData - Class in cn.idev.excel.metadata.data

image

ImageData() - Constructor for class cn.idev.excel.metadata.data.ImageData

ImageData.ImageType - Enum in cn.idev.excel.metadata.data

includeColumnFieldNames(Collection<String>) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Only output the custom columns.

includeColumnFieldNames() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

includeColumnFieldNames() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Only output the custom columns.

includeColumnFiledNames(Collection<String>) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Deprecated.

use AbstractExcelWriterParameterBuilder.includeColumnFieldNames(Collection) spelling mistake

includeColumnIndexes(Collection<Integer>) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Only output the custom columns.

includeColumnIndexes() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

includeColumnIndexes() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Only output the custom columns.

IndexRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

IndexRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.IndexRecordHandler

init(AnalysisContext) - Method in class cn.idev.excel.cache.Ehcache

init(AnalysisContext) - Method in class cn.idev.excel.cache.MapCache

init(AnalysisContext) - Method in interface cn.idev.excel.cache.ReadCache

Initialize cache

init(AnalysisContext) - Method in class cn.idev.excel.cache.XlsCache

init() - Method in class cn.idev.excel.write.metadata.fill.FillConfig

initAnnotationConfig(List<WriteHandler>, WriteBasicParameter) - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

initHandler(WriteBasicParameter, AbstractWriteHolder) - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

initHead(ExcelWriteHeadProperty) - Method in class cn.idev.excel.context.WriteContextImpl

Initializes the header for the current sheet or table.

inMemory(Boolean) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Write excel in memory.

InputStreamImageConverter - Class in cn.idev.excel.converters.inputstream

File and image converter

InputStreamImageConverter() - Constructor for class cn.idev.excel.converters.inputstream.InputStreamImageConverter

INSTANCE - Static variable in class cn.idev.excel.util.BeanMapUtils.FastExcelNamingPolicy

IntegerBooleanConverter - Class in cn.idev.excel.converters.integer

Integer and boolean converter

IntegerBooleanConverter() - Constructor for class cn.idev.excel.converters.integer.IntegerBooleanConverter

IntegerNumberConverter - Class in cn.idev.excel.converters.integer

Integer and number converter

IntegerNumberConverter() - Constructor for class cn.idev.excel.converters.integer.IntegerNumberConverter

IntegerStringConverter - Class in cn.idev.excel.converters.integer

Integer and string converter

IntegerStringConverter() - Constructor for class cn.idev.excel.converters.integer.IntegerStringConverter

interrupt() - Method in interface cn.idev.excel.context.AnalysisContext

Deprecated.

please use ReadListener.hasNext(AnalysisContext)

interrupt() - Method in class cn.idev.excel.context.AnalysisContextImpl

IntervalFont() - Constructor for class cn.idev.excel.metadata.data.RichTextStringData.IntervalFont

IntUtils - Class in cn.idev.excel.util

Int utils

invoke(Object, AnalysisContext) - Method in class cn.idev.excel.event.SyncReadListener

invoke(Map<Integer, ReadCellData<?>>, AnalysisContext) - Method in class cn.idev.excel.read.listener.ModelBuildEventListener

invoke(T, AnalysisContext) - Method in class cn.idev.excel.read.listener.PageReadListener

invoke(T, AnalysisContext) - Method in interface cn.idev.excel.read.listener.ReadListener

When analysis one row trigger invoke function.

invokeHead(Map<Integer, ReadCellData<?>>, AnalysisContext) - Method in class cn.idev.excel.event.AnalysisEventListener

invokeHead(Map<Integer, ReadCellData<?>>, AnalysisContext) - Method in interface cn.idev.excel.read.listener.ReadListener

When analysis one head row trigger invoke function.

invokeHeadMap(Map<Integer, String>, AnalysisContext) - Method in class cn.idev.excel.event.AnalysisEventListener

Returns the header as a map.Override the current method to receive header data.

IoUtils - Class in cn.idev.excel.util

IO Utils

isADateFormat(Short, String) - Static method in class cn.idev.excel.util.DateUtils

Determine if it is a date format.

isADateFormatUncached(Short, String) - Static method in class cn.idev.excel.util.DateUtils

Determine if it is a date format.

isBlank(CharSequence) - Static method in class cn.idev.excel.util.StringUtils

Checks if a CharSequence is empty (""), null or whitespace only.

isBold() - Method in class cn.idev.excel.metadata.Font

Deprecated.

isColumnBroken(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

isColumnHidden(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

isDisplayFormulas() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isDisplayGridlines() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isDisplayRowColHeadings() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isDisplayZeros() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isEmpty(CharSequence) - Static method in class cn.idev.excel.util.StringUtils

Checks if a CharSequence is empty ("") or null.

isEmpty() - Method in class cn.idev.excel.write.metadata.CollectionRowData

isEmpty() - Method in class cn.idev.excel.write.metadata.MapRowData

isEmpty() - Method in interface cn.idev.excel.write.metadata.RowData

Returns true if this collection contains no elements.

isFalse(Boolean) - Static method in class cn.idev.excel.util.BooleanUtils

Checks if a Boolean value is false, handling null by returning false.

isFormatted() - Method in class cn.idev.excel.metadata.csv.CsvRow

isHidden() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

isHidden() - Method in class cn.idev.excel.read.metadata.ReadSheet

isInternalDateFormat(short) - Static method in class cn.idev.excel.util.DateUtils

Given a format ID this will check whether the format represents an internal excel date format or not.

isNew() - Method in class cn.idev.excel.metadata.AbstractHolder

isNew() - Method in interface cn.idev.excel.metadata.ConfigurationHolder

Record whether it's new or from cache

isNotBlank(CharSequence) - Static method in class cn.idev.excel.util.StringUtils

Checks if a CharSequence is not empty (""), not null and not whitespace only.

isNotFalse(Boolean) - Static method in class cn.idev.excel.util.BooleanUtils

Checks if a Boolean value is not false, handling null by returning true.

isNotTrue(Boolean) - Static method in class cn.idev.excel.util.BooleanUtils

Checks if a Boolean value is not true, handling null by returning true.

isNumeric(CharSequence) - Static method in class cn.idev.excel.util.StringUtils

Checks if the CharSequence contains only Unicode digits.

isPartOfArrayFormulaGroup() - Method in class cn.idev.excel.metadata.csv.CsvCell

isPrintGridlines() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isPrintRowAndColumnHeadings() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isRightToLeft() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isRowBroken(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

isSelected() - Method in class cn.idev.excel.metadata.csv.CsvSheet

isSheetHidden(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

isSheetVeryHidden(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

isTrue(Boolean) - Static method in class cn.idev.excel.util.BooleanUtils

Checks if a Boolean value is true, handling null by returning false.

isTrue(boolean, String, long) - Static method in class cn.idev.excel.util.Validate

Validate that the argument condition is true; otherwise throwing an exception with the specified message.

isTrue(boolean, String, double) - Static method in class cn.idev.excel.util.Validate

Validate that the argument condition is true; otherwise throwing an exception with the specified message.

isTrue(boolean, String, Object...) - Static method in class cn.idev.excel.util.Validate

Validate that the argument condition is true; otherwise throwing an exception with the specified message.

isTrue(boolean) - Static method in class cn.idev.excel.util.Validate

Validate that the argument condition is true; otherwise throwing an exception.

isValidExcelDate(double) - Static method in class cn.idev.excel.util.DateUtils

Given a double, checks if it is a valid Excel date.

isVeryHidden() - Method in class cn.idev.excel.read.metadata.ReadSheet

iterator() - Method in class cn.idev.excel.metadata.csv.CsvRow

iterator() - Method in class cn.idev.excel.metadata.csv.CsvSheet

iterator() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

L

LabelRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

LabelRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.LabelRecordHandler

LabelSstRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

LabelSstRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.LabelSstRecordHandler

length() - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

LF - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

linkExternalWorkbook(String, Workbook) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

Listener - Interface in cn.idev.excel.event

Interface to listen for processing results

ListUtils - Class in cn.idev.excel.util

loadAllConverter() - Static method in class cn.idev.excel.converters.DefaultConverterLoader

Load all converter

loadDefaultHandler(Boolean, ExcelTypeEnum) - Static method in class cn.idev.excel.write.handler.DefaultWriteHandlerLoader

Load default handler

loadDefaultReadConverter() - Static method in class cn.idev.excel.converters.DefaultConverterLoader

Load default read converter

loadDefaultWriteConverter() - Static method in class cn.idev.excel.converters.DefaultConverterLoader

Load default write converter

LocalDateDateConverter - Class in cn.idev.excel.converters.localdate

LocalDate and date converter

LocalDateDateConverter() - Constructor for class cn.idev.excel.converters.localdate.LocalDateDateConverter

LocalDateNumberConverter - Class in cn.idev.excel.converters.localdate

LocalDate and number converter

LocalDateNumberConverter() - Constructor for class cn.idev.excel.converters.localdate.LocalDateNumberConverter

LocalDateStringConverter - Class in cn.idev.excel.converters.localdate

LocalDate and string converter

LocalDateStringConverter() - Constructor for class cn.idev.excel.converters.localdate.LocalDateStringConverter

LocalDateTimeDateConverter - Class in cn.idev.excel.converters.localdatetime

LocalDateTime and date converter

LocalDateTimeDateConverter() - Constructor for class cn.idev.excel.converters.localdatetime.LocalDateTimeDateConverter

LocalDateTimeNumberConverter - Class in cn.idev.excel.converters.localdatetime

LocalDateTime and number converter

LocalDateTimeNumberConverter() - Constructor for class cn.idev.excel.converters.localdatetime.LocalDateTimeNumberConverter

LocalDateTimeStringConverter - Class in cn.idev.excel.converters.localdatetime

LocalDateTime and string converter

LocalDateTimeStringConverter() - Constructor for class cn.idev.excel.converters.localdatetime.LocalDateTimeStringConverter

locale(Locale) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

A Locale object represents a specific geographical, political, or cultural region.

LongBooleanConverter - Class in cn.idev.excel.converters.longconverter

Long and boolean converter

LongBooleanConverter() - Constructor for class cn.idev.excel.converters.longconverter.LongBooleanConverter

LongestMatchColumnWidthStyleStrategy - Class in cn.idev.excel.write.style.column

Take the width of the longest column as the width.

LongestMatchColumnWidthStyleStrategy() - Constructor for class cn.idev.excel.write.style.column.LongestMatchColumnWidthStyleStrategy

LongNumberConverter - Class in cn.idev.excel.converters.longconverter

Long and number converter

LongNumberConverter() - Constructor for class cn.idev.excel.converters.longconverter.LongNumberConverter

LongStringConverter - Class in cn.idev.excel.converters.longconverter

Long and string converter

LongStringConverter() - Constructor for class cn.idev.excel.converters.longconverter.LongStringConverter

LoopMergeProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

LoopMergeProperty(int, int) - Constructor for class cn.idev.excel.metadata.property.LoopMergeProperty

LoopMergeStrategy - Class in cn.idev.excel.write.merge

The regions of the loop merge

LoopMergeStrategy(int, int) - Constructor for class cn.idev.excel.write.merge.LoopMergeStrategy

LoopMergeStrategy(int, int, int) - Constructor for class cn.idev.excel.write.merge.LoopMergeStrategy

LoopMergeStrategy(LoopMergeProperty, Integer) - Constructor for class cn.idev.excel.write.merge.LoopMergeStrategy

M

mandatoryUseInputStream(Boolean) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Mandatory use 'inputStream' .Default is false.

MapCache - Class in cn.idev.excel.cache

Putting temporary data directly into a map is a little more efficient but very memory intensive

MapCache() - Constructor for class cn.idev.excel.cache.MapCache

MapRowData - Class in cn.idev.excel.write.metadata

A map row of data.

MapRowData(Map<Integer, ?>) - Constructor for class cn.idev.excel.write.metadata.MapRowData

MapUtils - Class in cn.idev.excel.util

match(ReadSheet, AnalysisContext) - Static method in class cn.idev.excel.util.SheetUtils

Match the parameters to the actual sheet

MAX_POWER_OF_TWO - Static variable in class cn.idev.excel.util.IntUtils

The largest power of two that can be represented as an int.

MemberUtils - Class in cn.idev.excel.util

MemberUtils() - Constructor for class cn.idev.excel.util.MemberUtils

merge(DataFormatData, DataFormatData) - Static method in class cn.idev.excel.metadata.data.DataFormatData

The source is not empty merge the data to the target.

merge(int, int, int, int) - Method in interface cn.idev.excel.write.ExcelBuilder

Deprecated.

please useOnceAbsoluteMergeStrategy

merge(int, int, int, int) - Method in class cn.idev.excel.write.ExcelBuilderImpl

merge(Sheet, Cell, Head, Integer) - Method in class cn.idev.excel.write.merge.AbstractMergeStrategy

merge

merge(WriteCellStyle, WriteCellStyle) - Static method in class cn.idev.excel.write.metadata.style.WriteCellStyle

The source is not empty merge the data to the target.

merge(WriteFont, WriteFont) - Static method in class cn.idev.excel.write.metadata.style.WriteFont

The source is not empty merge the data to the target.

MERGE_CELL_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

MergeCellsRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

MergeCellsRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.MergeCellsRecordHandler

MergeCellTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Handler

MergeCellTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.MergeCellTagHandler

MIN_CUSTOM_DATA_FORMAT_INDEX - Static variable in class cn.idev.excel.constant.BuiltinFormats

MINUTES_PER_HOUR - Static variable in class cn.idev.excel.util.DateUtils

ModelBuildEventListener - Class in cn.idev.excel.read.listener

Convert to the object the user needs

ModelBuildEventListener() - Constructor for class cn.idev.excel.read.listener.ModelBuildEventListener

N

needHead() - Method in interface cn.idev.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeSheetHolder()

needHead() - Method in class cn.idev.excel.context.WriteContextImpl

Checks if the current sheet requires a header.

needHead(Boolean) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Need Head

needHead() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

needHead() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Whether a header is required for the currently operated cell

newArrayList() - Static method in class cn.idev.excel.util.ListUtils

Creates a mutable, empty ArrayList instance (for Java 6 and earlier).

newArrayList(E...) - Static method in class cn.idev.excel.util.ListUtils

Creates a mutable ArrayList instance containing the given elements.

newArrayList(Iterator<? extends E>) - Static method in class cn.idev.excel.util.ListUtils

Creates a mutable ArrayList instance containing the given elements; a very thin shortcut for creating an empty list and then calling Iterators.addAll(java.util.Collection<T>, java.util.Iterator<? extends T>).

newArrayList(Iterable<? extends E>) - Static method in class cn.idev.excel.util.ListUtils

Creates a mutable ArrayList instance containing the given elements;

newArrayListWithCapacity(int) - Static method in class cn.idev.excel.util.ListUtils

Creates an ArrayList instance backed by an array with the specified initial size; simply delegates to ArrayList(int).

newArrayListWithExpectedSize(int) - Static method in class cn.idev.excel.util.ListUtils

Creates an ArrayList instance to hold estimatedSize elements, plus an unspecified amount of padding; you almost certainly mean to call ListUtils.newArrayListWithCapacity(int) (see that method for further advice on usage).

newEmptyInstance() - Static method in class cn.idev.excel.metadata.data.ReadCellData

newEmptyInstance(Integer, Integer) - Static method in class cn.idev.excel.metadata.data.ReadCellData

newHashMap() - Static method in class cn.idev.excel.util.MapUtils

Creates a mutable, empty HashMap instance.

newHashMapWithExpectedSize(int) - Static method in class cn.idev.excel.util.MapUtils

Creates a HashMap instance, with a high enough "initial capacity" that it should hold expectedSize elements without growth.

newInstance(Boolean) - Static method in class cn.idev.excel.metadata.data.ReadCellData

newInstance(Boolean, Integer, Integer) - Static method in class cn.idev.excel.metadata.data.ReadCellData

newInstance(String, Integer, Integer) - Static method in class cn.idev.excel.metadata.data.ReadCellData

newInstance(BigDecimal, Integer, Integer) - Static method in class cn.idev.excel.metadata.data.ReadCellData

newInstanceOriginal(BigDecimal, Integer, Integer) - Static method in class cn.idev.excel.metadata.data.ReadCellData

newLinkedHashMap() - Static method in class cn.idev.excel.util.MapUtils

Creates a mutable, empty, insertion-ordered LinkedHashMap instance.

newLinkedHashMapWithExpectedSize(int) - Static method in class cn.idev.excel.util.MapUtils

Creates a LinkedHashMap instance, with a high enough "initial capacity" that it should hold expectedSize elements without growth.

newTreeMap() - Static method in class cn.idev.excel.util.MapUtils

Creates a mutable, empty TreeMap instance using the natural ordering of its elements.

NoteRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

NoteRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.NoteRecordHandler

notNull(T) - Static method in class cn.idev.excel.util.Validate

Validate that the specified argument is not null; otherwise throwing an exception.

notNull(T, String, Object...) - Static method in class cn.idev.excel.util.Validate

Validate that the specified argument is not null; otherwise throwing an exception with the specified message.

NotRepeatExecutor - Interface in cn.idev.excel.event

There are multiple interceptors that execute only one of them when fired once.If you want to control which one to execute please use Order

NS2_CELL_FORMULA_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_CELL_INLINE_STRING_VALUE_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_CELL_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_CELL_VALUE_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_DIMENSION_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_HYPERLINK_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_MERGE_CELL_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NS2_ROW_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

NullableObjectConverter<T> - Interface in cn.idev.excel.converters

When implementing convertToExcelData method, pay attention to the reference value may be null

NullObject - Class in cn.idev.excel.metadata

Null object.

NullObject() - Constructor for class cn.idev.excel.metadata.NullObject

nullObjectClass - Static variable in class cn.idev.excel.util.FieldUtils

nullString(String) - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

Sets the null string

nullString(String) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

Sets the null string

NumberDataFormatterUtils - Class in cn.idev.excel.util

Convert number data, including date.

NumberDataFormatterUtils() - Constructor for class cn.idev.excel.util.NumberDataFormatterUtils

NumberFormat - Annotation Type in cn.idev.excel.annotation.format

Convert number format.

NumberFormatProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

NumberFormatProperty(String, RoundingMode) - Constructor for class cn.idev.excel.metadata.property.NumberFormatProperty

NumberRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

NumberRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.NumberRecordHandler

NumberUtils - Class in cn.idev.excel.util

Number utils

NumericCellTypeEnum - Enum in cn.idev.excel.enums

Used to supplement CellType.

numFormattingRuns() - Method in class cn.idev.excel.metadata.csv.CsvRichTextString

numRows(Integer) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

numRows(Integer) - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

numRows

numRows - Variable in class cn.idev.excel.read.metadata.ReadSheet

The number of rows to read, the default is all, start with 0.

numRowsIfNotNull(Integer) - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

O

ObjRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

ObjRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.ObjRecordHandler

OnceAbsoluteMerge - Annotation Type in cn.idev.excel.annotation.write.style

Merge the cells once

OnceAbsoluteMergeProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

OnceAbsoluteMergeProperty(int, int, int, int) - Constructor for class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

OnceAbsoluteMergeStrategy - Class in cn.idev.excel.write.merge

It only merges once when create cell(firstRowIndex,lastRowIndex)

OnceAbsoluteMergeStrategy(int, int, int, int) - Constructor for class cn.idev.excel.write.merge.OnceAbsoluteMergeStrategy

OnceAbsoluteMergeStrategy(OnceAbsoluteMergeProperty) - Constructor for class cn.idev.excel.write.merge.OnceAbsoluteMergeStrategy

onException(Exception, AnalysisContext) - Method in class cn.idev.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

All listeners receive this method when any one Listener does an error report.

onException(Exception, AnalysisContext) - Method in interface cn.idev.excel.read.listener.IgnoreExceptionReadListener

All listeners receive this method when any one Listener does an error report.

onException(Exception, AnalysisContext) - Method in interface cn.idev.excel.read.listener.ReadListener

All listeners receive this method when any one Listener does an error report.

openInputStream(File) - Static method in class cn.idev.excel.util.FileUtils

Opens a FileInputStream for the specified file, providing better error messages than simply calling new FileInputStream(file).

order() - Method in interface cn.idev.excel.event.Handler

handler order

Order - Interface in cn.idev.excel.event

Implement this interface when sorting

order() - Method in interface cn.idev.excel.event.Order

The smaller the first implementation

order() - Method in class cn.idev.excel.write.handler.impl.FillStyleCellWriteHandler

order() - Method in class cn.idev.excel.write.handler.impl.WriteSheetWorkbookWriteHandler

order() - Method in class cn.idev.excel.write.style.AbstractCellStyleStrategy

order() - Method in class cn.idev.excel.write.style.DefaultStyle

orderByIncludeColumn(Boolean) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Data will be order by AbstractExcelWriterParameterBuilder.includeColumnFieldNames(java.util.Collection<java.lang.String>) or AbstractExcelWriterParameterBuilder.includeColumnIndexes(java.util.Collection<java.lang.Integer>).

orderByIncludeColumn() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

orderByIncludeColumn() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Data will be order by WriteHolder.includeColumnFieldNames() or WriteHolder.includeColumnIndexes().

OrderConstant - Class in cn.idev.excel.constant

Order constant.

OrderConstant() - Constructor for class cn.idev.excel.constant.OrderConstant

ownSheetHandlerExecutionChain - Variable in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

Execute the sheet handler chain Created in the sheet in the workbook interceptors will not be executed because the workbook to create an event long past.

ownWorkbookHandlerExecutionChain - Variable in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

Execute the workbook handler chain Created in the sheet in the workbook interceptors will not be executed because the workbook to create an event long past.

P

PageReadListener<T> - Class in cn.idev.excel.read.listener

page read listener

PageReadListener(Consumer<List<T>>) - Constructor for class cn.idev.excel.read.listener.PageReadListener

PageReadListener(Consumer<List<T>>, int) - Constructor for class cn.idev.excel.read.listener.PageReadListener

parameter() - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

Get parameter

parameter() - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

parameter() - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

parameter() - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

parameter() - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

parameter() - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

parameter() - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

parameter() - Method in class cn.idev.excel.write.builder.ExcelWriterTableBuilder

parseBigDecimal(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse

parseByte(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse

parseDate(String, String) - Static method in class cn.idev.excel.util.DateUtils

convert string to date

parseDate(String) - Static method in class cn.idev.excel.util.DateUtils

convert string to date

parseDouble(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse

parseFloat(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse

parseInteger(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse Integer from string

parseLocalDate(String, String, Locale) - Static method in class cn.idev.excel.util.DateUtils

convert string to date

parseLocalDateTime(String, String, Locale) - Static method in class cn.idev.excel.util.DateUtils

convert string to date

parseLong(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse

parseObject(String, ParsePosition) - Method in class cn.idev.excel.metadata.format.ExcelGeneralNumberFormat

parseShort(String, ExcelContentProperty) - Static method in class cn.idev.excel.util.NumberUtils

parse

password(String) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Whether the encryption

password(String) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Whether the encryption.

PIPE - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

POI_FILES - Static variable in class cn.idev.excel.util.FileUtils

POIFILES - Static variable in class cn.idev.excel.util.FastExcelTempFileCreationStrategy

Name of POI files directory in temporary directory.

PoiUtils - Class in cn.idev.excel.util

utils

PoiUtils() - Constructor for class cn.idev.excel.util.PoiUtils

PositionUtils - Class in cn.idev.excel.util

printData() - Method in class cn.idev.excel.metadata.csv.CsvSheet

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.BlankRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.BofRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.BoolErrRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.BoundSheetRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.DateWindow1904RecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.DummyRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.EofRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.FormulaRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.HyperlinkRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.IndexRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.LabelRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.LabelSstRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.MergeCellsRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.NoteRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.NumberRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.ObjRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.RkRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.SstRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.StringRecordHandler

processRecord(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.TextObjectRecordHandler

processRecord(Record) - Method in class cn.idev.excel.analysis.v03.XlsListSheetListener

Processes a specific record by delegating it to the appropriate handler based on its SID.

processRecord(XlsReadContext, Record) - Method in interface cn.idev.excel.analysis.v03.XlsRecordHandler

Processing record

processRecord(Record) - Method in class cn.idev.excel.analysis.v03.XlsSaxAnalyser

Processes a single Excel record.

protectSheet(String) - Method in class cn.idev.excel.metadata.csv.CsvSheet

put(String) - Method in class cn.idev.excel.cache.Ehcache

put(String) - Method in class cn.idev.excel.cache.MapCache

put(String) - Method in interface cn.idev.excel.cache.ReadCache

Automatically generate the key and put it in the cache.Key start from 0

put(String) - Method in class cn.idev.excel.cache.XlsCache

putFinished() - Method in class cn.idev.excel.cache.Ehcache

putFinished() - Method in class cn.idev.excel.cache.MapCache

putFinished() - Method in interface cn.idev.excel.cache.ReadCache

It's called when all the values are put in

putFinished() - Method in class cn.idev.excel.cache.XlsCache

Q

quote(Character) - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

Sets the quote character

quote(Character, QuoteMode) - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

Sets the quote character and the quoting behavior

quote(Character) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

Sets the quote character

quote(Character, QuoteMode) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

Sets the quote character and the quoting behavior

R

read() - Method in class cn.idev.excel.ExcelReader

Deprecated.

lease use ExcelReader.readAll()

read(ReadSheet...) - Method in class cn.idev.excel.ExcelReader

Parse the specified sheet，SheetNo start from 0

read(List<ReadSheet>) - Method in class cn.idev.excel.ExcelReader

Read multiple sheets.

read() - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(File) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(File, ReadListener) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(File, Class, ReadListener) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(String) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(String, ReadListener) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(String, Class, ReadListener) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(InputStream) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(InputStream, ReadListener) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

read(InputStream, Class, ReadListener) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the read

readAll() - Method in class cn.idev.excel.ExcelReader

Parse all sheet content by default

ReadBasicParameter - Class in cn.idev.excel.read.metadata

Read basic parameter

ReadBasicParameter() - Constructor for class cn.idev.excel.read.metadata.ReadBasicParameter

ReadCache - Interface in cn.idev.excel.cache

Read cache

readCache(PackagePart) - Method in class cn.idev.excel.cache.selector.EternalReadCacheSelector

readCache(PackagePart) - Method in interface cn.idev.excel.cache.selector.ReadCacheSelector

Select a cache

readCache(PackagePart) - Method in class cn.idev.excel.cache.selector.SimpleReadCacheSelector

readCache(ReadCache) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

A cache that stores temp data to save memory.

ReadCacheSelector - Interface in cn.idev.excel.cache.selector

Select the cache

readCacheSelector(ReadCacheSelector) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Select the cache.Default use SimpleReadCacheSelector

ReadCellData<T> - Class in cn.idev.excel.metadata.data

read cell data

ReadCellData(CellDataTypeEnum) - Constructor for class cn.idev.excel.metadata.data.ReadCellData

ReadCellData(T) - Constructor for class cn.idev.excel.metadata.data.ReadCellData

ReadCellData(String) - Constructor for class cn.idev.excel.metadata.data.ReadCellData

ReadCellData(CellDataTypeEnum, String) - Constructor for class cn.idev.excel.metadata.data.ReadCellData

ReadCellData(BigDecimal) - Constructor for class cn.idev.excel.metadata.data.ReadCellData

ReadCellData(Boolean) - Constructor for class cn.idev.excel.metadata.data.ReadCellData

ReadConverterContext<T> - Class in cn.idev.excel.converters

read converter context

ReadConverterContext() - Constructor for class cn.idev.excel.converters.ReadConverterContext

readDefaultReturn(ReadDefaultReturnEnum) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Read not to cn.idev.excel.metadata.BasicParameter#clazz value, the default will return type.

ReadDefaultReturnEnum - Enum in cn.idev.excel.enums

Read not to cn.idev.excel.metadata.BasicParameter#clazz value, the default will return type.

readFileToByteArray(File) - Static method in class cn.idev.excel.util.FileUtils

Reads the contents of a file into a byte array.

ReadHolder - Interface in cn.idev.excel.read.metadata.holder

Get the corresponding Holder

ReadListener<T> - Interface in cn.idev.excel.read.listener

Interface to listen for read results

readListenerList() - Method in class cn.idev.excel.read.metadata.holder.AbstractReadHolder

readListenerList() - Method in interface cn.idev.excel.read.metadata.holder.ReadHolder

What handler does the currently operated cell need to execute

readRowHolder(ReadRowHolder) - Method in interface cn.idev.excel.context.AnalysisContext

Set row of currently operated cell

readRowHolder() - Method in interface cn.idev.excel.context.AnalysisContext

Row of currently operated cell

readRowHolder() - Method in class cn.idev.excel.context.AnalysisContextImpl

readRowHolder(ReadRowHolder) - Method in class cn.idev.excel.context.AnalysisContextImpl

ReadRowHolder - Class in cn.idev.excel.read.metadata.holder

sheet holder

ReadRowHolder(Integer, RowTypeEnum, GlobalConfiguration, Map<Integer, Cell>) - Constructor for class cn.idev.excel.read.metadata.holder.ReadRowHolder

readSheet() - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'readSheet'

readSheet(Integer) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'readSheet'

readSheet(String) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'readSheet'

readSheet(Integer, String) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'readSheet'

readSheet(Integer, String, Integer) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'readSheet'

ReadSheet - Class in cn.idev.excel.read.metadata

Read sheet

ReadSheet() - Constructor for class cn.idev.excel.read.metadata.ReadSheet

ReadSheet(Integer) - Constructor for class cn.idev.excel.read.metadata.ReadSheet

ReadSheet(Integer, String) - Constructor for class cn.idev.excel.read.metadata.ReadSheet

ReadSheet(Integer, String, Integer) - Constructor for class cn.idev.excel.read.metadata.ReadSheet

readSheetHolder() - Method in interface cn.idev.excel.context.AnalysisContext

All information about the sheet you are currently working on

readSheetHolder() - Method in class cn.idev.excel.context.AnalysisContextImpl

ReadSheetHolder - Class in cn.idev.excel.read.metadata.holder

sheet holder

ReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class cn.idev.excel.read.metadata.holder.ReadSheetHolder

readSheetList() - Method in interface cn.idev.excel.context.AnalysisContext

Data that the customer needs to read

readSheetList(List<ReadSheet>) - Method in interface cn.idev.excel.context.AnalysisContext

Data that the customer needs to read

readSheetList() - Method in class cn.idev.excel.context.AnalysisContextImpl

readSheetList(List<ReadSheet>) - Method in class cn.idev.excel.context.AnalysisContextImpl

ReadWorkbook - Class in cn.idev.excel.read.metadata

Workbook

ReadWorkbook() - Constructor for class cn.idev.excel.read.metadata.ReadWorkbook

readWorkbookHolder() - Method in interface cn.idev.excel.context.AnalysisContext

All information about the workbook you are currently working on

readWorkbookHolder() - Method in class cn.idev.excel.context.AnalysisContextImpl

ReadWorkbookHolder - Class in cn.idev.excel.read.metadata.holder

Workbook holder

ReadWorkbookHolder(ReadWorkbook) - Constructor for class cn.idev.excel.read.metadata.holder.ReadWorkbookHolder

recordSeparator(String) - Method in class cn.idev.excel.read.builder.CsvReaderBuilder

Sets the line separator

recordSeparator(String) - Method in class cn.idev.excel.write.builder.CsvWriterBuilder

Sets the line separator

regionMatches(CharSequence, boolean, int, CharSequence, int, int) - Static method in class cn.idev.excel.util.StringUtils

Green implementation of regionMatches.

registerConverter(Converter<?>) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

Custom type conversions override the default.

registerReadListener(ReadListener<?>) - Method in class cn.idev.excel.read.builder.AbstractExcelReaderParameterBuilder

Custom type listener run after default

registerReadListenerIfNotNull(ReadListener<?>) - Method in class cn.idev.excel.read.builder.AbstractExcelReaderParameterBuilder

registerWriteHandler(WriteHandler) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Custom write handler

relativeHeadRowIndex(Integer) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Writes the head relative to the existing contents of the sheet.

relativeHeadRowIndex() - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

relativeHeadRowIndex() - Method in interface cn.idev.excel.write.metadata.holder.WriteHolder

Writes the head relative to the existing contents of the sheet.

removeArrayFormula(Cell) - Method in class cn.idev.excel.metadata.csv.CsvSheet

removeCell(Cell) - Method in class cn.idev.excel.metadata.csv.CsvRow

removeCellComment() - Method in class cn.idev.excel.metadata.csv.CsvCell

removeColumnBreak(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

removeFormulaImpl() - Method in class cn.idev.excel.metadata.csv.CsvCell

removeHyperlink() - Method in class cn.idev.excel.metadata.csv.CsvCell

removeMergedRegion(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

removeMergedRegions(Collection<Integer>) - Method in class cn.idev.excel.metadata.csv.CsvSheet

removeName(Name) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

removePrintArea(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

removeRow(Row) - Method in class cn.idev.excel.metadata.csv.CsvSheet

removeRowBreak(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

removeSheetAt(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

removeThreadLocalCache() - Static method in class cn.idev.excel.util.ClassUtils

removeThreadLocalCache() - Static method in class cn.idev.excel.util.DateUtils

removeThreadLocalCache() - Static method in class cn.idev.excel.util.NumberDataFormatterUtils

resolveCglibFieldName(Field) - Static method in class cn.idev.excel.util.FieldUtils

Parsing the name matching cglib。

RichTextStringData - Class in cn.idev.excel.metadata.data

rich text string

RichTextStringData(String) - Constructor for class cn.idev.excel.metadata.data.RichTextStringData

RichTextStringData.IntervalFont - Class in cn.idev.excel.metadata.data

RkRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

RkRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.RkRecordHandler

ROW_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

RowData - Interface in cn.idev.excel.write.metadata

A row of data.

RowHandlerExecutionChain - Class in cn.idev.excel.write.handler.chain

Execute the row handler chain

RowHandlerExecutionChain(RowWriteHandler) - Constructor for class cn.idev.excel.write.handler.chain.RowHandlerExecutionChain

rowHandlerExecutionChain - Variable in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

Execute the row handler chain

RowHeightProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

RowHeightProperty(Short) - Constructor for class cn.idev.excel.metadata.property.RowHeightProperty

rowIterator() - Method in class cn.idev.excel.metadata.csv.CsvSheet

RowTagHandler - Class in cn.idev.excel.analysis.v07.handlers

Cell Handler

RowTagHandler() - Constructor for class cn.idev.excel.analysis.v07.handlers.RowTagHandler

RowTypeEnum - Enum in cn.idev.excel.enums

The types of row

RowWriteHandler - Interface in cn.idev.excel.write.handler

intercepts handle row creation

RowWriteHandlerContext - Class in cn.idev.excel.write.handler.context

row context

RowWriteHandlerContext() - Constructor for class cn.idev.excel.write.handler.context.RowWriteHandlerContext

S

saturatedCast(long) - Static method in class cn.idev.excel.util.IntUtils

Returns the int nearest in value to value.

SECONDS_PER_DAY - Static variable in class cn.idev.excel.util.DateUtils

SECONDS_PER_MINUTE - Static variable in class cn.idev.excel.util.DateUtils

self() - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

setActiveCell(CellAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setActiveSheet(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setAlignment(HorizontalAlignment) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setArrayFormula(String, CellRangeAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setAsActiveCell() - Method in class cn.idev.excel.metadata.csv.CsvCell

setAutobreaks(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setAutoFilter(CellRangeAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setBold(boolean) - Method in class cn.idev.excel.metadata.Font

Deprecated.

setBorderBottom(BorderStyle) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setBorderLeft(BorderStyle) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setBorderRight(BorderStyle) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setBorderTop(BorderStyle) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setBottomBorderColor(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setCachePath(String) - Static method in class cn.idev.excel.util.FileUtils

setCalendar(Calendar, int, int, boolean, boolean) - Static method in class cn.idev.excel.util.DateUtils

setCellComment(Comment) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellErrorValue(byte) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellFormulaImpl(String) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellMap(Map<Integer, Cell>) - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

setCellReferenceType(CellReferenceType) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setCellStyle(CellStyle) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellTypeImpl(CellType) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValue(String) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValue(RichTextString) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValue(boolean) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValueImpl(double) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValueImpl(Date) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValueImpl(LocalDateTime) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValueImpl(Calendar) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValueImpl(String) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCellValueImpl(RichTextString) - Method in class cn.idev.excel.metadata.csv.CsvCell

setCollectionData(Collection) - Method in class cn.idev.excel.write.metadata.fill.FillWrapper

setColumnBreak(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setColumnExtend(int) - Method in class cn.idev.excel.metadata.property.LoopMergeProperty

setColumnGroupCollapsed(int, boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setColumnHidden(int, boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setColumnWidth(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setColumnWidth(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.column.AbstractColumnWidthStyleStrategy

Sets the column width when head create

setColumnWidth(WriteSheetHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.style.column.AbstractColumnWidthStyleStrategy

Sets the column width when head create

setColumnWidth(WriteSheetHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.style.column.AbstractHeadColumnWidthStyleStrategy

setColumnWidth(WriteSheetHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class cn.idev.excel.write.style.column.LongestMatchColumnWidthStyleStrategy

setContentCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of content

setContentCellStyle(Cell, Head, Integer) - Method in class cn.idev.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of content

setContentCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

setContentCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.HorizontalCellStyleStrategy

setContentColumnHeight(Row, int) - Method in class cn.idev.excel.write.style.row.AbstractRowHeightStyleStrategy

Sets the height of content

setContentColumnHeight(Row, int) - Method in class cn.idev.excel.write.style.row.SimpleRowHeightStyleStrategy

setCurrentRowAnalysisResult(Object) - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

setDataFormat(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setDefaultColumnStyle(int, CellStyle) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDefaultColumnWidth(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDefaultNumberFormat(Format) - Method in class cn.idev.excel.metadata.format.DataFormatter

Sets a default number format to be used when the Excel format cannot be parsed successfully.

setDefaultRowHeight(short) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDefaultRowHeightInPoints(float) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDisplayFormulas(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDisplayGridlines(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDisplayGuts(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDisplayRowColHeadings(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setDisplayZeros(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setEachRow(int) - Method in class cn.idev.excel.metadata.property.LoopMergeProperty

setExcelStyleRoundingMode(DecimalFormat) - Static method in class cn.idev.excel.metadata.format.DataFormatter

Enables excel style rounding mode (round half up) on the Decimal Format given.

setExcelStyleRoundingMode(DecimalFormat, RoundingMode) - Static method in class cn.idev.excel.metadata.format.DataFormatter

Enables custom rounding mode on the given Decimal Format.

setFillBackgroundColor(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setFillBackgroundColor(Color) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setFillForegroundColor(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setFillForegroundColor(Color) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setFillPattern(FillPatternType) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setFirstColumnIndex(Integer) - Method in class cn.idev.excel.metadata.CellExtra

setFirstColumnIndex(int) - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

setFirstRowIndex(Integer) - Method in class cn.idev.excel.metadata.CellExtra

setFirstRowIndex(int) - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

setFirstVisibleTab(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setFitToPage(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setFont(Font) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setFontHeightInPoints(short) - Method in class cn.idev.excel.metadata.Font

Deprecated.

setFontName(String) - Method in class cn.idev.excel.metadata.Font

Deprecated.

setForceFormulaRecalculation(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setForceFormulaRecalculation(boolean) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setFormat(String) - Method in class cn.idev.excel.metadata.property.NumberFormatProperty

setGlobalConfiguration(GlobalConfiguration) - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

setHeadCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of header

setHeadCellStyle(Cell, Head, Integer) - Method in class cn.idev.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of header

setHeadCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

setHeadCellStyle(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.HorizontalCellStyleStrategy

setHeadColumnHeight(Row, int) - Method in class cn.idev.excel.write.style.row.AbstractRowHeightStyleStrategy

Sets the height of header

setHeadColumnHeight(Row, int) - Method in class cn.idev.excel.write.style.row.SimpleRowHeightStyleStrategy

setHeight(short) - Method in class cn.idev.excel.metadata.csv.CsvRow

setHeight(Short) - Method in class cn.idev.excel.metadata.property.RowHeightProperty

setHeightInPoints(float) - Method in class cn.idev.excel.metadata.csv.CsvRow

setHidden(boolean) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setHidden(boolean) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setHidden(boolean) - Method in class cn.idev.excel.read.metadata.ReadSheet

setHorizontallyCenter(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setHyperlink(Hyperlink) - Method in class cn.idev.excel.metadata.csv.CsvCell

setIfNotNull(Consumer<T>, T) - Static method in class cn.idev.excel.util.StyleUtil

setIndention(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setLastColumnIndex(Integer) - Method in class cn.idev.excel.metadata.CellExtra

setLastColumnIndex(int) - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

setLastRowIndex(Integer) - Method in class cn.idev.excel.metadata.CellExtra

setLastRowIndex(int) - Method in class cn.idev.excel.metadata.property.OnceAbsoluteMergeProperty

setLeftBorderColor(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setList(List<Object>) - Method in class cn.idev.excel.event.SyncReadListener

setLocked(boolean) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setMargin(short, double) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setMargin(PageMargin, double) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setMissingCellPolicy(Row.MissingCellPolicy) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setName(String) - Method in class cn.idev.excel.write.metadata.fill.FillWrapper

setNumRows(Integer) - Method in class cn.idev.excel.read.metadata.ReadSheet

setPoiFilesPath(String) - Static method in class cn.idev.excel.util.FileUtils

setPrintArea(int, String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setPrintArea(int, int, int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setPrintGridlines(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setPrintRowAndColumnHeadings(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setQuotePrefixed(boolean) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setRepeatingColumns(CellRangeAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRepeatingRows(CellRangeAddress) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRightBorderColor(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setRightToLeft(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRotation(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setRoundingMode(RoundingMode) - Method in class cn.idev.excel.metadata.property.NumberFormatProperty

setRowBreak(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRowGroupCollapsed(int, boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRowIndex(Integer) - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

setRowNum(int) - Method in class cn.idev.excel.metadata.csv.CsvRow

setRowStyle(CellStyle) - Method in class cn.idev.excel.metadata.csv.CsvRow

setRowSumsBelow(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRowSumsRight(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setRowType(RowTypeEnum) - Method in class cn.idev.excel.read.metadata.holder.ReadRowHolder

setSelected(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setSelectedTab(int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setSheetHidden(int, boolean) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setSheetName(int, String) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setSheetName(String) - Method in class cn.idev.excel.read.metadata.ReadSheet

setSheetNo(Integer) - Method in class cn.idev.excel.read.metadata.ReadSheet

setSheetOrder(String, int) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setSheetVisibility(int, SheetVisibility) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

setShrinkToFit(boolean) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setTempFilePrefix(String) - Static method in class cn.idev.excel.util.FileUtils

setText(String) - Method in class cn.idev.excel.metadata.CellExtra

setTopBorderColor(short) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setType(CellExtraTypeEnum) - Method in class cn.idev.excel.metadata.CellExtra

setVerticalAlignment(VerticalAlignment) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setVerticallyCenter(boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

setVeryHidden(boolean) - Method in class cn.idev.excel.read.metadata.ReadSheet

setWidth(Integer) - Method in class cn.idev.excel.metadata.property.ColumnWidthProperty

setWrapText(boolean) - Method in class cn.idev.excel.metadata.csv.CsvCellStyle

setZeroHeight(boolean) - Method in class cn.idev.excel.metadata.csv.CsvRow

setZoom(int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

SHARED_STRINGS_PART_NAME - Static variable in class cn.idev.excel.analysis.v07.XlsxSaxAnalyser

Storage sheet SharedStrings

SHAREDSTRINGS_NS2_RPH_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_NS2_SI_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_NS2_T_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_RPH_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

Mac 2016 2017 will have this extra field to ignore

SHAREDSTRINGS_SI_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SharedStringItem

SHAREDSTRINGS_T_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

text

SHAREDSTRINGS_X_RPH_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_X_SI_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_X_T_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

SharedStringsTableHandler - Class in cn.idev.excel.analysis.v07.handlers.sax

Sax read sharedStringsTable.xml

SharedStringsTableHandler(ReadCache) - Constructor for class cn.idev.excel.analysis.v07.handlers.sax.SharedStringsTableHandler

sheet() - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

sheet(Integer) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

sheet(String) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

sheet(Integer, String) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

sheet() - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

sheet(Integer) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

sheet(String) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

sheet(Integer, String) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

SHEET_ORDER - Static variable in class cn.idev.excel.constant.OrderConstant

Sorting of sheets

SheetHandlerExecutionChain - Class in cn.idev.excel.write.handler.chain

Execute the sheet handler chain

SheetHandlerExecutionChain(SheetWriteHandler) - Constructor for class cn.idev.excel.write.handler.chain.SheetHandlerExecutionChain

sheetHandlerExecutionChain - Variable in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

Execute the sheet handler chain

sheetIterator() - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

sheetList() - Method in class cn.idev.excel.analysis.csv.CsvExcelReadExecutor

sheetList() - Method in interface cn.idev.excel.analysis.ExcelReadExecutor

Returns the actual sheet in excel

sheetList() - Method in class cn.idev.excel.analysis.v03.XlsSaxAnalyser

Retrieves the list of sheets in the workbook.

sheetList() - Method in class cn.idev.excel.analysis.v07.XlsxSaxAnalyser

sheetName(String) - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

sheet name

sheetName(String) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

sheet name

sheetNameIfNotNull(String) - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

sheetNameIfNotNull(String) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

sheetNo(Integer) - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

Starting from 0

sheetNo(Integer) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

Starting from 0

sheetNoIfNotNull(Integer) - Method in class cn.idev.excel.read.builder.ExcelReaderSheetBuilder

sheetNoIfNotNull(Integer) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

SheetUtils - Class in cn.idev.excel.util

Sheet utils

SheetWriteHandler - Interface in cn.idev.excel.write.handler

intercepts handle sheet creation

SheetWriteHandlerContext - Class in cn.idev.excel.write.handler.context

sheet context

SheetWriteHandlerContext() - Constructor for class cn.idev.excel.write.handler.context.SheetWriteHandlerContext

shiftCellsLeft(int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvRow

shiftCellsRight(int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvRow

shiftColumns(int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

shiftRows(int, int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

shiftRows(int, int, int, boolean, boolean) - Method in class cn.idev.excel.metadata.csv.CsvSheet

ShortBooleanConverter - Class in cn.idev.excel.converters.shortconverter

Short and boolean converter

ShortBooleanConverter() - Constructor for class cn.idev.excel.converters.shortconverter.ShortBooleanConverter

ShortNumberConverter - Class in cn.idev.excel.converters.shortconverter

Short and number converter

ShortNumberConverter() - Constructor for class cn.idev.excel.converters.shortconverter.ShortNumberConverter

ShortStringConverter - Class in cn.idev.excel.converters.shortconverter

Short and string converter

ShortStringConverter() - Constructor for class cn.idev.excel.converters.shortconverter.ShortStringConverter

showInPane(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

SimpleColumnWidthStyleStrategy - Class in cn.idev.excel.write.style.column

All the columns are the same width

SimpleColumnWidthStyleStrategy(Integer) - Constructor for class cn.idev.excel.write.style.column.SimpleColumnWidthStyleStrategy

SimpleReadCacheSelector - Class in cn.idev.excel.cache.selector

Simple cache selector

SimpleReadCacheSelector() - Constructor for class cn.idev.excel.cache.selector.SimpleReadCacheSelector

SimpleReadCacheSelector(Long, Integer) - Constructor for class cn.idev.excel.cache.selector.SimpleReadCacheSelector

Deprecated.

SimpleRowHeightStyleStrategy - Class in cn.idev.excel.write.style.row

Set the head column high and content column high

SimpleRowHeightStyleStrategy(Short, Short) - Constructor for class cn.idev.excel.write.style.row.SimpleRowHeightStyleStrategy

size() - Method in class cn.idev.excel.write.metadata.CollectionRowData

size() - Method in class cn.idev.excel.write.metadata.MapRowData

size() - Method in interface cn.idev.excel.write.metadata.RowData

Returns the number of elements in this collection.

sortAndClearUpHandler(List<WriteHandler>, boolean) - Method in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

SPACE - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

commonly used character

SPACE - Static variable in class cn.idev.excel.util.StringUtils

A String for a space character.

SQL_NULL_STRING - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

database NULL value

SstRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

SstRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.SstRecordHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.AbstractXlsxTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.CellFormulaTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.CellTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.CountTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.HyperlinkTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.MergeCellTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.RowTagHandler

startElement(String, String, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.sax.SharedStringsTableHandler

startElement(String, String, String, Attributes) - Method in class cn.idev.excel.analysis.v07.handlers.sax.XlsxRowHandler

startElement(XlsxReadContext, String, Attributes) - Method in interface cn.idev.excel.analysis.v07.handlers.XlsxTagHandler

Start handle

stopProcessing(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.AbstractVerticalCellStyleStrategy

stopProcessing(CellWriteHandlerContext) - Method in class cn.idev.excel.write.style.HorizontalCellStyleStrategy

StringBooleanConverter - Class in cn.idev.excel.converters.string

String and boolean converter

StringBooleanConverter() - Constructor for class cn.idev.excel.converters.string.StringBooleanConverter

StringErrorConverter - Class in cn.idev.excel.converters.string

String and error converter

StringErrorConverter() - Constructor for class cn.idev.excel.converters.string.StringErrorConverter

StringImageConverter - Class in cn.idev.excel.converters.string

String and image converter

StringImageConverter() - Constructor for class cn.idev.excel.converters.string.StringImageConverter

StringNumberConverter - Class in cn.idev.excel.converters.string

String and number converter

StringNumberConverter() - Constructor for class cn.idev.excel.converters.string.StringNumberConverter

StringRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

StringRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.StringRecordHandler

StringStringConverter - Class in cn.idev.excel.converters.string

String and string converter

StringStringConverter() - Constructor for class cn.idev.excel.converters.string.StringStringConverter

StringUtils - Class in cn.idev.excel.util

StyleProperty - Class in cn.idev.excel.metadata.property

Configuration from annotations

StyleProperty() - Constructor for class cn.idev.excel.metadata.property.StyleProperty

StyleUtil - Class in cn.idev.excel.util

support(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.AbstractXlsRecordHandler

support(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.HyperlinkRecordHandler

support(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.MergeCellsRecordHandler

support(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.NoteRecordHandler

support(XlsReadContext, Record) - Method in class cn.idev.excel.analysis.v03.handlers.TextObjectRecordHandler

support(XlsReadContext, Record) - Method in interface cn.idev.excel.analysis.v03.XlsRecordHandler

Whether to support

support(XlsxReadContext) - Method in class cn.idev.excel.analysis.v07.handlers.AbstractXlsxTagHandler

support(XlsxReadContext) - Method in class cn.idev.excel.analysis.v07.handlers.HyperlinkTagHandler

support(XlsxReadContext) - Method in class cn.idev.excel.analysis.v07.handlers.MergeCellTagHandler

support(XlsxReadContext) - Method in interface cn.idev.excel.analysis.v07.handlers.XlsxTagHandler

Whether to support

supportExcelTypeKey() - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalBooleanConverter

Returns the Excel cell data type key supported by this converter.

supportExcelTypeKey() - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalNumberConverter

Specifies the Excel cell data type supported by this converter.

supportExcelTypeKey() - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalStringConverter

Specifies the Excel cell data type supported by this converter.

supportExcelTypeKey() - Method in class cn.idev.excel.converters.biginteger.BigIntegerBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.biginteger.BigIntegerNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.biginteger.BigIntegerStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.booleanconverter.BooleanBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.booleanconverter.BooleanNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.booleanconverter.BooleanStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.byteconverter.ByteBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.byteconverter.ByteNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.byteconverter.ByteStringConverter

supportExcelTypeKey() - Method in interface cn.idev.excel.converters.Converter

Back to object enum in excel

supportExcelTypeKey() - Method in class cn.idev.excel.converters.date.DateNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.date.DateStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.doubleconverter.DoubleBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.doubleconverter.DoubleNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.doubleconverter.DoubleStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.floatconverter.FloatBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.floatconverter.FloatNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.floatconverter.FloatStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.integer.IntegerBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.integer.IntegerNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.integer.IntegerStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.localdate.LocalDateNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.localdate.LocalDateStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.longconverter.LongBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.longconverter.LongNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.longconverter.LongStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.shortconverter.ShortBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.shortconverter.ShortNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.shortconverter.ShortStringConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.string.StringBooleanConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.string.StringErrorConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.string.StringNumberConverter

supportExcelTypeKey() - Method in class cn.idev.excel.converters.string.StringStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalBooleanConverter

Returns the Java type key supported by this converter.

supportJavaTypeKey() - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalNumberConverter

Specifies the Java type supported by this converter.

supportJavaTypeKey() - Method in class cn.idev.excel.converters.bigdecimal.BigDecimalStringConverter

Specifies the Java type supported by this converter.

supportJavaTypeKey() - Method in class cn.idev.excel.converters.biginteger.BigIntegerBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.biginteger.BigIntegerNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.biginteger.BigIntegerStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.booleanconverter.BooleanBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.booleanconverter.BooleanNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.booleanconverter.BooleanStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.bytearray.BoxingByteArrayImageConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.bytearray.ByteArrayImageConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.byteconverter.ByteBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.byteconverter.ByteNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.byteconverter.ByteStringConverter

supportJavaTypeKey() - Method in interface cn.idev.excel.converters.Converter

Back to object types in Java

supportJavaTypeKey() - Method in class cn.idev.excel.converters.date.DateDateConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.date.DateNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.date.DateStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.doubleconverter.DoubleBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.doubleconverter.DoubleNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.doubleconverter.DoubleStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.file.FileImageConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.floatconverter.FloatBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.floatconverter.FloatNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.floatconverter.FloatStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.inputstream.InputStreamImageConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.integer.IntegerBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.integer.IntegerNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.integer.IntegerStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.localdate.LocalDateDateConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.localdate.LocalDateNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.localdate.LocalDateStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeDateConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.localdatetime.LocalDateTimeStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.longconverter.LongBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.longconverter.LongNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.longconverter.LongStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.shortconverter.ShortBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.shortconverter.ShortNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.shortconverter.ShortStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.string.StringBooleanConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.string.StringErrorConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.string.StringImageConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.string.StringNumberConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.string.StringStringConverter

supportJavaTypeKey() - Method in class cn.idev.excel.converters.url.UrlImageConverter

switchBuiltinFormats(Locale) - Static method in class cn.idev.excel.constant.BuiltinFormats

switchBuiltinFormatsMap(Locale) - Static method in class cn.idev.excel.constant.BuiltinFormats

switchDateFormat(String) - Static method in class cn.idev.excel.util.DateUtils

switch date format

SyncReadListener - Class in cn.idev.excel.event

Synchronous data reading

SyncReadListener() - Constructor for class cn.idev.excel.event.SyncReadListener

T

TAB - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

field related

table() - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

table(Integer) - Method in class cn.idev.excel.write.builder.ExcelWriterSheetBuilder

tableNo(Integer) - Method in class cn.idev.excel.write.builder.ExcelWriterTableBuilder

Starting from 0

tableNoIfNotNull(Integer) - Method in class cn.idev.excel.write.builder.ExcelWriterTableBuilder

TextObjectRecordHandler - Class in cn.idev.excel.analysis.v03.handlers

Record handler

TextObjectRecordHandler() - Constructor for class cn.idev.excel.analysis.v03.handlers.TextObjectRecordHandler

toByteArray(InputStream) - Static method in class cn.idev.excel.util.IoUtils

Gets the contents of an InputStream as a byte[].

toByteArray(InputStream, int) - Static method in class cn.idev.excel.util.IoUtils

Gets the contents of an InputStream as a byte[].

toString() - Method in class cn.idev.excel.read.metadata.ReadSheet

U

ungroupColumn(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

ungroupRow(int, int) - Method in class cn.idev.excel.metadata.csv.CsvSheet

UNICODE_EMPTY - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

unicode

UNICODE_LINE_SEPARATOR - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

UNICODE_NEX_LINE - Static variable in class cn.idev.excel.metadata.csv.CsvConstant

UniqueDataFlagKey() - Constructor for class cn.idev.excel.write.executor.ExcelWriteFillExecutor.UniqueDataFlagKey

uniqueValue() - Method in interface cn.idev.excel.event.NotRepeatExecutor

To see if it's the same executor

urlConnectTimeout - Static variable in class cn.idev.excel.converters.url.UrlImageConverter

UrlImageConverter - Class in cn.idev.excel.converters.url

Url and image converter

UrlImageConverter() - Constructor for class cn.idev.excel.converters.url.UrlImageConverter

urlReadTimeout - Static variable in class cn.idev.excel.converters.url.UrlImageConverter

use1904windowing(Boolean) - Method in class cn.idev.excel.metadata.AbstractParameterBuilder

true if date uses 1904 windowing, or false if using 1900 date windowing.

useDefaultListener(Boolean) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

Whether to use the default listener, which is used by default.

useDefaultStyle(Boolean) - Method in class cn.idev.excel.write.builder.AbstractExcelWriterParameterBuilder

Use the default style.Default is true.

useScientificFormat(Boolean) - Method in class cn.idev.excel.read.builder.AbstractExcelReaderParameterBuilder

Whether to use scientific Format.

V

Validate - Class in cn.idev.excel.util

Validate() - Constructor for class cn.idev.excel.util.Validate

validateMergedRegions() - Method in class cn.idev.excel.metadata.csv.CsvSheet

valueOf(String) - Static method in enum cn.idev.excel.enums.BooleanEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.ByteOrderMarkEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.CacheLocationEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.CellDataTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.CellExtraTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.HeadKindEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.HolderEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.NumericCellTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.poi.BorderStyleEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.poi.FillPatternTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.poi.HorizontalAlignmentEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.poi.VerticalAlignmentEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.ReadDefaultReturnEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.RowTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.WriteDirectionEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.WriteLastRowTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.WriteTemplateAnalysisCellTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.enums.WriteTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.metadata.data.ClientAnchorData.AnchorType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.metadata.data.HyperlinkData.HyperlinkType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.metadata.data.ImageData.ImageType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum cn.idev.excel.support.ExcelTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(ReadWorkbook) - Static method in enum cn.idev.excel.support.ExcelTypeEnum

valueOf(String) - Static method in class cn.idev.excel.util.BooleanUtils

String to boolean

valueOfByCharsetName(String) - Static method in enum cn.idev.excel.enums.ByteOrderMarkEnum

values() - Static method in enum cn.idev.excel.enums.BooleanEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.ByteOrderMarkEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.CacheLocationEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.CellDataTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.CellExtraTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.HeadKindEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.HolderEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.NumericCellTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.poi.BorderStyleEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.poi.FillPatternTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.poi.HorizontalAlignmentEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.poi.VerticalAlignmentEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.ReadDefaultReturnEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.RowTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.WriteDirectionEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.WriteLastRowTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.WriteTemplateAnalysisCellTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.enums.WriteTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.metadata.data.ClientAnchorData.AnchorType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.metadata.data.HyperlinkData.HyperlinkType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.metadata.data.ImageData.ImageType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum cn.idev.excel.support.ExcelTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

VerticalAlignmentEnum - Enum in cn.idev.excel.enums.poi

This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.

W

withBom(Boolean) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Set the encoding prefix in the csv file, otherwise the office may open garbled characters.

withTemplate(InputStream) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Template file.

withTemplate(File) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Template file.

withTemplate(String) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Template file.

WorkbookHandlerExecutionChain - Class in cn.idev.excel.write.handler.chain

Execute the workbook handler chain

WorkbookHandlerExecutionChain(WorkbookWriteHandler) - Constructor for class cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain

workbookHandlerExecutionChain - Variable in class cn.idev.excel.write.metadata.holder.AbstractWriteHolder

Execute the workbook handler chain

WorkBookUtil - Class in cn.idev.excel.util

WorkbookWriteHandler - Interface in cn.idev.excel.write.handler

intercepts handle Workbook creation

WorkbookWriteHandlerContext - Class in cn.idev.excel.write.handler.context

workbook context

WorkbookWriteHandlerContext() - Constructor for class cn.idev.excel.write.handler.context.WorkbookWriteHandlerContext

write(Collection<?>, WriteSheet) - Method in class cn.idev.excel.ExcelWriter

Write data to a sheet

write(Supplier<Collection<?>>, WriteSheet) - Method in class cn.idev.excel.ExcelWriter

Write data to a sheet

write(Collection<?>, WriteSheet, WriteTable) - Method in class cn.idev.excel.ExcelWriter

Write value to a sheet

write(Supplier<Collection<?>>, WriteSheet, WriteTable) - Method in class cn.idev.excel.ExcelWriter

Write value to a sheet

write() - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(File) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(File, Class) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(String) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(String, Class) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(OutputStream) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(OutputStream, Class) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the write

write(OutputStream) - Method in class cn.idev.excel.metadata.csv.CsvWorkbook

WriteBasicParameter - Class in cn.idev.excel.write.metadata

Write basic parameter

WriteBasicParameter() - Constructor for class cn.idev.excel.write.metadata.WriteBasicParameter

WriteCellData<T> - Class in cn.idev.excel.metadata.data

Class representing data for writing to a cell in an Excel sheet.

WriteCellData(String) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a string value.

WriteCellData(CellDataTypeEnum) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a specified cell data type.

WriteCellData(CellDataTypeEnum, String) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a specified cell data type and string value.

WriteCellData(BigDecimal) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a BigDecimal number value.

WriteCellData(Boolean) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a boolean value.

WriteCellData(Date) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a Date value.

WriteCellData(LocalDateTime) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with a LocalDateTime value.

WriteCellData(byte[]) - Constructor for class cn.idev.excel.metadata.data.WriteCellData

Constructor for creating a WriteCellData object with image data.

WriteCellStyle - Class in cn.idev.excel.write.metadata.style

Cell style when writing

WriteCellStyle() - Constructor for class cn.idev.excel.write.metadata.style.WriteCellStyle

WriteContext - Interface in cn.idev.excel.context

Write context

writeContext() - Method in class cn.idev.excel.ExcelWriter

The context of the entire writing process

writeContext() - Method in interface cn.idev.excel.write.ExcelBuilder

Gets the written data

writeContext() - Method in class cn.idev.excel.write.ExcelBuilderImpl

writeContext - Variable in class cn.idev.excel.write.executor.AbstractExcelWriteExecutor

WriteContextImpl - Class in cn.idev.excel.context

Implementation of the WriteContext interface, which serves as the main anchorage point for writing Excel files.

WriteContextImpl(WriteWorkbook) - Constructor for class cn.idev.excel.context.WriteContextImpl

Constructor to initialize the WriteContextImpl with a WriteWorkbook.

WriteConverterContext<T> - Class in cn.idev.excel.converters

write converter context

WriteConverterContext() - Constructor for class cn.idev.excel.converters.WriteConverterContext

WriteDirectionEnum - Enum in cn.idev.excel.enums

Direction of writing

writeExcelOnException(Boolean) - Method in class cn.idev.excel.write.builder.ExcelWriterBuilder

Excel is also written in the event of an exception being thrown.The default false.

WriteFont - Class in cn.idev.excel.write.metadata.style

Font when writing

WriteFont() - Constructor for class cn.idev.excel.write.metadata.style.WriteFont

WriteHandler - Interface in cn.idev.excel.write.handler

intercepts handle excel write

WriteHandlerUtils - Class in cn.idev.excel.util

Write handler utils

WriteHolder - Interface in cn.idev.excel.write.metadata.holder

Get the corresponding Holder

WriteLastRowTypeEnum - Enum in cn.idev.excel.enums

The types of write last row

writerSheet() - Static method in class cn.idev.excel.FastExcelFactory

Build excel the writerSheet

writerSheet(Integer) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the writerSheet

writerSheet(String) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'writerSheet'

writerSheet(Integer, String) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'writerSheet'

writerTable() - Static method in class cn.idev.excel.FastExcelFactory

Build excel the writerTable

writerTable(Integer) - Static method in class cn.idev.excel.FastExcelFactory

Build excel the 'writerTable'

WriteSheet - Class in cn.idev.excel.write.metadata

Write sheet

WriteSheet() - Constructor for class cn.idev.excel.write.metadata.WriteSheet

writeSheetHolder() - Method in interface cn.idev.excel.context.WriteContext

All information about the sheet you are currently working on

writeSheetHolder() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the current sheet holder.

WriteSheetHolder - Class in cn.idev.excel.write.metadata.holder

sheet holder

WriteSheetHolder(WriteSheet, WriteWorkbookHolder) - Constructor for class cn.idev.excel.write.metadata.holder.WriteSheetHolder

WriteSheetWorkbookWriteHandler - Class in cn.idev.excel.write.handler.impl

Set the order of each worksheet after completing workbook processing.

WriteSheetWorkbookWriteHandler() - Constructor for class cn.idev.excel.write.handler.impl.WriteSheetWorkbookWriteHandler

WriteTable - Class in cn.idev.excel.write.metadata

table

WriteTable() - Constructor for class cn.idev.excel.write.metadata.WriteTable

writeTableHolder() - Method in interface cn.idev.excel.context.WriteContext

All information about the table you are currently working on

writeTableHolder() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the current table holder.

WriteTableHolder - Class in cn.idev.excel.write.metadata.holder

sheet holder

WriteTableHolder(WriteTable, WriteSheetHolder) - Constructor for class cn.idev.excel.write.metadata.holder.WriteTableHolder

WriteTemplateAnalysisCellTypeEnum - Enum in cn.idev.excel.enums

Type of template to read when writing

writeToFile(File, InputStream) - Static method in class cn.idev.excel.util.FileUtils

Write inputStream to file

writeToFile(File, InputStream, boolean) - Static method in class cn.idev.excel.util.FileUtils

Write inputStream to file

WriteTypeEnum - Enum in cn.idev.excel.enums

Enumeration of write methods

WriteWorkbook - Class in cn.idev.excel.write.metadata

Workbook

WriteWorkbook() - Constructor for class cn.idev.excel.write.metadata.WriteWorkbook

writeWorkbookHolder() - Method in interface cn.idev.excel.context.WriteContext

All information about the workbook you are currently working on

writeWorkbookHolder() - Method in class cn.idev.excel.context.WriteContextImpl

Retrieves the current workbook holder.

WriteWorkbookHolder - Class in cn.idev.excel.write.metadata.holder

Workbook holder

WriteWorkbookHolder(WriteWorkbook) - Constructor for class cn.idev.excel.write.metadata.holder.WriteWorkbookHolder

X

X_CELL_FORMULA_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

X_CELL_INLINE_STRING_VALUE_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

When the data is "inlineStr" his tag is "t"

X_CELL_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

X_CELL_VALUE_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

X_DIMENSION_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

X_HYPERLINK_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

X_MERGE_CELL_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

X_ROW_TAG - Static variable in class cn.idev.excel.constant.ExcelXmlConstants

XlsCache - Class in cn.idev.excel.cache

Use SSTRecord.

XlsCache(SSTRecord) - Constructor for class cn.idev.excel.cache.XlsCache

XlsListSheetListener - Class in cn.idev.excel.analysis.v03

In some cases, you need to know the number of sheets in advance and only read the file once in advance.

XlsListSheetListener(XlsReadContext) - Constructor for class cn.idev.excel.analysis.v03.XlsListSheetListener

Constructor for initializing the listener with a given context.

XlsReadContext - Interface in cn.idev.excel.context.xls

A context is the main anchorage point of a ls xls reader.

xlsReadSheetHolder() - Method in class cn.idev.excel.context.xls.DefaultXlsReadContext

xlsReadSheetHolder() - Method in interface cn.idev.excel.context.xls.XlsReadContext

All information about the sheet you are currently working on.

XlsReadSheetHolder - Class in cn.idev.excel.read.metadata.holder.xls

sheet holder

XlsReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class cn.idev.excel.read.metadata.holder.xls.XlsReadSheetHolder

xlsReadWorkbookHolder() - Method in class cn.idev.excel.context.xls.DefaultXlsReadContext

xlsReadWorkbookHolder() - Method in interface cn.idev.excel.context.xls.XlsReadContext

All information about the workbook you are currently working on.

XlsReadWorkbookHolder - Class in cn.idev.excel.read.metadata.holder.xls

Workbook holder

XlsReadWorkbookHolder(ReadWorkbook) - Constructor for class cn.idev.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

XlsRecordHandler - Interface in cn.idev.excel.analysis.v03

Intercepts handle xls reads.

XlsSaxAnalyser - Class in cn.idev.excel.analysis.v03

A text extractor for Excel files.

XlsSaxAnalyser(XlsReadContext) - Constructor for class cn.idev.excel.analysis.v03.XlsSaxAnalyser

Constructor to initialize the XlsSaxAnalyser with the given context.

XlsxReadContext - Interface in cn.idev.excel.context.xlsx

A context is the main anchorage point of a ls xlsx reader.

xlsxReadSheetHolder() - Method in class cn.idev.excel.context.xlsx.DefaultXlsxReadContext

xlsxReadSheetHolder() - Method in interface cn.idev.excel.context.xlsx.XlsxReadContext

All information about the sheet you are currently working on.

XlsxReadSheetHolder - Class in cn.idev.excel.read.metadata.holder.xlsx

sheet holder

XlsxReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class cn.idev.excel.read.metadata.holder.xlsx.XlsxReadSheetHolder

xlsxReadWorkbookHolder() - Method in class cn.idev.excel.context.xlsx.DefaultXlsxReadContext

xlsxReadWorkbookHolder() - Method in interface cn.idev.excel.context.xlsx.XlsxReadContext

All information about the workbook you are currently working on.

XlsxReadWorkbookHolder - Class in cn.idev.excel.read.metadata.holder.xlsx

Workbook holder

XlsxReadWorkbookHolder(ReadWorkbook) - Constructor for class cn.idev.excel.read.metadata.holder.xlsx.XlsxReadWorkbookHolder

XlsxRowHandler - Class in cn.idev.excel.analysis.v07.handlers.sax

XlsxRowHandler(XlsxReadContext) - Constructor for class cn.idev.excel.analysis.v07.handlers.sax.XlsxRowHandler

XlsxSaxAnalyser - Class in cn.idev.excel.analysis.v07

XlsxSaxAnalyser(XlsxReadContext, InputStream) - Constructor for class cn.idev.excel.analysis.v07.XlsxSaxAnalyser

xlsxSAXParserFactoryName(String) - Method in class cn.idev.excel.read.builder.ExcelReaderBuilder

SAXParserFactory used when reading xlsx.

XlsxTagHandler - Interface in cn.idev.excel.analysis.v07.handlers

Tag handler

A B C D E F G H I L M N O P Q R S T U V W X