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

A

AbstractCell - Class in com.alibaba.excel.metadata

cell

AbstractCell() - Constructor for class com.alibaba.excel.metadata.AbstractCell

AbstractCellStyleStrategy - Class in com.alibaba.excel.write.style

Cell style strategy

AbstractCellStyleStrategy() - Constructor for class com.alibaba.excel.write.style.AbstractCellStyleStrategy

AbstractCellValueTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Value Handler

AbstractCellValueTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.AbstractCellValueTagHandler

AbstractCellWriteHandler - Class in com.alibaba.excel.write.handler

Deprecated.

Please use it directly CellWriteHandler

AbstractCellWriteHandler() - Constructor for class com.alibaba.excel.write.handler.AbstractCellWriteHandler

Deprecated.

AbstractColumnWidthStyleStrategy - Class in com.alibaba.excel.write.style.column

Column width style strategy

AbstractColumnWidthStyleStrategy() - Constructor for class com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy

AbstractExcelReaderParameterBuilder<T extends AbstractExcelReaderParameterBuilder,C extends ReadBasicParameter> - Class in com.alibaba.excel.read.builder

Build ExcelBuilder

AbstractExcelReaderParameterBuilder() - Constructor for class com.alibaba.excel.read.builder.AbstractExcelReaderParameterBuilder

AbstractExcelWriteExecutor - Class in com.alibaba.excel.write.executor

Excel write Executor

AbstractExcelWriteExecutor(WriteContext) - Constructor for class com.alibaba.excel.write.executor.AbstractExcelWriteExecutor

AbstractExcelWriterParameterBuilder<T extends AbstractExcelWriterParameterBuilder,C extends WriteBasicParameter> - Class in com.alibaba.excel.write.builder

Build ExcelBuilder

AbstractExcelWriterParameterBuilder() - Constructor for class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

AbstractHeadColumnWidthStyleStrategy - Class in com.alibaba.excel.write.style.column

Returns the column width according to each column header

AbstractHeadColumnWidthStyleStrategy() - Constructor for class com.alibaba.excel.write.style.column.AbstractHeadColumnWidthStyleStrategy

AbstractHolder - Class in com.alibaba.excel.metadata

Write/read holder

AbstractHolder(BasicParameter, AbstractHolder) - Constructor for class com.alibaba.excel.metadata.AbstractHolder

AbstractIgnoreExceptionReadListener<T> - Class in com.alibaba.excel.event

Deprecated.

Use directly ReadListener

AbstractIgnoreExceptionReadListener() - Constructor for class com.alibaba.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

AbstractMergeStrategy - Class in com.alibaba.excel.write.merge

Merge strategy

AbstractMergeStrategy() - Constructor for class com.alibaba.excel.write.merge.AbstractMergeStrategy

AbstractParameterBuilder<T extends AbstractParameterBuilder,C extends BasicParameter> - Class in com.alibaba.excel.metadata

ExcelBuilder

AbstractParameterBuilder() - Constructor for class com.alibaba.excel.metadata.AbstractParameterBuilder

AbstractReadHolder - Class in com.alibaba.excel.read.metadata.holder

Read Holder

AbstractReadHolder(ReadBasicParameter, AbstractReadHolder) - Constructor for class com.alibaba.excel.read.metadata.holder.AbstractReadHolder

AbstractRowHeightStyleStrategy - Class in com.alibaba.excel.write.style.row

Set the row height strategy

AbstractRowHeightStyleStrategy() - Constructor for class com.alibaba.excel.write.style.row.AbstractRowHeightStyleStrategy

AbstractRowWriteHandler - Class in com.alibaba.excel.write.handler

Deprecated.

Please use it directly RowWriteHandler

AbstractRowWriteHandler() - Constructor for class com.alibaba.excel.write.handler.AbstractRowWriteHandler

Deprecated.

AbstractSheetWriteHandler - Class in com.alibaba.excel.write.handler

Deprecated.

Please use it directly SheetWriteHandler

AbstractSheetWriteHandler() - Constructor for class com.alibaba.excel.write.handler.AbstractSheetWriteHandler

Deprecated.

AbstractVerticalCellStyleStrategy - Class in com.alibaba.excel.write.style

Use the same style for the column

AbstractVerticalCellStyleStrategy() - Constructor for class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

AbstractWorkbookWriteHandler - Class in com.alibaba.excel.write.handler

Deprecated.

Please use it directly WorkbookWriteHandler

AbstractWorkbookWriteHandler() - Constructor for class com.alibaba.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

AbstractWriteHolder - Class in com.alibaba.excel.write.metadata.holder

Write holder configuration

AbstractWriteHolder(WriteBasicParameter, AbstractWriteHolder) - Constructor for class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

AbstractXlsRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Abstract xls record handler

AbstractXlsRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.AbstractXlsRecordHandler

AbstractXlsxTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Abstract tag handler

AbstractXlsxTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.AbstractXlsxTagHandler

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

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

Deprecated.

please useExcelBuilder.addContent(Collection, WriteSheet, WriteTable)

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

WorkBook increase value

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

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

addFormat(String, Format) - Method in class com.alibaba.excel.metadata.format.DataFormatter

Adds a new format to the available formats.

addLast(CellWriteHandler) - Method in class com.alibaba.excel.write.handler.chain.CellHandlerExecutionChain

addLast(RowWriteHandler) - Method in class com.alibaba.excel.write.handler.chain.RowHandlerExecutionChain

addLast(SheetWriteHandler) - Method in class com.alibaba.excel.write.handler.chain.SheetHandlerExecutionChain

addLast(WorkbookWriteHandler) - Method in class com.alibaba.excel.write.handler.chain.WorkbookHandlerExecutionChain

addMergedRegion(CellRangeAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

addMergedRegionUnsafe(CellRangeAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

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

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

addToolPack(UDFFinder) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

addValidationData(DataValidation) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

afterCellCreate(CellWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

afterCellCreate(CellWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.CellWriteHandler

Called after the cell is created

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

Called after the cell is created

afterCellCreate(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.CellHandlerExecutionChain

afterCellDataConverted(CellWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

afterCellDataConverted(CellWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.CellWriteHandler

Called after the cell data is converted

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

Called after the cell data is converted

afterCellDataConverted(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.CellHandlerExecutionChain

afterCellDispose(CellWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

afterCellDispose(CellWriteHandlerContext) - Method in interface com.alibaba.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 com.alibaba.excel.write.handler.CellWriteHandler

Called after all operations on the cell have been completed

afterCellDispose(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.CellHandlerExecutionChain

afterCellDispose(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.impl.FillStyleCellWriteHandler

afterCellDispose(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.merge.AbstractMergeStrategy

afterCellDispose(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractCellStyleStrategy

afterCellDispose(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy

afterRowCreate(RowWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

afterRowCreate(RowWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.RowHandlerExecutionChain

afterRowCreate(RowWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.RowWriteHandler

Called after the row is created

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

Called after the row is created

afterRowDispose(RowWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

afterRowDispose(RowWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.RowHandlerExecutionChain

afterRowDispose(RowWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.impl.DefaultRowWriteHandler

afterRowDispose(RowWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.RowWriteHandler

Called after all operations on the row have been completed.

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

Called after all operations on the row have been completed.

afterRowDispose(RowWriteHandlerContext) - Method in class com.alibaba.excel.write.merge.LoopMergeStrategy

afterRowDispose(RowWriteHandlerContext) - Method in class com.alibaba.excel.write.style.row.AbstractRowHeightStyleStrategy

afterSheetCreate(SheetWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

afterSheetCreate(SheetWriteHandlerContext, boolean) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

afterSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in class com.alibaba.excel.write.handler.AbstractSheetWriteHandler

Deprecated.

afterSheetCreate(SheetWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.SheetHandlerExecutionChain

afterSheetCreate(SheetWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.SheetWriteHandler

Called after the sheet is created

afterSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in interface com.alibaba.excel.write.handler.SheetWriteHandler

Called after the sheet is created

afterSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in class com.alibaba.excel.write.merge.OnceAbsoluteMergeStrategy

afterWorkbookCreate(WorkbookWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

afterWorkbookCreate(WorkbookWriteHandlerContext, boolean) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

afterWorkbookCreate(WriteWorkbookHolder) - Method in class com.alibaba.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

afterWorkbookCreate(WorkbookWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.WorkbookHandlerExecutionChain

afterWorkbookCreate(WorkbookWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.WorkbookWriteHandler

Called after the workbook is created

afterWorkbookCreate(WriteWorkbookHolder) - Method in interface com.alibaba.excel.write.handler.WorkbookWriteHandler

Called after the workbook is created

afterWorkbookDispose(WorkbookWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

afterWorkbookDispose(WriteWorkbookHolder) - Method in class com.alibaba.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

afterWorkbookDispose(WorkbookWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.WorkbookHandlerExecutionChain

afterWorkbookDispose(WriteWorkbookHolder) - Method in class com.alibaba.excel.write.handler.impl.DimensionWorkbookWriteHandler

afterWorkbookDispose(WorkbookWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.WorkbookWriteHandler

Called after all operations on the workbook have been completed

afterWorkbookDispose(WriteWorkbookHolder) - Method in interface com.alibaba.excel.write.handler.WorkbookWriteHandler

Called after all operations on the workbook have been completed

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

parse the sheet

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

AnalysisCell - Class in com.alibaba.excel.write.metadata.fill

Read the cells of the template while populating the data.

AnalysisCell() - Constructor for class com.alibaba.excel.write.metadata.fill.AnalysisCell

analysisContext() - Method in interface com.alibaba.excel.analysis.ExcelAnalyser

get the analysis context.

analysisContext() - Method in class com.alibaba.excel.analysis.ExcelAnalyserImpl

AnalysisContext - Interface in com.alibaba.excel.context

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

analysisContext() - Method in class com.alibaba.excel.ExcelReader

Context for the entire execution process

AnalysisContextImpl - Class in com.alibaba.excel.context

AnalysisContextImpl(ReadWorkbook, ExcelTypeEnum) - Constructor for class com.alibaba.excel.context.AnalysisContextImpl

AnalysisEventListener<T> - Class in com.alibaba.excel.event

Receives the return of each piece of data parsed

AnalysisEventListener() - Constructor for class com.alibaba.excel.event.AnalysisEventListener

analysisEventProcessor() - Method in interface com.alibaba.excel.context.AnalysisContext

Event processor

analysisEventProcessor() - Method in class com.alibaba.excel.context.AnalysisContextImpl

AnalysisEventProcessor - Interface in com.alibaba.excel.read.processor

Event processor

ANNOTATION_DEFINE_STYLE - Static variable in class com.alibaba.excel.constant.OrderConstant

Annotation style definition

applyFont(int, int, short) - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

applyFont(int, int, Font) - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

applyFont(Font) - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

applyFont(short) - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

applyFont(int, int, WriteFont) - Method in class com.alibaba.excel.metadata.data.RichTextStringData

Applies a font to the specified characters of a string.

applyFont(WriteFont) - Method in class com.alibaba.excel.metadata.data.RichTextStringData

Sets the font of the entire string.

ATTRIBUTE_LOCATION - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

location attribute

ATTRIBUTE_R - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

r attribute

ATTRIBUTE_REF - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

ref attribute

ATTRIBUTE_RID - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

rId attribute

ATTRIBUTE_S - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

s attribute

ATTRIBUTE_T - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

t attribute

autoCloseStream(Boolean) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Default true

autoCloseStream(Boolean) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

Default true

AutoConverter - Class in com.alibaba.excel.converters

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

AutoConverter() - Constructor for class com.alibaba.excel.converters.AutoConverter

automaticMergeHead(Boolean) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Whether to automatically merge headers.Default is true.

automaticMergeHead() - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

automaticMergeHead() - Method in interface com.alibaba.excel.write.metadata.holder.WriteHolder

Whether need automatic merge headers.

autoSizeColumn(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

autoSizeColumn(int, boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

autoTrim(Boolean) - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

Automatic trim includes sheet name and content

B

BasicParameter - Class in com.alibaba.excel.metadata

Basic parameter

BasicParameter() - Constructor for class com.alibaba.excel.metadata.BasicParameter

BATCH_COUNT - Static variable in class com.alibaba.excel.cache.Ehcache

BATCH_COUNT - Static variable in class com.alibaba.excel.read.listener.PageReadListener

Single handle the amount of data

BeanMapUtils - Class in com.alibaba.excel.util

bean utils

BeanMapUtils() - Constructor for class com.alibaba.excel.util.BeanMapUtils

BeanMapUtils.EasyExcelNamingPolicy - Class in com.alibaba.excel.util

beforeCellCreate(CellWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

beforeCellCreate(CellWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.CellWriteHandler

Called before create the cell

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

Called before create the cell

beforeCellCreate(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.CellHandlerExecutionChain

beforeRowCreate(RowWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

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

Deprecated.

beforeRowCreate(RowWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.RowHandlerExecutionChain

beforeRowCreate(RowWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.RowWriteHandler

Called before create the row

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

Called before create the row

beforeSheetCreate(SheetWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

beforeSheetCreate(SheetWriteHandlerContext, boolean) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

beforeSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in class com.alibaba.excel.write.handler.AbstractSheetWriteHandler

Deprecated.

beforeSheetCreate(SheetWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.SheetHandlerExecutionChain

beforeSheetCreate(SheetWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.SheetWriteHandler

Called before create the sheet

beforeSheetCreate(WriteWorkbookHolder, WriteSheetHolder) - Method in interface com.alibaba.excel.write.handler.SheetWriteHandler

Called before create the sheet

beforeWorkbookCreate(WorkbookWriteHandlerContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

beforeWorkbookCreate(WorkbookWriteHandlerContext, boolean) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

beforeWorkbookCreate() - Method in class com.alibaba.excel.write.handler.AbstractWorkbookWriteHandler

Deprecated.

beforeWorkbookCreate(WorkbookWriteHandlerContext) - Method in class com.alibaba.excel.write.handler.chain.WorkbookHandlerExecutionChain

beforeWorkbookCreate(WorkbookWriteHandlerContext) - Method in interface com.alibaba.excel.write.handler.WorkbookWriteHandler

Called before create the workbook

beforeWorkbookCreate() - Method in interface com.alibaba.excel.write.handler.WorkbookWriteHandler

Called before create the workbook

BigDecimalBooleanConverter - Class in com.alibaba.excel.converters.bigdecimal

BigDecimal and boolean converter

BigDecimalBooleanConverter() - Constructor for class com.alibaba.excel.converters.bigdecimal.BigDecimalBooleanConverter

BigDecimalNumberConverter - Class in com.alibaba.excel.converters.bigdecimal

BigDecimal and number converter

BigDecimalNumberConverter() - Constructor for class com.alibaba.excel.converters.bigdecimal.BigDecimalNumberConverter

BigDecimalStringConverter - Class in com.alibaba.excel.converters.bigdecimal

BigDecimal and string converter

BigDecimalStringConverter() - Constructor for class com.alibaba.excel.converters.bigdecimal.BigDecimalStringConverter

BigIntegerBooleanConverter - Class in com.alibaba.excel.converters.biginteger

BigInteger and boolean converter

BigIntegerBooleanConverter() - Constructor for class com.alibaba.excel.converters.biginteger.BigIntegerBooleanConverter

BigIntegerNumberConverter - Class in com.alibaba.excel.converters.biginteger

BigInteger and number converter

BigIntegerNumberConverter() - Constructor for class com.alibaba.excel.converters.biginteger.BigIntegerNumberConverter

BigIntegerStringConverter - Class in com.alibaba.excel.converters.biginteger

BigDecimal and string converter

BigIntegerStringConverter() - Constructor for class com.alibaba.excel.converters.biginteger.BigIntegerStringConverter

BlankRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

BlankRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.BlankRecordHandler

BofRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

BofRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.BofRecordHandler

BooleanBooleanConverter - Class in com.alibaba.excel.converters.booleanconverter

Boolean and boolean converter

BooleanBooleanConverter() - Constructor for class com.alibaba.excel.converters.booleanconverter.BooleanBooleanConverter

BooleanEnum - Enum in com.alibaba.excel.enums

Default values cannot be used for annotations.

BooleanNumberConverter - Class in com.alibaba.excel.converters.booleanconverter

Boolean and number converter

BooleanNumberConverter() - Constructor for class com.alibaba.excel.converters.booleanconverter.BooleanNumberConverter

BooleanStringConverter - Class in com.alibaba.excel.converters.booleanconverter

Boolean and string converter

BooleanStringConverter() - Constructor for class com.alibaba.excel.converters.booleanconverter.BooleanStringConverter

BooleanUtils - Class in com.alibaba.excel.util

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

BoolErrRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

BoolErrRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.BoolErrRecordHandler

BorderStyleEnum - Enum in com.alibaba.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 com.alibaba.excel.analysis.v03.handlers

Record handler

BoundSheetRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.BoundSheetRecordHandler

BoxingByteArrayImageConverter - Class in com.alibaba.excel.converters.bytearray

Boxing Byte array and image converter

BoxingByteArrayImageConverter() - Constructor for class com.alibaba.excel.converters.bytearray.BoxingByteArrayImageConverter

build(ColumnWidth) - Static method in class com.alibaba.excel.metadata.property.ColumnWidthProperty

build(DateTimeFormat) - Static method in class com.alibaba.excel.metadata.property.DateTimeFormatProperty

build(HeadFontStyle) - Static method in class com.alibaba.excel.metadata.property.FontProperty

build(ContentFontStyle) - Static method in class com.alibaba.excel.metadata.property.FontProperty

build(ContentLoopMerge) - Static method in class com.alibaba.excel.metadata.property.LoopMergeProperty

build(NumberFormat) - Static method in class com.alibaba.excel.metadata.property.NumberFormatProperty

build(OnceAbsoluteMerge) - Static method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

build(HeadRowHeight) - Static method in class com.alibaba.excel.metadata.property.RowHeightProperty

build(ContentRowHeight) - Static method in class com.alibaba.excel.metadata.property.RowHeightProperty

build(HeadStyle) - Static method in class com.alibaba.excel.metadata.property.StyleProperty

build(ContentStyle) - Static method in class com.alibaba.excel.metadata.property.StyleProperty

build() - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

build() - Method in class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

build() - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

build() - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

build() - Method in class com.alibaba.excel.write.builder.ExcelWriterTableBuilder

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

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

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

Build cell style

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

buildDataFormat(Workbook, DataFormatData) - Static method in class com.alibaba.excel.util.StyleUtil

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

buildFromCellType(String) - Static method in enum com.alibaba.excel.enums.CellDataTypeEnum

Build data types

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

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

buildRichTextString(WriteWorkbookHolder, RichTextStringData) - Static method in class com.alibaba.excel.util.StyleUtil

BUILTIN_FORMATS_CN - Static variable in class com.alibaba.excel.constant.BuiltinFormats

BUILTIN_FORMATS_MAP_CN - Static variable in class com.alibaba.excel.constant.BuiltinFormats

BUILTIN_FORMATS_MAP_US - Static variable in class com.alibaba.excel.constant.BuiltinFormats

BUILTIN_FORMATS_US - Static variable in class com.alibaba.excel.constant.BuiltinFormats

BuiltinFormats - Class in com.alibaba.excel.constant

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

BuiltinFormats() - Constructor for class com.alibaba.excel.constant.BuiltinFormats

byId(int) - Static method in enum com.alibaba.excel.metadata.data.ClientAnchorData.AnchorType

return the AnchorType corresponding to the code

ByteArrayImageConverter - Class in com.alibaba.excel.converters.bytearray

Byte array and image converter

ByteArrayImageConverter() - Constructor for class com.alibaba.excel.converters.bytearray.ByteArrayImageConverter

ByteBooleanConverter - Class in com.alibaba.excel.converters.byteconverter

Byte and boolean converter

ByteBooleanConverter() - Constructor for class com.alibaba.excel.converters.byteconverter.ByteBooleanConverter

ByteNumberConverter - Class in com.alibaba.excel.converters.byteconverter

Byte and number converter

ByteNumberConverter() - Constructor for class com.alibaba.excel.converters.byteconverter.ByteNumberConverter

ByteStringConverter - Class in com.alibaba.excel.converters.byteconverter

Byte and string converter

ByteStringConverter() - Constructor for class com.alibaba.excel.converters.byteconverter.ByteStringConverter

C

Cell - Interface in com.alibaba.excel.metadata

Cell

CELL_FORMULA_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

CELL_INLINE_STRING_VALUE_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

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

CELL_RANGE_SPLIT - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

Cell range split

CELL_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

CELL_VALUE_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

CellData<T> - Class in com.alibaba.excel.metadata.data

Excel internal cell data.

CellData() - Constructor for class com.alibaba.excel.metadata.data.CellData

CellDataTypeEnum - Enum in com.alibaba.excel.enums

excel internal data type

CellExtra - Class in com.alibaba.excel.metadata

Cell extra information.

CellExtra(CellExtraTypeEnum, String, String) - Constructor for class com.alibaba.excel.metadata.CellExtra

CellExtra(CellExtraTypeEnum, String, Integer, Integer) - Constructor for class com.alibaba.excel.metadata.CellExtra

CellExtra(CellExtraTypeEnum, String, Integer, Integer, Integer, Integer) - Constructor for class com.alibaba.excel.metadata.CellExtra

CellExtraTypeEnum - Enum in com.alibaba.excel.enums

Extra data type

CellFormulaTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Handler

CellFormulaTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.CellFormulaTagHandler

CellHandlerExecutionChain - Class in com.alibaba.excel.write.handler.chain

Execute the cell handler chain

CellHandlerExecutionChain(CellWriteHandler) - Constructor for class com.alibaba.excel.write.handler.chain.CellHandlerExecutionChain

cellHandlerExecutionChain - Variable in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

Execute the cell handler chain

CellInlineStringValueTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell inline string value handler

CellInlineStringValueTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.CellInlineStringValueTagHandler

cellIterator() - Method in class com.alibaba.excel.metadata.csv.CsvRow

CellRange - Class in com.alibaba.excel.metadata

CellRange(int, int, int, int) - Constructor for class com.alibaba.excel.metadata.CellRange

CellTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Handler

CellTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.CellTagHandler

CellValueTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Value Handler

CellValueTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.CellValueTagHandler

CellWriteHandler - Interface in com.alibaba.excel.write.handler

intercepts handle cell creation

CellWriteHandlerContext - Class in com.alibaba.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 com.alibaba.excel.write.handler.context.CellWriteHandlerContext

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

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

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

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

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

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

Read data

charset(Charset) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

charset.

charset(Charset) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

charset.

checkEmpty() - Method in class com.alibaba.excel.metadata.data.CellData

Ensure that the object does not appear null

checkNotNull(T) - Static method in class com.alibaba.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 com.alibaba.excel.util.ClassUtils

The cache configuration information for each of the class

ClassUtils - Class in com.alibaba.excel.util

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

ClassUtils() - Constructor for class com.alibaba.excel.util.ClassUtils

ClassUtils.ContentPropertyKey - Class in com.alibaba.excel.util

clearFormatting() - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

ClientAnchorData - Class in com.alibaba.excel.metadata.data

A client anchor is attached to an excel worksheet.

ClientAnchorData() - Constructor for class com.alibaba.excel.metadata.data.ClientAnchorData

ClientAnchorData.AnchorType - Enum in com.alibaba.excel.metadata.data

clone() - Method in class com.alibaba.excel.metadata.data.DataFormatData

clone() - Method in class com.alibaba.excel.metadata.data.FormulaData

clone() - Method in class com.alibaba.excel.metadata.data.ReadCellData

cloneSheet(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

cloneStyleFrom(CellStyle) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

close() - Method in class com.alibaba.excel.ExcelReader

close() - Method in class com.alibaba.excel.ExcelWriter

close() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

close() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

CollectionRowData - Class in com.alibaba.excel.write.metadata

A collection row of data.

CollectionRowData(Collection<?>) - Constructor for class com.alibaba.excel.write.metadata.CollectionRowData

ColumnWidth - Annotation Type in com.alibaba.excel.annotation.write.style

Set the width of the table

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

Returns the column width corresponding to each column head.

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

ColumnWidthProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

ColumnWidthProperty(Integer) - Constructor for class com.alibaba.excel.metadata.property.ColumnWidthProperty

com.alibaba.excel - package com.alibaba.excel

com.alibaba.excel.analysis - package com.alibaba.excel.analysis

com.alibaba.excel.analysis.csv - package com.alibaba.excel.analysis.csv

com.alibaba.excel.analysis.v03 - package com.alibaba.excel.analysis.v03

com.alibaba.excel.analysis.v03.handlers - package com.alibaba.excel.analysis.v03.handlers

com.alibaba.excel.analysis.v07 - package com.alibaba.excel.analysis.v07

com.alibaba.excel.analysis.v07.handlers - package com.alibaba.excel.analysis.v07.handlers

com.alibaba.excel.analysis.v07.handlers.sax - package com.alibaba.excel.analysis.v07.handlers.sax

com.alibaba.excel.annotation - package com.alibaba.excel.annotation

com.alibaba.excel.annotation.format - package com.alibaba.excel.annotation.format

com.alibaba.excel.annotation.write.style - package com.alibaba.excel.annotation.write.style

com.alibaba.excel.cache - package com.alibaba.excel.cache

com.alibaba.excel.cache.selector - package com.alibaba.excel.cache.selector

com.alibaba.excel.constant - package com.alibaba.excel.constant

com.alibaba.excel.context - package com.alibaba.excel.context

com.alibaba.excel.context.csv - package com.alibaba.excel.context.csv

com.alibaba.excel.context.xls - package com.alibaba.excel.context.xls

com.alibaba.excel.context.xlsx - package com.alibaba.excel.context.xlsx

com.alibaba.excel.converters - package com.alibaba.excel.converters

com.alibaba.excel.converters.bigdecimal - package com.alibaba.excel.converters.bigdecimal

com.alibaba.excel.converters.biginteger - package com.alibaba.excel.converters.biginteger

com.alibaba.excel.converters.booleanconverter - package com.alibaba.excel.converters.booleanconverter

com.alibaba.excel.converters.bytearray - package com.alibaba.excel.converters.bytearray

com.alibaba.excel.converters.byteconverter - package com.alibaba.excel.converters.byteconverter

com.alibaba.excel.converters.date - package com.alibaba.excel.converters.date

com.alibaba.excel.converters.doubleconverter - package com.alibaba.excel.converters.doubleconverter

com.alibaba.excel.converters.file - package com.alibaba.excel.converters.file

com.alibaba.excel.converters.floatconverter - package com.alibaba.excel.converters.floatconverter

com.alibaba.excel.converters.inputstream - package com.alibaba.excel.converters.inputstream

com.alibaba.excel.converters.integer - package com.alibaba.excel.converters.integer

com.alibaba.excel.converters.localdatetime - package com.alibaba.excel.converters.localdatetime

com.alibaba.excel.converters.longconverter - package com.alibaba.excel.converters.longconverter

com.alibaba.excel.converters.shortconverter - package com.alibaba.excel.converters.shortconverter

com.alibaba.excel.converters.string - package com.alibaba.excel.converters.string

com.alibaba.excel.converters.url - package com.alibaba.excel.converters.url

com.alibaba.excel.enums - package com.alibaba.excel.enums

com.alibaba.excel.enums.poi - package com.alibaba.excel.enums.poi

com.alibaba.excel.event - package com.alibaba.excel.event

com.alibaba.excel.exception - package com.alibaba.excel.exception

com.alibaba.excel.metadata - package com.alibaba.excel.metadata

com.alibaba.excel.metadata.csv - package com.alibaba.excel.metadata.csv

com.alibaba.excel.metadata.data - package com.alibaba.excel.metadata.data

com.alibaba.excel.metadata.format - package com.alibaba.excel.metadata.format

com.alibaba.excel.metadata.property - package com.alibaba.excel.metadata.property

com.alibaba.excel.read.builder - package com.alibaba.excel.read.builder

com.alibaba.excel.read.listener - package com.alibaba.excel.read.listener

com.alibaba.excel.read.metadata - package com.alibaba.excel.read.metadata

com.alibaba.excel.read.metadata.holder - package com.alibaba.excel.read.metadata.holder

com.alibaba.excel.read.metadata.holder.csv - package com.alibaba.excel.read.metadata.holder.csv

com.alibaba.excel.read.metadata.holder.xls - package com.alibaba.excel.read.metadata.holder.xls

com.alibaba.excel.read.metadata.holder.xlsx - package com.alibaba.excel.read.metadata.holder.xlsx

com.alibaba.excel.read.metadata.property - package com.alibaba.excel.read.metadata.property

com.alibaba.excel.read.processor - package com.alibaba.excel.read.processor

com.alibaba.excel.support - package com.alibaba.excel.support

com.alibaba.excel.util - package com.alibaba.excel.util

com.alibaba.excel.write - package com.alibaba.excel.write

com.alibaba.excel.write.builder - package com.alibaba.excel.write.builder

com.alibaba.excel.write.executor - package com.alibaba.excel.write.executor

com.alibaba.excel.write.handler - package com.alibaba.excel.write.handler

com.alibaba.excel.write.handler.chain - package com.alibaba.excel.write.handler.chain

com.alibaba.excel.write.handler.context - package com.alibaba.excel.write.handler.context

com.alibaba.excel.write.handler.impl - package com.alibaba.excel.write.handler.impl

com.alibaba.excel.write.merge - package com.alibaba.excel.write.merge

com.alibaba.excel.write.metadata - package com.alibaba.excel.write.metadata

com.alibaba.excel.write.metadata.fill - package com.alibaba.excel.write.metadata.fill

com.alibaba.excel.write.metadata.holder - package com.alibaba.excel.write.metadata.holder

com.alibaba.excel.write.metadata.style - package com.alibaba.excel.write.metadata.style

com.alibaba.excel.write.property - package com.alibaba.excel.write.property

com.alibaba.excel.write.style - package com.alibaba.excel.write.style

com.alibaba.excel.write.style.column - package com.alibaba.excel.write.style.column

com.alibaba.excel.write.style.row - package com.alibaba.excel.write.style.row

combineExcelContentProperty(ExcelContentProperty, ExcelContentProperty) - Static method in class com.alibaba.excel.util.ClassUtils

CommentData - Class in com.alibaba.excel.metadata.data

comment

CommentData() - Constructor for class com.alibaba.excel.metadata.data.CommentData

ConfigurationHolder - Interface in com.alibaba.excel.metadata

Get the corresponding holder

CONTENT_CACHE - Static variable in class com.alibaba.excel.util.ClassUtils

The cache configuration information for each of the class

contentCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head.

contentCellStyle(Head) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head

ContentFontStyle - Annotation Type in com.alibaba.excel.annotation.write.style

Custom content styles.

ContentLoopMerge - Annotation Type in com.alibaba.excel.annotation.write.style

The regions of the loop merge

ContentPropertyKey() - Constructor for class com.alibaba.excel.util.ClassUtils.ContentPropertyKey

ContentRowHeight - Annotation Type in com.alibaba.excel.annotation.write.style

Set the height of each table

ContentStyle - Annotation Type in com.alibaba.excel.annotation.write.style

Custom content styles

convert(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.executor.AbstractExcelWriteExecutor

Converter<T> - Interface in com.alibaba.excel.converters

Convert between Java objects and excel objects

converterAndSet(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.executor.AbstractExcelWriteExecutor

Transform the data and then to set into the cell

ConverterKey() - Constructor for class com.alibaba.excel.converters.ConverterKeyBuild.ConverterKey

ConverterKeyBuild - Class in com.alibaba.excel.converters

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

ConverterKeyBuild() - Constructor for class com.alibaba.excel.converters.ConverterKeyBuild

ConverterKeyBuild.ConverterKey - Class in com.alibaba.excel.converters

converterMap() - Method in class com.alibaba.excel.metadata.AbstractHolder

converterMap() - Method in interface com.alibaba.excel.metadata.ConfigurationHolder

What converter does the currently operated cell need to execute

ConverterUtils - Class in com.alibaba.excel.util

Converting objects

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

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

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

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

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

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

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

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

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

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

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

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

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

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

convertToExcelData(T, ExcelContentProperty, GlobalConfiguration) - Method in interface com.alibaba.excel.converters.Converter

Convert Java objects to excel objects

convertToExcelData(WriteConverterContext<T>) - Method in interface com.alibaba.excel.converters.Converter

Convert Java objects to excel objects

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

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

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

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

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

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

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

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

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

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

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

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

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

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

convertToExcelData(LocalDateTime, ExcelContentProperty, GlobalConfiguration) - Method in class com.alibaba.excel.converters.localdatetime.LocalDateNumberConverter

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Convert excel objects to Java objects

convertToJavaData(ReadConverterContext<?>) - Method in interface com.alibaba.excel.converters.Converter

Convert excel objects to Java objects

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

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

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

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

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

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

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

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

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

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

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

convertToJavaData(ReadCellData<?>, ExcelContentProperty, GlobalConfiguration) - Method in class com.alibaba.excel.converters.localdatetime.LocalDateNumberConverter

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

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

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

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

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

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

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

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

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

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

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

convertToJavaObject(ReadCellData<?>, Field, ExcelContentProperty, Map<ConverterKeyBuild.ConverterKey, Converter<?>>, AnalysisContext, Integer, Integer) - Static method in class com.alibaba.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 com.alibaba.excel.util.ConverterUtils

Convert it into a Java object

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

Convert it into a String map

CoordinateData - Class in com.alibaba.excel.metadata.data

coordinate.

CoordinateData() - Constructor for class com.alibaba.excel.metadata.data.CoordinateData

copy(InputStream, OutputStream) - Static method in class com.alibaba.excel.util.IoUtils

Copies bytes

copyBasicParameter(ReadSheet) - Method in class com.alibaba.excel.read.metadata.ReadSheet

CountTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Handler

CountTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.CountTagHandler

create(Object) - Static method in class com.alibaba.excel.util.BeanMapUtils

Helper method to create a new BeanMap.

createCacheTmpFile() - Static method in class com.alibaba.excel.util.FileUtils

createCell(int) - Method in class com.alibaba.excel.metadata.csv.CsvRow

createCell(int, CellType) - Method in class com.alibaba.excel.metadata.csv.CsvRow

createCell(Row, int) - Static method in class com.alibaba.excel.util.WorkBookUtil

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

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

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

createCellStyle() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

createCellStyle(WriteCellStyle, CellStyle) - Method in class com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder

create a cell style.

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

createDataFormat() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

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

create a data format.

createDrawingPatriarch() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

createFont() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

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

create a font.

createFreezePane(int, int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

createFreezePane(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

createName() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

createPoiFilesDirectory() - Static method in class com.alibaba.excel.util.FileUtils

createRow(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

createRow(Sheet, int) - Static method in class com.alibaba.excel.util.WorkBookUtil

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

createSheet() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

createSheet(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

createSheet(Workbook, String) - Static method in class com.alibaba.excel.util.WorkBookUtil

createSheetWriteHandlerContext(WriteContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

createSplitPane(int, int, int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

createTmpFile(String) - Static method in class com.alibaba.excel.util.FileUtils

createWorkBook(WriteWorkbookHolder) - Static method in class com.alibaba.excel.util.WorkBookUtil

createWorkbookWriteHandlerContext(WriteContext) - Static method in class com.alibaba.excel.util.WriteHandlerUtils

CsvCell - Class in com.alibaba.excel.metadata.csv

csv cell

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

CsvCellStyle - Class in com.alibaba.excel.metadata.csv

csv cell style

CsvCellStyle(Short) - Constructor for class com.alibaba.excel.metadata.csv.CsvCellStyle

CsvDataFormat - Class in com.alibaba.excel.metadata.csv

format data

CsvDataFormat(Locale) - Constructor for class com.alibaba.excel.metadata.csv.CsvDataFormat

CsvExcelReadExecutor - Class in com.alibaba.excel.analysis.csv

read executor

CsvExcelReadExecutor(CsvReadContext) - Constructor for class com.alibaba.excel.analysis.csv.CsvExcelReadExecutor

csvFormat - Variable in class com.alibaba.excel.metadata.csv.CsvSheet

format

CsvReadContext - Interface in com.alibaba.excel.context.csv

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

csvReadSheetHolder() - Method in interface com.alibaba.excel.context.csv.CsvReadContext

All information about the sheet you are currently working on.

csvReadSheetHolder() - Method in class com.alibaba.excel.context.csv.DefaultCsvReadContext

CsvReadSheetHolder - Class in com.alibaba.excel.read.metadata.holder.csv

sheet holder

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

csvReadWorkbookHolder() - Method in interface com.alibaba.excel.context.csv.CsvReadContext

All information about the workbook you are currently working on.

csvReadWorkbookHolder() - Method in class com.alibaba.excel.context.csv.DefaultCsvReadContext

CsvReadWorkbookHolder - Class in com.alibaba.excel.read.metadata.holder.csv

Workbook holder

CsvReadWorkbookHolder(ReadWorkbook) - Constructor for class com.alibaba.excel.read.metadata.holder.csv.CsvReadWorkbookHolder

CsvRichTextString - Class in com.alibaba.excel.metadata.csv

rich text string

CsvRichTextString(String) - Constructor for class com.alibaba.excel.metadata.csv.CsvRichTextString

CsvRow - Class in com.alibaba.excel.metadata.csv

csv row

CsvRow(CsvWorkbook, CsvSheet, Integer) - Constructor for class com.alibaba.excel.metadata.csv.CsvRow

CsvSheet - Class in com.alibaba.excel.metadata.csv

csv sheet

CsvSheet(CsvWorkbook, Appendable) - Constructor for class com.alibaba.excel.metadata.csv.CsvSheet

CsvWorkbook - Class in com.alibaba.excel.metadata.csv

csv workbook

CsvWorkbook(Appendable, Locale, Boolean, Boolean) - Constructor for class com.alibaba.excel.metadata.csv.CsvWorkbook

currentReadHolder() - Method in interface com.alibaba.excel.context.AnalysisContext

The current read operation corresponds to the readSheetHolder or readWorkbookHolder

currentReadHolder() - Method in class com.alibaba.excel.context.AnalysisContextImpl

currentSheet(ReadSheet) - Method in interface com.alibaba.excel.context.AnalysisContext

Select the current table

currentSheet(ReadSheet) - Method in class com.alibaba.excel.context.AnalysisContextImpl

currentSheet(WriteSheet, WriteTypeEnum) - Method in interface com.alibaba.excel.context.WriteContext

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

currentSheet(WriteSheet, WriteTypeEnum) - Method in class com.alibaba.excel.context.WriteContextImpl

currentTable(WriteTable) - Method in interface com.alibaba.excel.context.WriteContext

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

currentTable(WriteTable) - Method in class com.alibaba.excel.context.WriteContextImpl

currentWriteHolder() - Method in interface com.alibaba.excel.context.WriteContext

Configuration of currently operated cell.

currentWriteHolder() - Method in class com.alibaba.excel.context.WriteContextImpl

CUSTOM_HEIGHT - Static variable in class org.apache.poi.hssf.usermodel.PoiUtils

Whether to customize the height

customHeight(Row) - Static method in class org.apache.poi.hssf.usermodel.PoiUtils

Whether to customize the height

customObject(Object) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

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

D

DataFormatData - Class in com.alibaba.excel.metadata.data

data format

DataFormatData() - Constructor for class com.alibaba.excel.metadata.data.DataFormatData

dataFormatData(int) - Method in class com.alibaba.excel.read.metadata.holder.xlsx.XlsxReadWorkbookHolder

DataFormatter - Class in com.alibaba.excel.metadata.format

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

DataFormatter(Boolean, Locale, Boolean) - Constructor for class com.alibaba.excel.metadata.format.DataFormatter

Creates a formatter using the given locale.

DATE_FORMAT_10 - Static variable in class com.alibaba.excel.util.DateUtils

DATE_FORMAT_14 - Static variable in class com.alibaba.excel.util.DateUtils

DATE_FORMAT_16 - Static variable in class com.alibaba.excel.util.DateUtils

DATE_FORMAT_16_FORWARD_SLASH - Static variable in class com.alibaba.excel.util.DateUtils

DATE_FORMAT_17 - Static variable in class com.alibaba.excel.util.DateUtils

DATE_FORMAT_19 - Static variable in class com.alibaba.excel.util.DateUtils

DATE_FORMAT_19_FORWARD_SLASH - Static variable in class com.alibaba.excel.util.DateUtils

DateDateConverter - Class in com.alibaba.excel.converters.date

Date and date converter

DateDateConverter() - Constructor for class com.alibaba.excel.converters.date.DateDateConverter

DateNumberConverter - Class in com.alibaba.excel.converters.date

Date and number converter

DateNumberConverter() - Constructor for class com.alibaba.excel.converters.date.DateNumberConverter

DateStringConverter - Class in com.alibaba.excel.converters.date

Date and string converter

DateStringConverter() - Constructor for class com.alibaba.excel.converters.date.DateStringConverter

DateTimeFormat - Annotation Type in com.alibaba.excel.annotation.format

Convert date format.

DateTimeFormatProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

DateTimeFormatProperty(String, Boolean) - Constructor for class com.alibaba.excel.metadata.property.DateTimeFormatProperty

DateUtils - Class in com.alibaba.excel.util

Date utils

DEBUG_CACHE_MISS_SIZE - Static variable in class com.alibaba.excel.cache.Ehcache

DEBUG_WRITE_SIZE - Static variable in class com.alibaba.excel.cache.Ehcache

declaredExcelContentProperty(Map<?, ?>, Class<?>, String) - Static method in class com.alibaba.excel.util.ClassUtils

Calculate the configuration information for the class

declaredFields(Class<?>, Map<Integer, Field>, Map<Integer, Field>, Map<String, Field>, Boolean, Holder) - Static method in class com.alibaba.excel.util.ClassUtils

Parsing field in the class

declaredFields(Class<?>, Map<Integer, Field>, Boolean, WriteHolder) - Static method in class com.alibaba.excel.util.ClassUtils

DEFAULT_DEFINE_STYLE - Static variable in class com.alibaba.excel.constant.OrderConstant

The system's own style

DEFAULT_ORDER - Static variable in class com.alibaba.excel.constant.OrderConstant

default order.

DEFAULT_WRITE_HANDLER_LIST - Static variable in class com.alibaba.excel.write.handler.DefaultWriteHandlerLoader

DefaultAnalysisEventProcessor - Class in com.alibaba.excel.read.processor

Analysis event

DefaultAnalysisEventProcessor() - Constructor for class com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor

defaultClassGeneric - Static variable in class com.alibaba.excel.util.ConverterUtils

DefaultConverterLoader - Class in com.alibaba.excel.converters

Load default handler

DefaultConverterLoader() - Constructor for class com.alibaba.excel.converters.DefaultConverterLoader

DefaultCsvReadContext - Class in com.alibaba.excel.context.csv

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

DefaultCsvReadContext(ReadWorkbook, ExcelTypeEnum) - Constructor for class com.alibaba.excel.context.csv.DefaultCsvReadContext

defaultDateFormat - Static variable in class com.alibaba.excel.util.DateUtils

defaultImageType - Static variable in class com.alibaba.excel.util.FileTypeUtils

Default image type

DefaultRowWriteHandler - Class in com.alibaba.excel.write.handler.impl

Default row handler.

DefaultRowWriteHandler() - Constructor for class com.alibaba.excel.write.handler.impl.DefaultRowWriteHandler

DefaultStyle - Class in com.alibaba.excel.write.style

The default styles

DefaultStyle() - Constructor for class com.alibaba.excel.write.style.DefaultStyle

DefaultWriteHandlerLoader - Class in com.alibaba.excel.write.handler

Load default handler

DefaultWriteHandlerLoader() - Constructor for class com.alibaba.excel.write.handler.DefaultWriteHandlerLoader

DefaultXlsReadContext - Class in com.alibaba.excel.context.xls

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

DefaultXlsReadContext(ReadWorkbook, ExcelTypeEnum) - Constructor for class com.alibaba.excel.context.xls.DefaultXlsReadContext

DefaultXlsxReadContext - Class in com.alibaba.excel.context.xlsx

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

DefaultXlsxReadContext(ReadWorkbook, ExcelTypeEnum) - Constructor for class com.alibaba.excel.context.xlsx.DefaultXlsxReadContext

DEFINE_STYLE - Static variable in class com.alibaba.excel.constant.OrderConstant

Define style.

delete(File) - Static method in class com.alibaba.excel.util.FileUtils

delete file

destroy() - Method in class com.alibaba.excel.cache.Ehcache

destroy() - Method in class com.alibaba.excel.cache.MapCache

destroy() - Method in interface com.alibaba.excel.cache.ReadCache

Called when the excel read is complete

destroy() - Method in class com.alibaba.excel.cache.XlsCache

DIMENSION_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

DimensionWorkbookWriteHandler - Class in com.alibaba.excel.write.handler.impl

Handle the problem of unable to write dimension.

DimensionWorkbookWriteHandler() - Constructor for class com.alibaba.excel.write.handler.impl.DimensionWorkbookWriteHandler

doAfterAllAnalysed(AnalysisContext) - Method in class com.alibaba.excel.event.SyncReadListener

doAfterAllAnalysed(AnalysisContext) - Method in class com.alibaba.excel.read.listener.ModelBuildEventListener

doAfterAllAnalysed(AnalysisContext) - Method in class com.alibaba.excel.read.listener.PageReadListener

doAfterAllAnalysed(AnalysisContext) - Method in interface com.alibaba.excel.read.listener.ReadListener

if have something to do after all analysis

doFill(Object) - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

doFill(Object, FillConfig) - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

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

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

doRead() - Method in class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

Sax read

doReadAll() - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

doReadAllSync() - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Synchronous reads return results

doReadSync() - Method in class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

Synchronous reads return results

DoubleBooleanConverter - Class in com.alibaba.excel.converters.doubleconverter

Double and boolean converter

DoubleBooleanConverter() - Constructor for class com.alibaba.excel.converters.doubleconverter.DoubleBooleanConverter

DoubleNumberConverter - Class in com.alibaba.excel.converters.doubleconverter

Double and number converter

DoubleNumberConverter() - Constructor for class com.alibaba.excel.converters.doubleconverter.DoubleNumberConverter

DoubleStringConverter - Class in com.alibaba.excel.converters.doubleconverter

Double and string converter

DoubleStringConverter() - Constructor for class com.alibaba.excel.converters.doubleconverter.DoubleStringConverter

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

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

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

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

DummyRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

DummyRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.DummyRecordHandler

E

EasyExcel - Class in com.alibaba.excel

This is actually EasyExcelFactory, and short names look better.

EasyExcel() - Constructor for class com.alibaba.excel.EasyExcel

EasyExcelConstants - Class in com.alibaba.excel.constant

Used to store constant

EasyExcelConstants() - Constructor for class com.alibaba.excel.constant.EasyExcelConstants

EasyExcelFactory - Class in com.alibaba.excel

Reader and writer factory class

EasyExcelFactory() - Constructor for class com.alibaba.excel.EasyExcelFactory

EasyExcelNamingPolicy() - Constructor for class com.alibaba.excel.util.BeanMapUtils.EasyExcelNamingPolicy

Ehcache - Class in com.alibaba.excel.cache

Default cache

Ehcache(int) - Constructor for class com.alibaba.excel.cache.Ehcache

EMPTY - Static variable in class com.alibaba.excel.metadata.property.ExcelContentProperty

EMPTY - Static variable in class com.alibaba.excel.util.StringUtils

The empty String "".

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

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

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

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

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

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

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

End handle

endRow(AnalysisContext) - Method in interface com.alibaba.excel.read.processor.AnalysisEventProcessor

End row

endRow(AnalysisContext) - Method in class com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor

endSheet(AnalysisContext) - Method in interface com.alibaba.excel.read.processor.AnalysisEventProcessor

Notify after all analysed

endSheet(AnalysisContext) - Method in class com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor

EOF - Static variable in class com.alibaba.excel.util.IoUtils

EofRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

EofRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.EofRecordHandler

equals(CharSequence, CharSequence) - Static method in class com.alibaba.excel.util.StringUtils

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

equals(Object) - Method in class com.alibaba.excel.write.metadata.fill.AnalysisCell

EternalReadCacheSelector - Class in com.alibaba.excel.cache.selector

Choose a eternal cache

EternalReadCacheSelector(ReadCache) - Constructor for class com.alibaba.excel.cache.selector.EternalReadCacheSelector

EX_CACHE - Static variable in class com.alibaba.excel.util.FileUtils

EXCEL_MATH_CONTEXT - Static variable in class com.alibaba.excel.constant.EasyExcelConstants

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 com.alibaba.excel.analysis

Excel file analyser

ExcelAnalyserImpl - Class in com.alibaba.excel.analysis

ExcelAnalyserImpl(ReadWorkbook) - Constructor for class com.alibaba.excel.analysis.ExcelAnalyserImpl

ExcelAnalysisException - Exception in com.alibaba.excel.exception

ExcelAnalysisException() - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisException

ExcelAnalysisException(String) - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisException

ExcelAnalysisException(String, Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisException

ExcelAnalysisException(Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisException

ExcelAnalysisStopException - Exception in com.alibaba.excel.exception

Throw the exception when you need to stop

ExcelAnalysisStopException() - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopException(String) - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopException(String, Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisStopException

ExcelAnalysisStopException(Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelAnalysisStopException

ExcelBuilder - Interface in com.alibaba.excel.write

ExcelBuilderImpl - Class in com.alibaba.excel.write

ExcelBuilderImpl(WriteWorkbook) - Constructor for class com.alibaba.excel.write.ExcelBuilderImpl

ExcelCommonException - Exception in com.alibaba.excel.exception

ExcelCommonException() - Constructor for exception com.alibaba.excel.exception.ExcelCommonException

ExcelCommonException(String) - Constructor for exception com.alibaba.excel.exception.ExcelCommonException

ExcelCommonException(String, Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelCommonException

ExcelCommonException(Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelCommonException

ExcelContentProperty - Class in com.alibaba.excel.metadata.property

ExcelContentProperty() - Constructor for class com.alibaba.excel.metadata.property.ExcelContentProperty

ExcelDataConvertException - Exception in com.alibaba.excel.exception

Data convert exception

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

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

excelExecutor() - Method in interface com.alibaba.excel.analysis.ExcelAnalyser

Acquisition excel executor

excelExecutor() - Method in class com.alibaba.excel.analysis.ExcelAnalyserImpl

excelExecutor() - Method in class com.alibaba.excel.ExcelReader

Current executor

ExcelGeneralNumberFormat - Class in com.alibaba.excel.metadata.format

Written with reference to ExcelGeneralNumberFormat.

ExcelGeneralNumberFormat(Locale, boolean) - Constructor for class com.alibaba.excel.metadata.format.ExcelGeneralNumberFormat

ExcelGenerateException - Exception in com.alibaba.excel.exception

ExcelGenerateException(String) - Constructor for exception com.alibaba.excel.exception.ExcelGenerateException

ExcelGenerateException(String, Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelGenerateException

ExcelGenerateException(Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelGenerateException

ExcelHeadProperty - Class in com.alibaba.excel.metadata.property

Define the header attribute of excel

ExcelHeadProperty(Holder, Class<?>, List<List<String>>) - Constructor for class com.alibaba.excel.metadata.property.ExcelHeadProperty

ExcelIgnore - Annotation Type in com.alibaba.excel.annotation

Ignore convert excel

ExcelIgnoreUnannotated - Annotation Type in com.alibaba.excel.annotation

Ignore all unannotated fields.

ExcelProperty - Annotation Type in com.alibaba.excel.annotation

ExcelReader - Class in com.alibaba.excel

Excel readers are all read in event mode.

ExcelReader(ReadWorkbook) - Constructor for class com.alibaba.excel.ExcelReader

ExcelReaderBuilder - Class in com.alibaba.excel.read.builder

Build ExcelWriter

ExcelReaderBuilder() - Constructor for class com.alibaba.excel.read.builder.ExcelReaderBuilder

ExcelReaderSheetBuilder - Class in com.alibaba.excel.read.builder

Build sheet

ExcelReaderSheetBuilder() - Constructor for class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

ExcelReaderSheetBuilder(ExcelReader) - Constructor for class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

ExcelReadExecutor - Interface in com.alibaba.excel.analysis

Excel file Executor

excelReadHeadProperty() - Method in class com.alibaba.excel.read.metadata.holder.AbstractReadHolder

excelReadHeadProperty() - Method in interface com.alibaba.excel.read.metadata.holder.ReadHolder

What ExcelReadHeadProperty does the currently operated cell need to execute

ExcelReadHeadProperty - Class in com.alibaba.excel.read.metadata.property

Define the header attribute of excel

ExcelReadHeadProperty(Holder, Class, List<List<String>>) - Constructor for class com.alibaba.excel.read.metadata.property.ExcelReadHeadProperty

ExcelRuntimeException - Exception in com.alibaba.excel.exception

Excel Exception

ExcelRuntimeException() - Constructor for exception com.alibaba.excel.exception.ExcelRuntimeException

ExcelRuntimeException(String) - Constructor for exception com.alibaba.excel.exception.ExcelRuntimeException

ExcelRuntimeException(String, Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelRuntimeException

ExcelRuntimeException(Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelRuntimeException

excelType(ExcelTypeEnum) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

excelType(ExcelTypeEnum) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

ExcelTypeEnum - Enum in com.alibaba.excel.support

ExcelWriteAddExecutor - Class in com.alibaba.excel.write.executor

Add the data into excel

ExcelWriteAddExecutor(WriteContext) - Constructor for class com.alibaba.excel.write.executor.ExcelWriteAddExecutor

ExcelWriteDataConvertException - Exception in com.alibaba.excel.exception

Data convert exception

ExcelWriteDataConvertException(CellWriteHandlerContext, String) - Constructor for exception com.alibaba.excel.exception.ExcelWriteDataConvertException

ExcelWriteDataConvertException(CellWriteHandlerContext, String, Throwable) - Constructor for exception com.alibaba.excel.exception.ExcelWriteDataConvertException

ExcelWriteExecutor - Interface in com.alibaba.excel.write.executor

Excel write Executor

ExcelWriteFillExecutor - Class in com.alibaba.excel.write.executor

Fill the data into excel

ExcelWriteFillExecutor(WriteContext) - Constructor for class com.alibaba.excel.write.executor.ExcelWriteFillExecutor

ExcelWriteFillExecutor.UniqueDataFlagKey - Class in com.alibaba.excel.write.executor

excelWriteHeadProperty() - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

excelWriteHeadProperty() - Method in interface com.alibaba.excel.write.metadata.holder.WriteHolder

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

ExcelWriteHeadProperty - Class in com.alibaba.excel.write.property

Define the header attribute of excel

ExcelWriteHeadProperty(Holder, Class<?>, List<List<String>>) - Constructor for class com.alibaba.excel.write.property.ExcelWriteHeadProperty

ExcelWriter - Class in com.alibaba.excel

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

ExcelWriter(WriteWorkbook) - Constructor for class com.alibaba.excel.ExcelWriter

Create new writer

ExcelWriterBuilder - Class in com.alibaba.excel.write.builder

Build ExcelBuilder

ExcelWriterBuilder() - Constructor for class com.alibaba.excel.write.builder.ExcelWriterBuilder

ExcelWriterSheetBuilder - Class in com.alibaba.excel.write.builder

Build sheet

ExcelWriterSheetBuilder() - Constructor for class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

ExcelWriterSheetBuilder(ExcelWriter) - Constructor for class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

ExcelWriterTableBuilder - Class in com.alibaba.excel.write.builder

Build sheet

ExcelWriterTableBuilder() - Constructor for class com.alibaba.excel.write.builder.ExcelWriterTableBuilder

ExcelWriterTableBuilder(ExcelWriter, WriteSheet) - Constructor for class com.alibaba.excel.write.builder.ExcelWriterTableBuilder

ExcelXmlConstants - Class in com.alibaba.excel.constant

ExcelXmlConstants() - Constructor for class com.alibaba.excel.constant.ExcelXmlConstants

excludeColumnFieldNames(Collection<String>) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Ignore the custom columns.

excludeColumnFiledNames(Collection<String>) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Deprecated.

use AbstractExcelWriterParameterBuilder.excludeColumnFieldNames(Collection)

excludeColumnIndexes(Collection<Integer>) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Ignore the custom columns.

execute() - Method in class com.alibaba.excel.analysis.csv.CsvExcelReadExecutor

execute() - Method in interface com.alibaba.excel.analysis.ExcelReadExecutor

Read the sheet.

execute() - Method in class com.alibaba.excel.analysis.v03.XlsListSheetListener

execute() - Method in class com.alibaba.excel.analysis.v03.XlsSaxAnalyser

execute() - Method in class com.alibaba.excel.analysis.v07.XlsxSaxAnalyser

extra(CellExtra, AnalysisContext) - Method in class com.alibaba.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

The current method is called when extra information is returned

extra(CellExtra, AnalysisContext) - Method in interface com.alibaba.excel.read.listener.ReadListener

The current method is called when extra information is returned

extra(AnalysisContext) - Method in interface com.alibaba.excel.read.processor.AnalysisEventProcessor

Read extra information

extra(AnalysisContext) - Method in class com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor

extraRead(CellExtraTypeEnum) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Read some extra information, not by default

F

FIELD_CACHE - Static variable in class com.alibaba.excel.util.ClassUtils

FieldUtils - Class in com.alibaba.excel.util

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

FieldUtils() - Constructor for class com.alibaba.excel.util.FieldUtils

file(InputStream) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Read InputStream

file(File) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Read file

file(String) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Read file

file(OutputStream) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

file(File) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

file(String) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

FileImageConverter - Class in com.alibaba.excel.converters.file

File and image converter

FileImageConverter() - Constructor for class com.alibaba.excel.converters.file.FileImageConverter

FileTypeUtils - Class in com.alibaba.excel.util

file type utils

FileTypeUtils() - Constructor for class com.alibaba.excel.util.FileTypeUtils

FileUtils - Class in com.alibaba.excel.util

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

fill(Object, WriteSheet) - Method in class com.alibaba.excel.ExcelWriter

Fill value to a sheet

fill(Object, FillConfig, WriteSheet) - Method in class com.alibaba.excel.ExcelWriter

Fill value to a sheet

fill(Supplier<Object>, WriteSheet) - Method in class com.alibaba.excel.ExcelWriter

Fill value to a sheet

fill(Supplier<Object>, FillConfig, WriteSheet) - Method in class com.alibaba.excel.ExcelWriter

Fill value to a sheet

fill(Object, FillConfig, WriteSheet) - Method in interface com.alibaba.excel.write.ExcelBuilder

WorkBook fill value

fill(Object, FillConfig, WriteSheet) - Method in class com.alibaba.excel.write.ExcelBuilderImpl

fill(Object, FillConfig) - Method in class com.alibaba.excel.write.executor.ExcelWriteFillExecutor

FILL_STYLE - Static variable in class com.alibaba.excel.constant.OrderConstant

Sorting of styles written to cells.

FillConfig - Class in com.alibaba.excel.write.metadata.fill

Fill config

FillConfig() - Constructor for class com.alibaba.excel.write.metadata.fill.FillConfig

fillDataFormat(WriteCellData<?>, String, String) - Static method in class com.alibaba.excel.util.WorkBookUtil

fillImage(CellWriteHandlerContext, List<ImageData>) - Method in class com.alibaba.excel.write.executor.AbstractExcelWriteExecutor

FillPatternTypeEnum - Enum in com.alibaba.excel.enums.poi

The enumeration value indicating the style of fill pattern being used for a cell format.

FillStyleCellWriteHandler - Class in com.alibaba.excel.write.handler.impl

fill cell style.

FillStyleCellWriteHandler() - Constructor for class com.alibaba.excel.write.handler.impl.FillStyleCellWriteHandler

FillWrapper - Class in com.alibaba.excel.write.metadata.fill

Multiple lists are supported when packing

FillWrapper(Collection) - Constructor for class com.alibaba.excel.write.metadata.fill.FillWrapper

FillWrapper(String, Collection) - Constructor for class com.alibaba.excel.write.metadata.fill.FillWrapper

findFont(boolean, short, short, String, boolean, boolean, short, byte) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

finish() - Method in interface com.alibaba.excel.analysis.ExcelAnalyser

Complete the entire read file.Release the cache and close stream

finish() - Method in class com.alibaba.excel.analysis.ExcelAnalyserImpl

finish(boolean) - Method in interface com.alibaba.excel.context.WriteContext

close

finish(boolean) - Method in class com.alibaba.excel.context.WriteContextImpl

finish() - Method in class com.alibaba.excel.ExcelReader

Complete the entire read file.Release the cache and close stream.

finish() - Method in class com.alibaba.excel.ExcelWriter

Close IO

finish(boolean) - Method in interface com.alibaba.excel.write.ExcelBuilder

Close io

finish(boolean) - Method in class com.alibaba.excel.write.ExcelBuilderImpl

FloatBooleanConverter - Class in com.alibaba.excel.converters.floatconverter

Float and boolean converter

FloatBooleanConverter() - Constructor for class com.alibaba.excel.converters.floatconverter.FloatBooleanConverter

FloatNumberConverter - Class in com.alibaba.excel.converters.floatconverter

Float and number converter

FloatNumberConverter() - Constructor for class com.alibaba.excel.converters.floatconverter.FloatNumberConverter

FloatStringConverter - Class in com.alibaba.excel.converters.floatconverter

Float and string converter

FloatStringConverter() - Constructor for class com.alibaba.excel.converters.floatconverter.FloatStringConverter

flushData() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

Font - Class in com.alibaba.excel.metadata

Deprecated.

please use WriteFont

Font() - Constructor for class com.alibaba.excel.metadata.Font

Deprecated.

FontProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

FontProperty() - Constructor for class com.alibaba.excel.metadata.property.FontProperty

format(BigDecimal, Short, String) - Method in class com.alibaba.excel.metadata.format.DataFormatter

Format data.

format(Object, StringBuffer, FieldPosition) - Method in class com.alibaba.excel.metadata.format.ExcelGeneralNumberFormat

format(Date) - Static method in class com.alibaba.excel.util.DateUtils

Format date

format(Date, String) - Static method in class com.alibaba.excel.util.DateUtils

Format date

format(LocalDateTime, String, Locale) - Static method in class com.alibaba.excel.util.DateUtils

Format date

format(LocalDateTime, String) - Static method in class com.alibaba.excel.util.DateUtils

Format date

format(BigDecimal, Boolean, String) - Static method in class com.alibaba.excel.util.DateUtils

Format date

format(BigDecimal, Short, String, GlobalConfiguration) - Static method in class com.alibaba.excel.util.NumberDataFormatterUtils

Format number data.

format(BigDecimal, Short, String, Boolean, Locale, Boolean) - Static method in class com.alibaba.excel.util.NumberDataFormatterUtils

Format number data.

format(Number, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

format

formatToCellData(Number, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

format

formatToCellDataString(Number, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

format

FormulaData - Class in com.alibaba.excel.metadata.data

formula

FormulaData() - Constructor for class com.alibaba.excel.metadata.data.FormulaData

FormulaRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

FormulaRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.FormulaRecordHandler

G

GENERAL - Static variable in class com.alibaba.excel.constant.BuiltinFormats

get(Integer) - Method in class com.alibaba.excel.cache.Ehcache

get(Integer) - Method in class com.alibaba.excel.cache.MapCache

get(Integer) - Method in interface com.alibaba.excel.cache.ReadCache

Get value

get(Integer) - Method in class com.alibaba.excel.cache.XlsCache

get(int) - Method in class com.alibaba.excel.write.metadata.CollectionRowData

get(int) - Method in class com.alibaba.excel.write.metadata.MapRowData

get(int) - Method in interface com.alibaba.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 com.alibaba.excel.metadata.csv.CsvSheet

getActiveSheetIndex() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getAlignment() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getAlignmentEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getAllInterfaces(Class<?>) - Static method in class com.alibaba.excel.util.ClassUtils

Gets a List of all interfaces implemented by the given class and its superclasses.

getAllNames() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getAllPictures() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getAnalysisContext() - Method in class com.alibaba.excel.ExcelReader

Deprecated.

please use ExcelReader.analysisContext()

getArrayFormulaRange() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getAutobreaks() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getBooleanCellValue() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getBorderBottom() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderBottomEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderLeft() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderLeftEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderRight() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderRightEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderTop() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBorderTopEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBottomBorderColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getBoundSheetRecordList() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getBuiltinFormat(Short, String, Locale) - Static method in class com.alibaba.excel.constant.BuiltinFormats

getCachedFormulaResultType() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getCachedFormulaResultTypeEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getCachePath() - Static method in class com.alibaba.excel.util.FileUtils

getCell(int) - Method in class com.alibaba.excel.metadata.csv.CsvRow

getCell(int, Row.MissingCellPolicy) - Method in class com.alibaba.excel.metadata.csv.CsvRow

getCellComment() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getCellComment(CellAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getCellComments() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getCellCoordinate(Integer, Integer, Integer) - Static method in class com.alibaba.excel.util.StyleUtil

getCellFormula() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getCellMap() - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

getCellStyle() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getCellStyleAt(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getCellType() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getCol(String, Integer) - Static method in class com.alibaba.excel.util.PositionUtils

getCollectionData() - Method in class com.alibaba.excel.write.metadata.fill.FillWrapper

getColumnBreaks() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getColumnExtend() - Method in class com.alibaba.excel.metadata.property.LoopMergeProperty

getColumnIndex() - Method in interface com.alibaba.excel.metadata.Cell

Column index

getColumnIndex() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getColumnOutlineLevel(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getColumnStyle(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getColumnWidth(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getColumnWidthInPixels(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getCoordinate(Integer) - Static method in class com.alibaba.excel.util.StyleUtil

getCreationHelper() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getCurrentRowAnalysisResult() - Method in interface com.alibaba.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readRowHolder()

getCurrentRowAnalysisResult() - Method in class com.alibaba.excel.context.AnalysisContextImpl

getCurrentRowAnalysisResult() - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

getCurrentRowNum() - Method in interface com.alibaba.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readRowHolder()

getCurrentRowNum() - Method in class com.alibaba.excel.context.AnalysisContextImpl

getCurrentSheet() - Method in interface com.alibaba.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeSheetHolder()

getCurrentSheet() - Method in class com.alibaba.excel.context.WriteContextImpl

getCustom() - Method in interface com.alibaba.excel.context.AnalysisContext

Custom attribute

getCustom() - Method in class com.alibaba.excel.context.AnalysisContextImpl

getDataFormat() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getDataFormatString() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getDataValidationHelper() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getDataValidations() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getDateCellValue() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getDefaultColumnWidth() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getDefaultRowHeight() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getDefaultRowHeightInPoints() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getDisplayGuts() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getDrawingPatriarch() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getEachRow() - Method in class com.alibaba.excel.metadata.property.LoopMergeProperty

getErrorCellValue() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getExcelType() - Method in interface com.alibaba.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readWorkbookHolder()

getExcelType() - Method in class com.alibaba.excel.context.AnalysisContextImpl

getField(Class<?>, String) - Static method in class com.alibaba.excel.util.FieldUtils

Gets an accessible Field by name respecting scope.

getField(Class<?>, String, boolean) - Static method in class com.alibaba.excel.util.FieldUtils

Gets an accessible Field by name, breaking scope if requested.

getFieldClass(Map, String, Object) - Static method in class com.alibaba.excel.util.FieldUtils

getFieldClass(Object) - Static method in class com.alibaba.excel.util.FieldUtils

getFillBackgroundColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFillBackgroundColorColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFillForegroundColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFillForegroundColorColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFillPattern() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFillPatternEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFirstCellNum() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getFirstColumnIndex() - Method in class com.alibaba.excel.metadata.CellExtra

getFirstColumnIndex() - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

getFirstRowIndex() - Method in class com.alibaba.excel.metadata.CellExtra

getFirstRowIndex() - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

getFirstRowNum() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getFirstVisibleTab() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getFitToPage() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getFontAt(short) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getFontAt(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getFontHeightInPoints() - Method in class com.alibaba.excel.metadata.Font

Deprecated.

getFontIndex() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFontIndexAsInt() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getFontName() - Method in class com.alibaba.excel.metadata.Font

Deprecated.

getFooter() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getForceFormulaRecalculation() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getForceFormulaRecalculation() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getFormat(String) - Method in class com.alibaba.excel.metadata.csv.CsvDataFormat

getFormat(short) - Method in class com.alibaba.excel.metadata.csv.CsvDataFormat

getFormat() - Method in class com.alibaba.excel.metadata.property.NumberFormatProperty

getFormatTrackingHSSFListener() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getGlobalConfiguration() - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

getHeader() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getHeight() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getHeight() - Method in class com.alibaba.excel.metadata.property.RowHeightProperty

getHeightInPoints() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getHidden() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getHorizontallyCenter() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getHssfWorkbook() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getHyperlink() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getHyperlink(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getHyperlink(CellAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getHyperlinkList() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getHyperlinkType(HyperlinkData.HyperlinkType) - Static method in class com.alibaba.excel.util.StyleUtil

getIgnoreRecord() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getImageType(byte[]) - Static method in class com.alibaba.excel.util.FileTypeUtils

getImageTypeFormat(byte[]) - Static method in class com.alibaba.excel.util.FileTypeUtils

getIndention() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getIndex() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getIndexOfFormattingRun(int) - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

getInputStream() - Method in interface com.alibaba.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readWorkbookHolder()

getInputStream() - Method in class com.alibaba.excel.context.AnalysisContextImpl

getJavaDate(double, boolean) - Static method in class com.alibaba.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 com.alibaba.excel.metadata.csv.CsvRow

getLastColumnIndex() - Method in class com.alibaba.excel.metadata.CellExtra

getLastColumnIndex() - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

getLastRowIndex() - Method in class com.alibaba.excel.metadata.CellExtra

getLastRowIndex() - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

getLastRowNum() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getLeftBorderColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getLeftCol() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getList() - Method in class com.alibaba.excel.event.SyncReadListener

getLocalDateTime(double, boolean) - Static method in class com.alibaba.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 com.alibaba.excel.metadata.csv.CsvCell

getLocked() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getMargin(short) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getMergedRegion(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getMergedRegions() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getMissingCellPolicy() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getName(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getName() - Method in class com.alibaba.excel.write.metadata.fill.FillWrapper

getNameAt(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNameIndex(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNames(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNeedReadSheet() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getNewRowIndexAndStartDoWrite() - Method in class com.alibaba.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 com.alibaba.excel.metadata.csv.CsvWorkbook

getNumberOfFontsAsInt() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNumberOfNames() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNumberOfSheets() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNumCellStyles() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getNumericCellValue() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getNumMergedRegions() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getObjectCacheMap() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

getOrCreateStyle() - Method in class com.alibaba.excel.metadata.data.WriteCellData

Return a style, if is empty, create a new

getOutlineLevel() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getOutputStream() - Method in interface com.alibaba.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeWorkbookHolder() ()}

getOutputStream() - Method in class com.alibaba.excel.context.WriteContextImpl

getPaneInformation() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getPhysicalNumberOfCells() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getPhysicalNumberOfRows() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getPoiFilesPath() - Static method in class com.alibaba.excel.util.FileUtils

getPoifsFileSystem() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getPrintArea(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getPrintSetup() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getProtect() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getQuotePrefixed() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getReadSheetIndex() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

getRepeatingColumns() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getRepeatingRows() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getRichStringCellValue() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getRightBorderColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getRotation() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getRoundingMode() - Method in class com.alibaba.excel.metadata.property.NumberFormatProperty

getRow() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getRow(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getRow(String) - Static method in class com.alibaba.excel.util.PositionUtils

getRowBreaks() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getRowByRowTagt(String, Integer) - Static method in class com.alibaba.excel.util.PositionUtils

getRowIndex() - Method in interface com.alibaba.excel.metadata.Cell

Row index

getRowIndex() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getRowIndex() - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

getRowNum() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getRowStyle() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getRowSumsBelow() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getRowSumsRight() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getRowType() - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

getScenarioProtect() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getSheet() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getSheet() - Method in class com.alibaba.excel.metadata.csv.CsvRow

getSheet(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getSheetAt(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getSheetConditionalFormatting() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getSheetIndex(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getSheetIndex(Sheet) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getSheetName() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getSheetName(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getSheetName() - Method in class com.alibaba.excel.read.metadata.ReadSheet

getSheetNo() - Method in class com.alibaba.excel.read.metadata.ReadSheet

getSheetVisibility(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getShrinkToFit() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getSpreadsheetVersion() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getSpreadsheetVersion() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

getString() - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

getStringCellValue() - Method in class com.alibaba.excel.metadata.csv.CsvCell

getTag() - Method in class com.alibaba.excel.util.BeanMapUtils.EasyExcelNamingPolicy

getTempFilePrefix() - Static method in class com.alibaba.excel.util.FileUtils

getTempObjectIndex() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

getTempRowType() - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

getText() - Method in class com.alibaba.excel.metadata.CellExtra

getTopBorderColor() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getTopRow() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getTotal() - Method in class com.alibaba.excel.read.metadata.holder.ReadSheetHolder

Deprecated.

getTotalCount() - Method in interface com.alibaba.excel.context.AnalysisContext

Deprecated.

please use AnalysisContext.readRowHolder()

getTotalCount() - Method in class com.alibaba.excel.context.AnalysisContextImpl

getType() - Method in class com.alibaba.excel.metadata.CellExtra

getVerticalAlignment() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getVerticalAlignmentEnum() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getVerticallyCenter() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getWidth() - Method in class com.alibaba.excel.metadata.property.ColumnWidthProperty

getWorkbook() - Method in interface com.alibaba.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeWorkbookHolder() ()}

getWorkbook() - Method in class com.alibaba.excel.context.WriteContextImpl

getWorkbook() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

getWrapText() - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

getZeroHeight() - Method in class com.alibaba.excel.metadata.csv.CsvRow

globalConfiguration() - Method in class com.alibaba.excel.metadata.AbstractHolder

globalConfiguration() - Method in interface com.alibaba.excel.metadata.ConfigurationHolder

Some global variables

GlobalConfiguration - Class in com.alibaba.excel.metadata

Global configuration

GlobalConfiguration() - Constructor for class com.alibaba.excel.metadata.GlobalConfiguration

groupColumn(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

groupRow(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

H

Handler - Interface in com.alibaba.excel.event

Intercepts handle some business logic

hashCode() - Method in class com.alibaba.excel.write.metadata.fill.AnalysisCell

hasHead() - Method in class com.alibaba.excel.metadata.property.ExcelHeadProperty

hasNext(AnalysisContext) - Method in class com.alibaba.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

hasNext(AnalysisContext) - Method in interface com.alibaba.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 com.alibaba.excel.metadata.AbstractParameterBuilder

You can only choose one of the AbstractParameterBuilder.head(List) and AbstractParameterBuilder.head(Class)

head(Class<?>) - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

You can only choose one of the AbstractParameterBuilder.head(List) and AbstractParameterBuilder.head(Class)

Head - Class in com.alibaba.excel.metadata

excel head

Head(Integer, Field, String, List<String>, Boolean, Boolean) - Constructor for class com.alibaba.excel.metadata.Head

headCellRangeList() - Method in class com.alibaba.excel.write.property.ExcelWriteHeadProperty

Calculate all cells that need to be merged

headCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head

headCellStyle(Head) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

Returns the column width corresponding to each column head

HeadFontStyle - Annotation Type in com.alibaba.excel.annotation.write.style

Custom header styles.

HeadKindEnum - Enum in com.alibaba.excel.enums

The types of header

HeadRowHeight - Annotation Type in com.alibaba.excel.annotation.write.style

Set the height of each table

headRowNumber(Integer) - Method in class com.alibaba.excel.read.builder.AbstractExcelReaderParameterBuilder

Count the number of added heads when read sheet.

HeadStyle - Annotation Type in com.alibaba.excel.annotation.write.style

Custom header styles

Holder - Interface in com.alibaba.excel.metadata

Get the corresponding holder

HolderEnum - Enum in com.alibaba.excel.enums

The types of holder

holderType() - Method in interface com.alibaba.excel.metadata.Holder

What holder is the return

holderType() - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

holderType() - Method in class com.alibaba.excel.read.metadata.holder.ReadSheetHolder

holderType() - Method in class com.alibaba.excel.read.metadata.holder.ReadWorkbookHolder

holderType() - Method in class com.alibaba.excel.write.metadata.holder.WriteSheetHolder

holderType() - Method in class com.alibaba.excel.write.metadata.holder.WriteTableHolder

holderType() - Method in class com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder

HorizontalAlignmentEnum - Enum in com.alibaba.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 com.alibaba.excel.write.style

Use the same style for the row

HorizontalCellStyleStrategy() - Constructor for class com.alibaba.excel.write.style.HorizontalCellStyleStrategy

HorizontalCellStyleStrategy(WriteCellStyle, List<WriteCellStyle>) - Constructor for class com.alibaba.excel.write.style.HorizontalCellStyleStrategy

HorizontalCellStyleStrategy(WriteCellStyle, WriteCellStyle) - Constructor for class com.alibaba.excel.write.style.HorizontalCellStyleStrategy

HYPERLINK_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

HyperlinkData - Class in com.alibaba.excel.metadata.data

hyperlink

HyperlinkData() - Constructor for class com.alibaba.excel.metadata.data.HyperlinkData

HyperlinkData.HyperlinkType - Enum in com.alibaba.excel.metadata.data

HyperlinkRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

HyperlinkRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.HyperlinkRecordHandler

HyperlinkTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Handler

HyperlinkTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.HyperlinkTagHandler

I

IgnorableXlsRecordHandler - Interface in com.alibaba.excel.analysis.v03

Need to ignore the current handler without reading the current sheet.

ignore(String, Integer) - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

ignore(String, Integer) - Method in interface com.alibaba.excel.write.metadata.holder.WriteHolder

Is to determine if a field needs to be ignored

ignoreEmptyRow(Boolean) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Ignore empty rows.Default is true.

IgnoreExceptionReadListener<T> - Interface in com.alibaba.excel.read.listener

Interface to listen for read results

ImageData - Class in com.alibaba.excel.metadata.data

image

ImageData() - Constructor for class com.alibaba.excel.metadata.data.ImageData

ImageData.ImageType - Enum in com.alibaba.excel.metadata.data

includeColumnFieldNames(Collection<String>) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Only output the custom columns.

includeColumnFiledNames(Collection<String>) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Deprecated.

use AbstractExcelWriterParameterBuilder.includeColumnFieldNames(Collection)

includeColumnIndexes(Collection<Integer>) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Only output the custom columns.

IndexRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

IndexRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.IndexRecordHandler

init(AnalysisContext) - Method in class com.alibaba.excel.cache.Ehcache

init(AnalysisContext) - Method in class com.alibaba.excel.cache.MapCache

init(AnalysisContext) - Method in interface com.alibaba.excel.cache.ReadCache

Initialize cache

init(AnalysisContext) - Method in class com.alibaba.excel.cache.XlsCache

init() - Method in class com.alibaba.excel.write.metadata.fill.FillConfig

initAnnotationConfig(List<WriteHandler>, WriteBasicParameter) - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

initHandler(WriteBasicParameter, AbstractWriteHolder) - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

initHead(ExcelWriteHeadProperty) - Method in class com.alibaba.excel.context.WriteContextImpl

inMemory(Boolean) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

Write excel in memory.

InputStreamImageConverter - Class in com.alibaba.excel.converters.inputstream

File and image converter

InputStreamImageConverter() - Constructor for class com.alibaba.excel.converters.inputstream.InputStreamImageConverter

INSTANCE - Static variable in class com.alibaba.excel.util.BeanMapUtils.EasyExcelNamingPolicy

IntegerBooleanConverter - Class in com.alibaba.excel.converters.integer

Integer and boolean converter

IntegerBooleanConverter() - Constructor for class com.alibaba.excel.converters.integer.IntegerBooleanConverter

IntegerNumberConverter - Class in com.alibaba.excel.converters.integer

Integer and number converter

IntegerNumberConverter() - Constructor for class com.alibaba.excel.converters.integer.IntegerNumberConverter

IntegerStringConverter - Class in com.alibaba.excel.converters.integer

Integer and string converter

IntegerStringConverter() - Constructor for class com.alibaba.excel.converters.integer.IntegerStringConverter

interrupt() - Method in interface com.alibaba.excel.context.AnalysisContext

Deprecated.

please use ReadListener.hasNext(AnalysisContext)

interrupt() - Method in class com.alibaba.excel.context.AnalysisContextImpl

IntervalFont() - Constructor for class com.alibaba.excel.metadata.data.RichTextStringData.IntervalFont

IntUtils - Class in com.alibaba.excel.util

Int utils

invoke(Object, AnalysisContext) - Method in class com.alibaba.excel.event.SyncReadListener

invoke(Map<Integer, ReadCellData<?>>, AnalysisContext) - Method in class com.alibaba.excel.read.listener.ModelBuildEventListener

invoke(T, AnalysisContext) - Method in class com.alibaba.excel.read.listener.PageReadListener

invoke(T, AnalysisContext) - Method in interface com.alibaba.excel.read.listener.ReadListener

When analysis one row trigger invoke function.

invokeHead(Map<Integer, ReadCellData<?>>, AnalysisContext) - Method in class com.alibaba.excel.event.AnalysisEventListener

invokeHead(Map<Integer, ReadCellData<?>>, AnalysisContext) - Method in interface com.alibaba.excel.read.listener.ReadListener

When analysis one head row trigger invoke function.

invokeHeadMap(Map<Integer, String>, AnalysisContext) - Method in class com.alibaba.excel.event.AnalysisEventListener

Returns the header as a map.Override the current method to receive header data.

IoUtils - Class in com.alibaba.excel.util

IO Utils

isADateFormat(Short, String) - Static method in class com.alibaba.excel.util.DateUtils

Determine if it is a date format.

isADateFormatUncached(Short, String) - Static method in class com.alibaba.excel.util.DateUtils

Determine if it is a date format.

isBlank(CharSequence) - Static method in class com.alibaba.excel.util.StringUtils

Checks if a CharSequence is empty (""), null or whitespace only.

isBold() - Method in class com.alibaba.excel.metadata.Font

Deprecated.

isColumnBroken(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isColumnHidden(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isDisplayFormulas() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isDisplayGridlines() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isDisplayRowColHeadings() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isDisplayZeros() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isEmpty(CharSequence) - Static method in class com.alibaba.excel.util.StringUtils

Checks if a CharSequence is empty ("") or null.

isEmpty() - Method in class com.alibaba.excel.write.metadata.CollectionRowData

isEmpty() - Method in class com.alibaba.excel.write.metadata.MapRowData

isEmpty() - Method in interface com.alibaba.excel.write.metadata.RowData

Returns true if this collection contains no elements.

isFalse(Boolean) - Static method in class com.alibaba.excel.util.BooleanUtils

Checks if a Boolean value is false, handling null by returning false.

isFormatted() - Method in class com.alibaba.excel.metadata.csv.CsvRow

isHidden() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

isInternalDateFormat(short) - Static method in class com.alibaba.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 com.alibaba.excel.metadata.AbstractHolder

isNew() - Method in interface com.alibaba.excel.metadata.ConfigurationHolder

Record whether it's new or from cache

isNotBlank(CharSequence) - Static method in class com.alibaba.excel.util.StringUtils

Checks if a CharSequence is not empty (""), not null and not whitespace only.

isNotFalse(Boolean) - Static method in class com.alibaba.excel.util.BooleanUtils

Checks if a Boolean value is not false, handling null by returning true.

isNotTrue(Boolean) - Static method in class com.alibaba.excel.util.BooleanUtils

Checks if a Boolean value is not true, handling null by returning true.

isNumeric(CharSequence) - Static method in class com.alibaba.excel.util.StringUtils

Checks if the CharSequence contains only Unicode digits.

isPartOfArrayFormulaGroup() - Method in class com.alibaba.excel.metadata.csv.CsvCell

isPrintGridlines() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isPrintRowAndColumnHeadings() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isRightToLeft() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isRowBroken(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isSelected() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

isSheetHidden(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

isSheetVeryHidden(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

isTrue(Boolean) - Static method in class com.alibaba.excel.util.BooleanUtils

Checks if a Boolean value is true, handling null by returning false.

isTrue(boolean, String, long) - Static method in class com.alibaba.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 com.alibaba.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 com.alibaba.excel.util.Validate

Validate that the argument condition is true; otherwise throwing an exception with the specified message.

isTrue(boolean) - Static method in class com.alibaba.excel.util.Validate

Validate that the argument condition is true; otherwise throwing an exception.

iterator() - Method in class com.alibaba.excel.metadata.csv.CsvRow

iterator() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

iterator() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

L

LabelRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

LabelRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.LabelRecordHandler

LabelSstRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

LabelSstRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.LabelSstRecordHandler

length() - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

linkExternalWorkbook(String, Workbook) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

Listener - Interface in com.alibaba.excel.event

Interface to listen for processing results

ListUtils - Class in com.alibaba.excel.util

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

loadAllConverter() - Static method in class com.alibaba.excel.converters.DefaultConverterLoader

Load all converter

loadDefaultHandler(Boolean, ExcelTypeEnum) - Static method in class com.alibaba.excel.write.handler.DefaultWriteHandlerLoader

Load default handler

loadDefaultReadConverter() - Static method in class com.alibaba.excel.converters.DefaultConverterLoader

Load default read converter

loadDefaultWriteConverter() - Static method in class com.alibaba.excel.converters.DefaultConverterLoader

Load default write converter

LocalDateNumberConverter - Class in com.alibaba.excel.converters.localdatetime

LocalDateTime and number converter

LocalDateNumberConverter() - Constructor for class com.alibaba.excel.converters.localdatetime.LocalDateNumberConverter

LocalDateTimeDateConverter - Class in com.alibaba.excel.converters.localdatetime

Date and date converter

LocalDateTimeDateConverter() - Constructor for class com.alibaba.excel.converters.localdatetime.LocalDateTimeDateConverter

LocalDateTimeStringConverter - Class in com.alibaba.excel.converters.localdatetime

LocalDateTime and string converter

LocalDateTimeStringConverter() - Constructor for class com.alibaba.excel.converters.localdatetime.LocalDateTimeStringConverter

locale(Locale) - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

A Locale object represents a specific geographical, political, or cultural region.

LongBooleanConverter - Class in com.alibaba.excel.converters.longconverter

Long and boolean converter

LongBooleanConverter() - Constructor for class com.alibaba.excel.converters.longconverter.LongBooleanConverter

LongestMatchColumnWidthStyleStrategy - Class in com.alibaba.excel.write.style.column

Take the width of the longest column as the width.

LongestMatchColumnWidthStyleStrategy() - Constructor for class com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy

LongNumberConverter - Class in com.alibaba.excel.converters.longconverter

Long and number converter

LongNumberConverter() - Constructor for class com.alibaba.excel.converters.longconverter.LongNumberConverter

LongStringConverter - Class in com.alibaba.excel.converters.longconverter

Long and string converter

LongStringConverter() - Constructor for class com.alibaba.excel.converters.longconverter.LongStringConverter

LoopMergeProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

LoopMergeProperty(int, int) - Constructor for class com.alibaba.excel.metadata.property.LoopMergeProperty

LoopMergeStrategy - Class in com.alibaba.excel.write.merge

The regions of the loop merge

LoopMergeStrategy(int, int) - Constructor for class com.alibaba.excel.write.merge.LoopMergeStrategy

LoopMergeStrategy(int, int, int) - Constructor for class com.alibaba.excel.write.merge.LoopMergeStrategy

LoopMergeStrategy(LoopMergeProperty, Integer) - Constructor for class com.alibaba.excel.write.merge.LoopMergeStrategy

M

mandatoryUseInputStream(Boolean) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Mandatory use 'inputStream' .Default is false.

MapCache - Class in com.alibaba.excel.cache

Putting temporary data directly into a map is a little more efficient but very memory intensive

MapCache() - Constructor for class com.alibaba.excel.cache.MapCache

MapRowData - Class in com.alibaba.excel.write.metadata

A map row of data.

MapRowData(Map<Integer, ?>) - Constructor for class com.alibaba.excel.write.metadata.MapRowData

MapUtils - Class in com.alibaba.excel.util

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

match(ReadSheet, AnalysisContext) - Static method in class com.alibaba.excel.util.SheetUtils

Match the parameters to the actual sheet

MAX_POWER_OF_TWO - Static variable in class com.alibaba.excel.util.IntUtils

The largest power of two that can be represented as an int.

MemberUtils - Class in com.alibaba.excel.util

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

MemberUtils() - Constructor for class com.alibaba.excel.util.MemberUtils

merge(DataFormatData, DataFormatData) - Static method in class com.alibaba.excel.metadata.data.DataFormatData

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

merge(int, int, int, int) - Method in interface com.alibaba.excel.write.ExcelBuilder

Deprecated.

please useOnceAbsoluteMergeStrategy

merge(int, int, int, int) - Method in class com.alibaba.excel.write.ExcelBuilderImpl

merge(Sheet, Cell, Head, Integer) - Method in class com.alibaba.excel.write.merge.AbstractMergeStrategy

merge

merge(WriteCellStyle, WriteCellStyle) - Static method in class com.alibaba.excel.write.metadata.style.WriteCellStyle

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

merge(WriteFont, WriteFont) - Static method in class com.alibaba.excel.write.metadata.style.WriteFont

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

MERGE_CELL_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

MergeCellsRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

MergeCellsRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.MergeCellsRecordHandler

MergeCellTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Handler

MergeCellTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.MergeCellTagHandler

MIN_CUSTOM_DATA_FORMAT_INDEX - Static variable in class com.alibaba.excel.constant.BuiltinFormats

ModelBuildEventListener - Class in com.alibaba.excel.read.listener

Convert to the object the user needs

ModelBuildEventListener() - Constructor for class com.alibaba.excel.read.listener.ModelBuildEventListener

N

needHead() - Method in interface com.alibaba.excel.context.WriteContext

Deprecated.

please us eWriteContext.writeSheetHolder()

needHead() - Method in class com.alibaba.excel.context.WriteContextImpl

needHead(Boolean) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Need Head

needHead() - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

needHead() - Method in interface com.alibaba.excel.write.metadata.holder.WriteHolder

Whether a header is required for the currently operated cell

newArrayList() - Static method in class com.alibaba.excel.util.ListUtils

Creates a mutable, empty ArrayList instance (for Java 6 and earlier).

newArrayList(E...) - Static method in class com.alibaba.excel.util.ListUtils

Creates a mutable ArrayList instance containing the given elements.

newArrayList(Iterator<? extends E>) - Static method in class com.alibaba.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 com.alibaba.excel.util.ListUtils

Creates a mutable ArrayList instance containing the given elements;

newArrayListWithCapacity(int) - Static method in class com.alibaba.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 com.alibaba.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 com.alibaba.excel.metadata.data.ReadCellData

newEmptyInstance(Integer, Integer) - Static method in class com.alibaba.excel.metadata.data.ReadCellData

newHashMap() - Static method in class com.alibaba.excel.util.MapUtils

Creates a mutable, empty HashMap instance.

newHashMapWithExpectedSize(int) - Static method in class com.alibaba.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 com.alibaba.excel.metadata.data.ReadCellData

newInstance(Boolean, Integer, Integer) - Static method in class com.alibaba.excel.metadata.data.ReadCellData

newInstance(String, Integer, Integer) - Static method in class com.alibaba.excel.metadata.data.ReadCellData

newInstance(BigDecimal, Integer, Integer) - Static method in class com.alibaba.excel.metadata.data.ReadCellData

newInstanceOriginal(BigDecimal, Integer, Integer) - Static method in class com.alibaba.excel.metadata.data.ReadCellData

newLinkedHashMap() - Static method in class com.alibaba.excel.util.MapUtils

Creates a mutable, empty, insertion-ordered LinkedHashMap instance.

newLinkedHashMapWithExpectedSize(int) - Static method in class com.alibaba.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 com.alibaba.excel.util.MapUtils

Creates a mutable, empty TreeMap instance using the natural ordering of its elements.

NoteRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

NoteRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.NoteRecordHandler

notNull(T) - Static method in class com.alibaba.excel.util.Validate

Validate that the specified argument is not null; otherwise throwing an exception.

notNull(T, String, Object...) - Static method in class com.alibaba.excel.util.Validate

Validate that the specified argument is not null; otherwise throwing an exception with the specified message.

NotRepeatExecutor - Interface in com.alibaba.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 com.alibaba.excel.constant.ExcelXmlConstants

NS2_CELL_INLINE_STRING_VALUE_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NS2_CELL_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NS2_CELL_VALUE_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NS2_DIMENSION_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NS2_HYPERLINK_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NS2_MERGE_CELL_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NS2_ROW_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

NullableObjectConverter<T> - Interface in com.alibaba.excel.converters

When implementing convertToExcelData method, pay attention to the reference value may be null

NullObject - Class in com.alibaba.excel.metadata

Null object.

NullObject() - Constructor for class com.alibaba.excel.metadata.NullObject

nullObjectClass - Static variable in class com.alibaba.excel.util.FieldUtils

NumberDataFormatterUtils - Class in com.alibaba.excel.util

Convert number data, including date.

NumberDataFormatterUtils() - Constructor for class com.alibaba.excel.util.NumberDataFormatterUtils

NumberFormat - Annotation Type in com.alibaba.excel.annotation.format

Convert number format.

NumberFormatProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

NumberFormatProperty(String, RoundingMode) - Constructor for class com.alibaba.excel.metadata.property.NumberFormatProperty

NumberRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

NumberRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.NumberRecordHandler

NumberUtils - Class in com.alibaba.excel.util

Number utils

NumericCellTypeEnum - Enum in com.alibaba.excel.enums

Used to supplement CellType.

numFormattingRuns() - Method in class com.alibaba.excel.metadata.csv.CsvRichTextString

O

ObjRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

ObjRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.ObjRecordHandler

OnceAbsoluteMerge - Annotation Type in com.alibaba.excel.annotation.write.style

Merge the cells once

OnceAbsoluteMergeProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

OnceAbsoluteMergeProperty(int, int, int, int) - Constructor for class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

OnceAbsoluteMergeStrategy - Class in com.alibaba.excel.write.merge

It only merges once when create cell(firstRowIndex,lastRowIndex)

OnceAbsoluteMergeStrategy(int, int, int, int) - Constructor for class com.alibaba.excel.write.merge.OnceAbsoluteMergeStrategy

OnceAbsoluteMergeStrategy(OnceAbsoluteMergeProperty) - Constructor for class com.alibaba.excel.write.merge.OnceAbsoluteMergeStrategy

onException(Exception, AnalysisContext) - Method in class com.alibaba.excel.event.AbstractIgnoreExceptionReadListener

Deprecated.

All listeners receive this method when any one Listener does an error report.

onException(Exception, AnalysisContext) - Method in interface com.alibaba.excel.read.listener.IgnoreExceptionReadListener

All listeners receive this method when any one Listener does an error report.

onException(Exception, AnalysisContext) - Method in interface com.alibaba.excel.read.listener.ReadListener

All listeners receive this method when any one Listener does an error report.

openInputStream(File) - Static method in class com.alibaba.excel.util.FileUtils

Opens a FileInputStream for the specified file, providing better error messages than simply calling new FileInputStream(file).

order() - Method in interface com.alibaba.excel.event.Handler

handler order

Order - Interface in com.alibaba.excel.event

Implement this interface when sorting

order() - Method in interface com.alibaba.excel.event.Order

The smaller the first implementation

order() - Method in class com.alibaba.excel.write.handler.impl.FillStyleCellWriteHandler

order() - Method in class com.alibaba.excel.write.style.AbstractCellStyleStrategy

order() - Method in class com.alibaba.excel.write.style.DefaultStyle

OrderConstant - Class in com.alibaba.excel.constant

Order constant.

OrderConstant() - Constructor for class com.alibaba.excel.constant.OrderConstant

org.apache.poi.hssf.usermodel - package org.apache.poi.hssf.usermodel

ownSheetHandlerExecutionChain - Variable in class com.alibaba.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 com.alibaba.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 com.alibaba.excel.read.listener

page read listener

PageReadListener(Consumer<List<T>>) - Constructor for class com.alibaba.excel.read.listener.PageReadListener

parameter() - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

Get parameter

parameter() - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

parameter() - Method in class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

parameter() - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

parameter() - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

parameter() - Method in class com.alibaba.excel.write.builder.ExcelWriterTableBuilder

parseBigDecimal(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse

parseByte(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse

parseDate(String, String) - Static method in class com.alibaba.excel.util.DateUtils

convert string to date

parseDate(String) - Static method in class com.alibaba.excel.util.DateUtils

convert string to date

parseDouble(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse

parseFloat(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse

parseInteger(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse Integer from string

parseLocalDateTime(String, String, Locale) - Static method in class com.alibaba.excel.util.DateUtils

convert string to date

parseLong(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse

parseObject(String, ParsePosition) - Method in class com.alibaba.excel.metadata.format.ExcelGeneralNumberFormat

parseShort(String, ExcelContentProperty) - Static method in class com.alibaba.excel.util.NumberUtils

parse

password(String) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Whether the encryption

password(String) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

Whether the encryption.

POI_FILES - Static variable in class com.alibaba.excel.util.FileUtils

PoiUtils - Class in org.apache.poi.hssf.usermodel

utils

PoiUtils() - Constructor for class org.apache.poi.hssf.usermodel.PoiUtils

PositionUtils - Class in com.alibaba.excel.util

printData() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.BlankRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.BofRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.BoolErrRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.BoundSheetRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.DummyRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.EofRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.FormulaRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.HyperlinkRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.IndexRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.LabelRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.LabelSstRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.MergeCellsRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.NoteRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.NumberRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.ObjRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.RkRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.SstRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.StringRecordHandler

processRecord(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.TextObjectRecordHandler

processRecord(Record) - Method in class com.alibaba.excel.analysis.v03.XlsListSheetListener

processRecord(XlsReadContext, Record) - Method in interface com.alibaba.excel.analysis.v03.XlsRecordHandler

Processing record

processRecord(Record) - Method in class com.alibaba.excel.analysis.v03.XlsSaxAnalyser

protectSheet(String) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

put(String) - Method in class com.alibaba.excel.cache.Ehcache

put(String) - Method in class com.alibaba.excel.cache.MapCache

put(String) - Method in interface com.alibaba.excel.cache.ReadCache

Automatically generate the key and put it in the cache.Key start from 0

put(String) - Method in class com.alibaba.excel.cache.XlsCache

putFinished() - Method in class com.alibaba.excel.cache.Ehcache

putFinished() - Method in class com.alibaba.excel.cache.MapCache

putFinished() - Method in interface com.alibaba.excel.cache.ReadCache

It's called when all the values are put in

putFinished() - Method in class com.alibaba.excel.cache.XlsCache

R

read() - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(File) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(File, ReadListener) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(File, Class, ReadListener) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(String) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(String, ReadListener) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(String, Class, ReadListener) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(InputStream) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(InputStream, ReadListener) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read(InputStream, Class, ReadListener) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the read

read() - Method in class com.alibaba.excel.ExcelReader

Deprecated.

lease use ExcelReader.readAll()

read(ReadSheet...) - Method in class com.alibaba.excel.ExcelReader

Parse the specified sheet，SheetNo start from 0

read(List<ReadSheet>) - Method in class com.alibaba.excel.ExcelReader

Read multiple sheets.

readAll() - Method in class com.alibaba.excel.ExcelReader

Parse all sheet content by default

ReadBasicParameter - Class in com.alibaba.excel.read.metadata

Read basic parameter

ReadBasicParameter() - Constructor for class com.alibaba.excel.read.metadata.ReadBasicParameter

ReadCache - Interface in com.alibaba.excel.cache

Read cache

readCache(PackagePart) - Method in class com.alibaba.excel.cache.selector.EternalReadCacheSelector

readCache(PackagePart) - Method in interface com.alibaba.excel.cache.selector.ReadCacheSelector

Select a cache

readCache(PackagePart) - Method in class com.alibaba.excel.cache.selector.SimpleReadCacheSelector

readCache(ReadCache) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

A cache that stores temp data to save memory.

ReadCacheSelector - Interface in com.alibaba.excel.cache.selector

Select the cache

readCacheSelector(ReadCacheSelector) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Select the cache.Default use SimpleReadCacheSelector

ReadCellData<T> - Class in com.alibaba.excel.metadata.data

read cell data

ReadCellData(CellDataTypeEnum) - Constructor for class com.alibaba.excel.metadata.data.ReadCellData

ReadCellData(T) - Constructor for class com.alibaba.excel.metadata.data.ReadCellData

ReadCellData(String) - Constructor for class com.alibaba.excel.metadata.data.ReadCellData

ReadCellData(CellDataTypeEnum, String) - Constructor for class com.alibaba.excel.metadata.data.ReadCellData

ReadCellData(BigDecimal) - Constructor for class com.alibaba.excel.metadata.data.ReadCellData

ReadCellData(Boolean) - Constructor for class com.alibaba.excel.metadata.data.ReadCellData

ReadConverterContext<T> - Class in com.alibaba.excel.converters

read converter context

ReadConverterContext() - Constructor for class com.alibaba.excel.converters.ReadConverterContext

readDefaultReturn(ReadDefaultReturnEnum) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Read not to com.alibaba.excel.metadata.BasicParameter#clazz value, the default will return type.

ReadDefaultReturnEnum - Enum in com.alibaba.excel.enums

Read not to com.alibaba.excel.metadata.BasicParameter#clazz value, the default will return type.

readFileToByteArray(File) - Static method in class com.alibaba.excel.util.FileUtils

Reads the contents of a file into a byte array.

ReadHolder - Interface in com.alibaba.excel.read.metadata.holder

Get the corresponding Holder

ReadListener<T> - Interface in com.alibaba.excel.read.listener

Interface to listen for read results

readListenerList() - Method in class com.alibaba.excel.read.metadata.holder.AbstractReadHolder

readListenerList() - Method in interface com.alibaba.excel.read.metadata.holder.ReadHolder

What handler does the currently operated cell need to execute

readRowHolder(ReadRowHolder) - Method in interface com.alibaba.excel.context.AnalysisContext

Set row of currently operated cell

readRowHolder() - Method in interface com.alibaba.excel.context.AnalysisContext

Row of currently operated cell

readRowHolder() - Method in class com.alibaba.excel.context.AnalysisContextImpl

readRowHolder(ReadRowHolder) - Method in class com.alibaba.excel.context.AnalysisContextImpl

ReadRowHolder - Class in com.alibaba.excel.read.metadata.holder

sheet holder

ReadRowHolder(Integer, RowTypeEnum, GlobalConfiguration, Map<Integer, Cell>) - Constructor for class com.alibaba.excel.read.metadata.holder.ReadRowHolder

readSheet() - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'readSheet'

readSheet(Integer) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'readSheet'

readSheet(String) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'readSheet'

readSheet(Integer, String) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'readSheet'

ReadSheet - Class in com.alibaba.excel.read.metadata

Read sheet

ReadSheet() - Constructor for class com.alibaba.excel.read.metadata.ReadSheet

ReadSheet(Integer) - Constructor for class com.alibaba.excel.read.metadata.ReadSheet

ReadSheet(Integer, String) - Constructor for class com.alibaba.excel.read.metadata.ReadSheet

readSheetHolder() - Method in interface com.alibaba.excel.context.AnalysisContext

All information about the sheet you are currently working on

readSheetHolder() - Method in class com.alibaba.excel.context.AnalysisContextImpl

ReadSheetHolder - Class in com.alibaba.excel.read.metadata.holder

sheet holder

ReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class com.alibaba.excel.read.metadata.holder.ReadSheetHolder

readSheetList() - Method in interface com.alibaba.excel.context.AnalysisContext

Data that the customer needs to read

readSheetList(List<ReadSheet>) - Method in interface com.alibaba.excel.context.AnalysisContext

Data that the customer needs to read

readSheetList() - Method in class com.alibaba.excel.context.AnalysisContextImpl

readSheetList(List<ReadSheet>) - Method in class com.alibaba.excel.context.AnalysisContextImpl

ReadWorkbook - Class in com.alibaba.excel.read.metadata

Workbook

ReadWorkbook() - Constructor for class com.alibaba.excel.read.metadata.ReadWorkbook

readWorkbookHolder() - Method in interface com.alibaba.excel.context.AnalysisContext

All information about the workbook you are currently working on

readWorkbookHolder() - Method in class com.alibaba.excel.context.AnalysisContextImpl

ReadWorkbookHolder - Class in com.alibaba.excel.read.metadata.holder

Workbook holder

ReadWorkbookHolder(ReadWorkbook) - Constructor for class com.alibaba.excel.read.metadata.holder.ReadWorkbookHolder

regionMatches(CharSequence, boolean, int, CharSequence, int, int) - Static method in class com.alibaba.excel.util.StringUtils

Green implementation of regionMatches.

registerConverter(Converter<?>) - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

Custom type conversions override the default.

registerReadListener(ReadListener<?>) - Method in class com.alibaba.excel.read.builder.AbstractExcelReaderParameterBuilder

Custom type listener run after default

registerWriteHandler(WriteHandler) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Custom write handler

relativeHeadRowIndex(Integer) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Writes the head relative to the existing contents of the sheet.

relativeHeadRowIndex() - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

relativeHeadRowIndex() - Method in interface com.alibaba.excel.write.metadata.holder.WriteHolder

Writes the head relative to the existing contents of the sheet.

removeArrayFormula(Cell) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

removeCell(Cell) - Method in class com.alibaba.excel.metadata.csv.CsvRow

removeCellComment() - Method in class com.alibaba.excel.metadata.csv.CsvCell

removeColumnBreak(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

removeFormulaImpl() - Method in class com.alibaba.excel.metadata.csv.CsvCell

removeHyperlink() - Method in class com.alibaba.excel.metadata.csv.CsvCell

removeMergedRegion(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

removeMergedRegions(Collection<Integer>) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

removeName(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

removeName(String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

removeName(Name) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

removePrintArea(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

removeRow(Row) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

removeRowBreak(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

removeSheetAt(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

removeThreadLocalCache() - Static method in class com.alibaba.excel.util.DateUtils

removeThreadLocalCache() - Static method in class com.alibaba.excel.util.NumberDataFormatterUtils

resolveCglibFieldName(Field) - Static method in class com.alibaba.excel.util.FieldUtils

Parsing the name matching cglib。

RichTextStringData - Class in com.alibaba.excel.metadata.data

rich text string

RichTextStringData(String) - Constructor for class com.alibaba.excel.metadata.data.RichTextStringData

RichTextStringData.IntervalFont - Class in com.alibaba.excel.metadata.data

RkRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

RkRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.RkRecordHandler

ROW_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

RowData - Interface in com.alibaba.excel.write.metadata

A row of data.

RowHandlerExecutionChain - Class in com.alibaba.excel.write.handler.chain

Execute the row handler chain

RowHandlerExecutionChain(RowWriteHandler) - Constructor for class com.alibaba.excel.write.handler.chain.RowHandlerExecutionChain

rowHandlerExecutionChain - Variable in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

Execute the row handler chain

RowHeightProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

RowHeightProperty(Short) - Constructor for class com.alibaba.excel.metadata.property.RowHeightProperty

rowIterator() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

RowTagHandler - Class in com.alibaba.excel.analysis.v07.handlers

Cell Handler

RowTagHandler() - Constructor for class com.alibaba.excel.analysis.v07.handlers.RowTagHandler

RowTypeEnum - Enum in com.alibaba.excel.enums

The types of row

RowWriteHandler - Interface in com.alibaba.excel.write.handler

intercepts handle row creation

RowWriteHandlerContext - Class in com.alibaba.excel.write.handler.context

row context

RowWriteHandlerContext() - Constructor for class com.alibaba.excel.write.handler.context.RowWriteHandlerContext

S

saturatedCast(long) - Static method in class com.alibaba.excel.util.IntUtils

Returns the int nearest in value to value.

self() - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

setActiveCell(CellAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setActiveSheet(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setAlignment(HorizontalAlignment) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setArrayFormula(String, CellRangeAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setAsActiveCell() - Method in class com.alibaba.excel.metadata.csv.CsvCell

setAutobreaks(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setAutoFilter(CellRangeAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setBold(boolean) - Method in class com.alibaba.excel.metadata.Font

Deprecated.

setBorderBottom(BorderStyle) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setBorderLeft(BorderStyle) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setBorderRight(BorderStyle) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setBorderTop(BorderStyle) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setBottomBorderColor(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setBoundSheetRecordList(List<BoundSheetRecord>) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setCachePath(String) - Static method in class com.alibaba.excel.util.FileUtils

setCellComment(Comment) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellErrorValue(byte) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellFormulaImpl(String) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellMap(Map<Integer, Cell>) - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

setCellStyle(CellStyle) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellTypeImpl(CellType) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValue(String) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValue(RichTextString) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValue(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValueImpl(double) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValueImpl(Date) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValueImpl(LocalDateTime) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValueImpl(Calendar) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValueImpl(String) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCellValueImpl(RichTextString) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setCollectionData(Collection) - Method in class com.alibaba.excel.write.metadata.fill.FillWrapper

setColumnBreak(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setColumnExtend(int) - Method in class com.alibaba.excel.metadata.property.LoopMergeProperty

setColumnGroupCollapsed(int, boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setColumnHidden(int, boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setColumnWidth(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setColumnWidth(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy

Sets the column width when head create

setColumnWidth(WriteSheetHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy

Sets the column width when head create

setColumnWidth(WriteSheetHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class com.alibaba.excel.write.style.column.AbstractHeadColumnWidthStyleStrategy

setColumnWidth(WriteSheetHolder, List<WriteCellData<?>>, Cell, Head, Integer, Boolean) - Method in class com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy

setContentCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of content

setContentCellStyle(Cell, Head, Integer) - Method in class com.alibaba.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of content

setContentCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

setContentCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.HorizontalCellStyleStrategy

setContentColumnHeight(Row, int) - Method in class com.alibaba.excel.write.style.row.AbstractRowHeightStyleStrategy

Sets the height of content

setContentColumnHeight(Row, int) - Method in class com.alibaba.excel.write.style.row.SimpleRowHeightStyleStrategy

setCurrentRowAnalysisResult(Object) - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

setDataFormat(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setDefaultColumnStyle(int, CellStyle) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDefaultColumnWidth(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDefaultNumberFormat(Format) - Method in class com.alibaba.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 com.alibaba.excel.metadata.csv.CsvSheet

setDefaultRowHeightInPoints(float) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDisplayFormulas(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDisplayGridlines(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDisplayGuts(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDisplayRowColHeadings(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setDisplayZeros(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setEachRow(int) - Method in class com.alibaba.excel.metadata.property.LoopMergeProperty

setExcelStyleRoundingMode(DecimalFormat) - Static method in class com.alibaba.excel.metadata.format.DataFormatter

Enables excel style rounding mode (round half up) on the Decimal Format given.

setExcelStyleRoundingMode(DecimalFormat, RoundingMode) - Static method in class com.alibaba.excel.metadata.format.DataFormatter

Enables custom rounding mode on the given Decimal Format.

setFillBackgroundColor(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setFillForegroundColor(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setFillPattern(FillPatternType) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setFirstColumnIndex(Integer) - Method in class com.alibaba.excel.metadata.CellExtra

setFirstColumnIndex(int) - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

setFirstRowIndex(Integer) - Method in class com.alibaba.excel.metadata.CellExtra

setFirstRowIndex(int) - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

setFirstVisibleTab(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setFitToPage(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setFont(Font) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setFontHeightInPoints(short) - Method in class com.alibaba.excel.metadata.Font

Deprecated.

setFontName(String) - Method in class com.alibaba.excel.metadata.Font

Deprecated.

setForceFormulaRecalculation(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setForceFormulaRecalculation(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setFormat(String) - Method in class com.alibaba.excel.metadata.property.NumberFormatProperty

setFormatTrackingHSSFListener(FormatTrackingHSSFListener) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setGlobalConfiguration(GlobalConfiguration) - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

setHeadCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of header

setHeadCellStyle(Cell, Head, Integer) - Method in class com.alibaba.excel.write.style.AbstractCellStyleStrategy

Sets the cell style of header

setHeadCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

setHeadCellStyle(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.HorizontalCellStyleStrategy

setHeadColumnHeight(Row, int) - Method in class com.alibaba.excel.write.style.row.AbstractRowHeightStyleStrategy

Sets the height of header

setHeadColumnHeight(Row, int) - Method in class com.alibaba.excel.write.style.row.SimpleRowHeightStyleStrategy

setHeight(short) - Method in class com.alibaba.excel.metadata.csv.CsvRow

setHeight(Short) - Method in class com.alibaba.excel.metadata.property.RowHeightProperty

setHeightInPoints(float) - Method in class com.alibaba.excel.metadata.csv.CsvRow

setHidden(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setHidden(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setHorizontallyCenter(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setHssfWorkbook(HSSFWorkbook) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setHyperlink(Hyperlink) - Method in class com.alibaba.excel.metadata.csv.CsvCell

setIgnoreRecord(Boolean) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setIndention(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setLastColumnIndex(Integer) - Method in class com.alibaba.excel.metadata.CellExtra

setLastColumnIndex(int) - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

setLastRowIndex(Integer) - Method in class com.alibaba.excel.metadata.CellExtra

setLastRowIndex(int) - Method in class com.alibaba.excel.metadata.property.OnceAbsoluteMergeProperty

setLeftBorderColor(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setList(List<Object>) - Method in class com.alibaba.excel.event.SyncReadListener

setLocked(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setMargin(short, double) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setMissingCellPolicy(Row.MissingCellPolicy) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setName(String) - Method in class com.alibaba.excel.write.metadata.fill.FillWrapper

setNeedReadSheet(Boolean) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setObjectCacheMap(Map<Integer, String>) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

setPoiFilesPath(String) - Static method in class com.alibaba.excel.util.FileUtils

setPoifsFileSystem(POIFSFileSystem) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setPrintArea(int, String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setPrintArea(int, int, int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setPrintGridlines(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setPrintRowAndColumnHeadings(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setQuotePrefixed(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setReadSheetIndex(Integer) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

setRepeatingColumns(CellRangeAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRepeatingRows(CellRangeAddress) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRightBorderColor(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setRightToLeft(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRotation(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setRoundingMode(RoundingMode) - Method in class com.alibaba.excel.metadata.property.NumberFormatProperty

setRowBreak(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRowGroupCollapsed(int, boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRowIndex(Integer) - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

setRowNum(int) - Method in class com.alibaba.excel.metadata.csv.CsvRow

setRowStyle(CellStyle) - Method in class com.alibaba.excel.metadata.csv.CsvRow

setRowSumsBelow(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRowSumsRight(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setRowType(RowTypeEnum) - Method in class com.alibaba.excel.read.metadata.holder.ReadRowHolder

setSelected(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setSelectedTab(int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setSheetHidden(int, boolean) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setSheetName(int, String) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setSheetName(String) - Method in class com.alibaba.excel.read.metadata.ReadSheet

setSheetNo(Integer) - Method in class com.alibaba.excel.read.metadata.ReadSheet

setSheetOrder(String, int) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setSheetVisibility(int, SheetVisibility) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

setShrinkToFit(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setTempFilePrefix(String) - Static method in class com.alibaba.excel.util.FileUtils

setTempObjectIndex(Integer) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

setTempRowType(RowTypeEnum) - Method in class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

setText(String) - Method in class com.alibaba.excel.metadata.CellExtra

setTopBorderColor(short) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setType(CellExtraTypeEnum) - Method in class com.alibaba.excel.metadata.CellExtra

setVerticalAlignment(VerticalAlignment) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setVerticallyCenter(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

setWidth(Integer) - Method in class com.alibaba.excel.metadata.property.ColumnWidthProperty

setWrapText(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvCellStyle

setZeroHeight(boolean) - Method in class com.alibaba.excel.metadata.csv.CsvRow

setZoom(int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

SHARED_STRINGS_PART_NAME - Static variable in class com.alibaba.excel.analysis.v07.XlsxSaxAnalyser

Storage sheet SharedStrings

SHAREDSTRINGS_NS2_RPH_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_NS2_SI_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_NS2_T_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_RPH_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

Mac 2016 2017 will have this extra field to ignore

SHAREDSTRINGS_SI_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SharedStringItem

SHAREDSTRINGS_T_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

text

SHAREDSTRINGS_X_RPH_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_X_SI_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SHAREDSTRINGS_X_T_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

SharedStringsTableHandler - Class in com.alibaba.excel.analysis.v07.handlers.sax

Sax read sharedStringsTable.xml

SharedStringsTableHandler(ReadCache) - Constructor for class com.alibaba.excel.analysis.v07.handlers.sax.SharedStringsTableHandler

sheet() - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

sheet(Integer) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

sheet(String) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

sheet(Integer, String) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

sheet() - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

sheet(Integer) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

sheet(String) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

sheet(Integer, String) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

SheetHandlerExecutionChain - Class in com.alibaba.excel.write.handler.chain

Execute the sheet handler chain

SheetHandlerExecutionChain(SheetWriteHandler) - Constructor for class com.alibaba.excel.write.handler.chain.SheetHandlerExecutionChain

sheetHandlerExecutionChain - Variable in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

Execute the sheet handler chain

sheetIterator() - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

sheetList() - Method in class com.alibaba.excel.analysis.csv.CsvExcelReadExecutor

sheetList() - Method in interface com.alibaba.excel.analysis.ExcelReadExecutor

Returns the actual sheet in excel

sheetList() - Method in class com.alibaba.excel.analysis.v03.XlsSaxAnalyser

sheetList() - Method in class com.alibaba.excel.analysis.v07.XlsxSaxAnalyser

sheetName(String) - Method in class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

sheet name

sheetName(String) - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

sheet name

sheetNo(Integer) - Method in class com.alibaba.excel.read.builder.ExcelReaderSheetBuilder

Starting from 0

sheetNo(Integer) - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

Starting from 0

SheetUtils - Class in com.alibaba.excel.util

Sheet utils

SheetWriteHandler - Interface in com.alibaba.excel.write.handler

intercepts handle sheet creation

SheetWriteHandlerContext - Class in com.alibaba.excel.write.handler.context

sheet context

SheetWriteHandlerContext() - Constructor for class com.alibaba.excel.write.handler.context.SheetWriteHandlerContext

shiftCellsLeft(int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvRow

shiftCellsRight(int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvRow

shiftColumns(int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

shiftRows(int, int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

shiftRows(int, int, int, boolean, boolean) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

ShortBooleanConverter - Class in com.alibaba.excel.converters.shortconverter

Short and boolean converter

ShortBooleanConverter() - Constructor for class com.alibaba.excel.converters.shortconverter.ShortBooleanConverter

ShortNumberConverter - Class in com.alibaba.excel.converters.shortconverter

Short and number converter

ShortNumberConverter() - Constructor for class com.alibaba.excel.converters.shortconverter.ShortNumberConverter

ShortStringConverter - Class in com.alibaba.excel.converters.shortconverter

Short and string converter

ShortStringConverter() - Constructor for class com.alibaba.excel.converters.shortconverter.ShortStringConverter

showInPane(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

SimpleColumnWidthStyleStrategy - Class in com.alibaba.excel.write.style.column

All the columns are the same width

SimpleColumnWidthStyleStrategy(Integer) - Constructor for class com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy

SimpleReadCacheSelector - Class in com.alibaba.excel.cache.selector

Simple cache selector

SimpleReadCacheSelector() - Constructor for class com.alibaba.excel.cache.selector.SimpleReadCacheSelector

SimpleReadCacheSelector(long, int) - Constructor for class com.alibaba.excel.cache.selector.SimpleReadCacheSelector

SimpleRowHeightStyleStrategy - Class in com.alibaba.excel.write.style.row

Set the head column high and content column high

SimpleRowHeightStyleStrategy(Short, Short) - Constructor for class com.alibaba.excel.write.style.row.SimpleRowHeightStyleStrategy

size() - Method in class com.alibaba.excel.write.metadata.CollectionRowData

size() - Method in class com.alibaba.excel.write.metadata.MapRowData

size() - Method in interface com.alibaba.excel.write.metadata.RowData

Returns the number of elements in this collection.

sortAndClearUpHandler(List<WriteHandler>, boolean) - Method in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

SPACE - Static variable in class com.alibaba.excel.util.StringUtils

A String for a space character.

SstRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

SstRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.SstRecordHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.AbstractXlsxTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.CellFormulaTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.CellTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.CountTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.HyperlinkTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.MergeCellTagHandler

startElement(XlsxReadContext, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.RowTagHandler

startElement(String, String, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.sax.SharedStringsTableHandler

startElement(String, String, String, Attributes) - Method in class com.alibaba.excel.analysis.v07.handlers.sax.XlsxRowHandler

startElement(XlsxReadContext, String, Attributes) - Method in interface com.alibaba.excel.analysis.v07.handlers.XlsxTagHandler

Start handle

stopProcessing(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy

stopProcessing(CellWriteHandlerContext) - Method in class com.alibaba.excel.write.style.HorizontalCellStyleStrategy

StringBooleanConverter - Class in com.alibaba.excel.converters.string

String and boolean converter

StringBooleanConverter() - Constructor for class com.alibaba.excel.converters.string.StringBooleanConverter

StringErrorConverter - Class in com.alibaba.excel.converters.string

String and error converter

StringErrorConverter() - Constructor for class com.alibaba.excel.converters.string.StringErrorConverter

StringImageConverter - Class in com.alibaba.excel.converters.string

String and image converter

StringImageConverter() - Constructor for class com.alibaba.excel.converters.string.StringImageConverter

StringNumberConverter - Class in com.alibaba.excel.converters.string

String and number converter

StringNumberConverter() - Constructor for class com.alibaba.excel.converters.string.StringNumberConverter

StringRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

StringRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.StringRecordHandler

StringStringConverter - Class in com.alibaba.excel.converters.string

String and string converter

StringStringConverter() - Constructor for class com.alibaba.excel.converters.string.StringStringConverter

StringUtils - Class in com.alibaba.excel.util

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

StyleProperty - Class in com.alibaba.excel.metadata.property

Configuration from annotations

StyleProperty() - Constructor for class com.alibaba.excel.metadata.property.StyleProperty

StyleUtil - Class in com.alibaba.excel.util

support(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.AbstractXlsRecordHandler

support(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.HyperlinkRecordHandler

support(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.MergeCellsRecordHandler

support(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.NoteRecordHandler

support(XlsReadContext, Record) - Method in class com.alibaba.excel.analysis.v03.handlers.TextObjectRecordHandler

support(XlsReadContext, Record) - Method in interface com.alibaba.excel.analysis.v03.XlsRecordHandler

Whether to support

support(XlsxReadContext) - Method in class com.alibaba.excel.analysis.v07.handlers.AbstractXlsxTagHandler

support(XlsxReadContext) - Method in class com.alibaba.excel.analysis.v07.handlers.HyperlinkTagHandler

support(XlsxReadContext) - Method in class com.alibaba.excel.analysis.v07.handlers.MergeCellTagHandler

support(XlsxReadContext) - Method in interface com.alibaba.excel.analysis.v07.handlers.XlsxTagHandler

Whether to support

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.bigdecimal.BigDecimalBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.bigdecimal.BigDecimalNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.bigdecimal.BigDecimalStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.biginteger.BigIntegerBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.biginteger.BigIntegerNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.biginteger.BigIntegerStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.booleanconverter.BooleanBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.booleanconverter.BooleanNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.booleanconverter.BooleanStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.byteconverter.ByteBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.byteconverter.ByteNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.byteconverter.ByteStringConverter

supportExcelTypeKey() - Method in interface com.alibaba.excel.converters.Converter

Back to object enum in excel

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.date.DateNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.date.DateStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.doubleconverter.DoubleBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.doubleconverter.DoubleNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.doubleconverter.DoubleStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.floatconverter.FloatBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.floatconverter.FloatNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.floatconverter.FloatStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.integer.IntegerBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.integer.IntegerNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.integer.IntegerStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.localdatetime.LocalDateNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.localdatetime.LocalDateTimeStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.longconverter.LongBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.longconverter.LongNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.longconverter.LongStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.shortconverter.ShortBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.shortconverter.ShortNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.shortconverter.ShortStringConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.string.StringBooleanConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.string.StringErrorConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.string.StringNumberConverter

supportExcelTypeKey() - Method in class com.alibaba.excel.converters.string.StringStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.bigdecimal.BigDecimalBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.bigdecimal.BigDecimalNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.bigdecimal.BigDecimalStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.biginteger.BigIntegerBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.biginteger.BigIntegerNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.biginteger.BigIntegerStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.booleanconverter.BooleanBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.booleanconverter.BooleanNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.booleanconverter.BooleanStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.bytearray.BoxingByteArrayImageConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.bytearray.ByteArrayImageConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.byteconverter.ByteBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.byteconverter.ByteNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.byteconverter.ByteStringConverter

supportJavaTypeKey() - Method in interface com.alibaba.excel.converters.Converter

Back to object types in Java

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.date.DateDateConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.date.DateNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.date.DateStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.doubleconverter.DoubleBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.doubleconverter.DoubleNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.doubleconverter.DoubleStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.file.FileImageConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.floatconverter.FloatBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.floatconverter.FloatNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.floatconverter.FloatStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.inputstream.InputStreamImageConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.integer.IntegerBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.integer.IntegerNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.integer.IntegerStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.localdatetime.LocalDateNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.localdatetime.LocalDateTimeDateConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.localdatetime.LocalDateTimeStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.longconverter.LongBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.longconverter.LongNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.longconverter.LongStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.shortconverter.ShortBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.shortconverter.ShortNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.shortconverter.ShortStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.string.StringBooleanConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.string.StringErrorConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.string.StringImageConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.string.StringNumberConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.string.StringStringConverter

supportJavaTypeKey() - Method in class com.alibaba.excel.converters.url.UrlImageConverter

switchBuiltinFormats(Locale) - Static method in class com.alibaba.excel.constant.BuiltinFormats

switchBuiltinFormatsMap(Locale) - Static method in class com.alibaba.excel.constant.BuiltinFormats

switchDateFormat(String) - Static method in class com.alibaba.excel.util.DateUtils

switch date format

SyncReadListener - Class in com.alibaba.excel.event

Synchronous data reading

SyncReadListener() - Constructor for class com.alibaba.excel.event.SyncReadListener

T

table() - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

table(Integer) - Method in class com.alibaba.excel.write.builder.ExcelWriterSheetBuilder

tableNo(Integer) - Method in class com.alibaba.excel.write.builder.ExcelWriterTableBuilder

Starting from 0

TextObjectRecordHandler - Class in com.alibaba.excel.analysis.v03.handlers

Record handler

TextObjectRecordHandler() - Constructor for class com.alibaba.excel.analysis.v03.handlers.TextObjectRecordHandler

toByteArray(InputStream) - Static method in class com.alibaba.excel.util.IoUtils

Gets the contents of an InputStream as a byte[].

toByteArray(InputStream, int) - Static method in class com.alibaba.excel.util.IoUtils

Gets the contents of an InputStream as a byte[].

toString() - Method in class com.alibaba.excel.read.metadata.ReadSheet

U

ungroupColumn(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

ungroupRow(int, int) - Method in class com.alibaba.excel.metadata.csv.CsvSheet

UniqueDataFlagKey() - Constructor for class com.alibaba.excel.write.executor.ExcelWriteFillExecutor.UniqueDataFlagKey

uniqueValue() - Method in interface com.alibaba.excel.event.NotRepeatExecutor

To see if it's the same executor

urlConnectTimeout - Static variable in class com.alibaba.excel.converters.url.UrlImageConverter

UrlImageConverter - Class in com.alibaba.excel.converters.url

Url and image converter

UrlImageConverter() - Constructor for class com.alibaba.excel.converters.url.UrlImageConverter

urlReadTimeout - Static variable in class com.alibaba.excel.converters.url.UrlImageConverter

use1904windowing(Boolean) - Method in class com.alibaba.excel.metadata.AbstractParameterBuilder

true if date uses 1904 windowing, or false if using 1900 date windowing.

useDefaultListener(Boolean) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

Whether to use the default listener, which is used by default.

useDefaultStyle(Boolean) - Method in class com.alibaba.excel.write.builder.AbstractExcelWriterParameterBuilder

Use the default style.Default is true.

useScientificFormat(Boolean) - Method in class com.alibaba.excel.read.builder.AbstractExcelReaderParameterBuilder

Whether to use scientific Format.

V

Validate - Class in com.alibaba.excel.util

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

Validate() - Constructor for class com.alibaba.excel.util.Validate

validateMergedRegions() - Method in class com.alibaba.excel.metadata.csv.CsvSheet

valueOf(String) - Static method in enum com.alibaba.excel.enums.BooleanEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.CellDataTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.CellExtraTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.HeadKindEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.HolderEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.NumericCellTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.poi.BorderStyleEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.poi.FillPatternTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.poi.HorizontalAlignmentEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.poi.VerticalAlignmentEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.ReadDefaultReturnEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.RowTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.WriteDirectionEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.WriteLastRowTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.WriteTemplateAnalysisCellTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.enums.WriteTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.metadata.data.ClientAnchorData.AnchorType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.metadata.data.HyperlinkData.HyperlinkType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.metadata.data.ImageData.ImageType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.alibaba.excel.support.ExcelTypeEnum

Returns the enum constant of this type with the specified name.

valueOf(ReadWorkbook) - Static method in enum com.alibaba.excel.support.ExcelTypeEnum

valueOf(String) - Static method in class com.alibaba.excel.util.BooleanUtils

String to boolean

values() - Static method in enum com.alibaba.excel.enums.BooleanEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.CellDataTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.CellExtraTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.HeadKindEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.HolderEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.NumericCellTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.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 com.alibaba.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 com.alibaba.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 com.alibaba.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 com.alibaba.excel.enums.ReadDefaultReturnEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.RowTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.WriteDirectionEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.WriteLastRowTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.WriteTemplateAnalysisCellTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.excel.enums.WriteTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.alibaba.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 com.alibaba.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 com.alibaba.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 com.alibaba.excel.support.ExcelTypeEnum

Returns an array containing the constants of this enum type, in the order they are declared.

VerticalAlignmentEnum - Enum in com.alibaba.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

withTemplate(InputStream) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

withTemplate(File) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

withTemplate(String) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

WorkbookHandlerExecutionChain - Class in com.alibaba.excel.write.handler.chain

Execute the workbook handler chain

WorkbookHandlerExecutionChain(WorkbookWriteHandler) - Constructor for class com.alibaba.excel.write.handler.chain.WorkbookHandlerExecutionChain

workbookHandlerExecutionChain - Variable in class com.alibaba.excel.write.metadata.holder.AbstractWriteHolder

Execute the workbook handler chain

WorkBookUtil - Class in com.alibaba.excel.util

WorkbookWriteHandler - Interface in com.alibaba.excel.write.handler

intercepts handle Workbook creation

WorkbookWriteHandlerContext - Class in com.alibaba.excel.write.handler.context

workbook context

WorkbookWriteHandlerContext() - Constructor for class com.alibaba.excel.write.handler.context.WorkbookWriteHandlerContext

write() - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(File) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(File, Class) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(String) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(String, Class) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(OutputStream) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(OutputStream, Class) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the write

write(Collection<?>, WriteSheet) - Method in class com.alibaba.excel.ExcelWriter

Write data to a sheet

write(Supplier<Collection<?>>, WriteSheet) - Method in class com.alibaba.excel.ExcelWriter

Write data to a sheet

write(Collection<?>, WriteSheet, WriteTable) - Method in class com.alibaba.excel.ExcelWriter

Write value to a sheet

write(Supplier<Collection<?>>, WriteSheet, WriteTable) - Method in class com.alibaba.excel.ExcelWriter

Write value to a sheet

write(OutputStream) - Method in class com.alibaba.excel.metadata.csv.CsvWorkbook

WriteBasicParameter - Class in com.alibaba.excel.write.metadata

Write basic parameter

WriteBasicParameter() - Constructor for class com.alibaba.excel.write.metadata.WriteBasicParameter

WriteCellData<T> - Class in com.alibaba.excel.metadata.data

wirte cell data

WriteCellData(String) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(CellDataTypeEnum) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(CellDataTypeEnum, String) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(BigDecimal) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(Boolean) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(Date) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(LocalDateTime) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellData(byte[]) - Constructor for class com.alibaba.excel.metadata.data.WriteCellData

WriteCellStyle - Class in com.alibaba.excel.write.metadata.style

Cell style when writing

WriteCellStyle() - Constructor for class com.alibaba.excel.write.metadata.style.WriteCellStyle

WriteContext - Interface in com.alibaba.excel.context

Write context

writeContext() - Method in class com.alibaba.excel.ExcelWriter

The context of the entire writing process

writeContext() - Method in interface com.alibaba.excel.write.ExcelBuilder

Gets the written data

writeContext() - Method in class com.alibaba.excel.write.ExcelBuilderImpl

writeContext - Variable in class com.alibaba.excel.write.executor.AbstractExcelWriteExecutor

WriteContextImpl - Class in com.alibaba.excel.context

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

WriteContextImpl(WriteWorkbook) - Constructor for class com.alibaba.excel.context.WriteContextImpl

WriteConverterContext<T> - Class in com.alibaba.excel.converters

write converter context

WriteConverterContext() - Constructor for class com.alibaba.excel.converters.WriteConverterContext

WriteDirectionEnum - Enum in com.alibaba.excel.enums

Direction of writing

writeExcelOnException(Boolean) - Method in class com.alibaba.excel.write.builder.ExcelWriterBuilder

Excel is also written in the event of an exception being thrown.The default false.

WriteFont - Class in com.alibaba.excel.write.metadata.style

Font when writing

WriteFont() - Constructor for class com.alibaba.excel.write.metadata.style.WriteFont

WriteHandler - Interface in com.alibaba.excel.write.handler

intercepts handle excel write

WriteHandlerUtils - Class in com.alibaba.excel.util

Write handler utils

WriteHolder - Interface in com.alibaba.excel.write.metadata.holder

Get the corresponding Holder

WriteLastRowTypeEnum - Enum in com.alibaba.excel.enums

The types of write last row

writerSheet() - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the writerSheet

writerSheet(Integer) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the writerSheet

writerSheet(String) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'writerSheet'

writerSheet(Integer, String) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'writerSheet'

writerTable() - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the writerTable

writerTable(Integer) - Static method in class com.alibaba.excel.EasyExcelFactory

Build excel the 'writerTable'

WriteSheet - Class in com.alibaba.excel.write.metadata

Write sheet

WriteSheet() - Constructor for class com.alibaba.excel.write.metadata.WriteSheet

writeSheetHolder() - Method in interface com.alibaba.excel.context.WriteContext

All information about the sheet you are currently working on

writeSheetHolder() - Method in class com.alibaba.excel.context.WriteContextImpl

WriteSheetHolder - Class in com.alibaba.excel.write.metadata.holder

sheet holder

WriteSheetHolder(WriteSheet, WriteWorkbookHolder) - Constructor for class com.alibaba.excel.write.metadata.holder.WriteSheetHolder

WriteTable - Class in com.alibaba.excel.write.metadata

table

WriteTable() - Constructor for class com.alibaba.excel.write.metadata.WriteTable

writeTableHolder() - Method in interface com.alibaba.excel.context.WriteContext

All information about the table you are currently working on

writeTableHolder() - Method in class com.alibaba.excel.context.WriteContextImpl

WriteTableHolder - Class in com.alibaba.excel.write.metadata.holder

sheet holder

WriteTableHolder(WriteTable, WriteSheetHolder) - Constructor for class com.alibaba.excel.write.metadata.holder.WriteTableHolder

WriteTemplateAnalysisCellTypeEnum - Enum in com.alibaba.excel.enums

Type of template to read when writing

writeToFile(File, InputStream) - Static method in class com.alibaba.excel.util.FileUtils

Write inputStream to file

writeToFile(File, InputStream, boolean) - Static method in class com.alibaba.excel.util.FileUtils

Write inputStream to file

WriteTypeEnum - Enum in com.alibaba.excel.enums

Enumeration of write methods

WriteWorkbook - Class in com.alibaba.excel.write.metadata

Workbook

WriteWorkbook() - Constructor for class com.alibaba.excel.write.metadata.WriteWorkbook

writeWorkbookHolder() - Method in interface com.alibaba.excel.context.WriteContext

All information about the workbook you are currently working on

writeWorkbookHolder() - Method in class com.alibaba.excel.context.WriteContextImpl

WriteWorkbookHolder - Class in com.alibaba.excel.write.metadata.holder

Workbook holder

WriteWorkbookHolder(WriteWorkbook) - Constructor for class com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder

X

X_CELL_FORMULA_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

X_CELL_INLINE_STRING_VALUE_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

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

X_CELL_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

X_CELL_VALUE_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

X_DIMENSION_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

X_HYPERLINK_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

X_MERGE_CELL_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

X_ROW_TAG - Static variable in class com.alibaba.excel.constant.ExcelXmlConstants

XlsCache - Class in com.alibaba.excel.cache

Use SSTRecord.

XlsCache(SSTRecord) - Constructor for class com.alibaba.excel.cache.XlsCache

XlsListSheetListener - Class in com.alibaba.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 com.alibaba.excel.analysis.v03.XlsListSheetListener

XlsReadContext - Interface in com.alibaba.excel.context.xls

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

xlsReadSheetHolder() - Method in class com.alibaba.excel.context.xls.DefaultXlsReadContext

xlsReadSheetHolder() - Method in interface com.alibaba.excel.context.xls.XlsReadContext

All information about the sheet you are currently working on.

XlsReadSheetHolder - Class in com.alibaba.excel.read.metadata.holder.xls

sheet holder

XlsReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class com.alibaba.excel.read.metadata.holder.xls.XlsReadSheetHolder

xlsReadWorkbookHolder() - Method in class com.alibaba.excel.context.xls.DefaultXlsReadContext

xlsReadWorkbookHolder() - Method in interface com.alibaba.excel.context.xls.XlsReadContext

All information about the workbook you are currently working on.

XlsReadWorkbookHolder - Class in com.alibaba.excel.read.metadata.holder.xls

Workbook holder

XlsReadWorkbookHolder(ReadWorkbook) - Constructor for class com.alibaba.excel.read.metadata.holder.xls.XlsReadWorkbookHolder

XlsRecordHandler - Interface in com.alibaba.excel.analysis.v03

Intercepts handle xls reads.

XlsSaxAnalyser - Class in com.alibaba.excel.analysis.v03

/** * A text extractor for Excel files.

XlsSaxAnalyser(XlsReadContext) - Constructor for class com.alibaba.excel.analysis.v03.XlsSaxAnalyser

XlsxReadContext - Interface in com.alibaba.excel.context.xlsx

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

xlsxReadSheetHolder() - Method in class com.alibaba.excel.context.xlsx.DefaultXlsxReadContext

xlsxReadSheetHolder() - Method in interface com.alibaba.excel.context.xlsx.XlsxReadContext

All information about the sheet you are currently working on.

XlsxReadSheetHolder - Class in com.alibaba.excel.read.metadata.holder.xlsx

sheet holder

XlsxReadSheetHolder(ReadSheet, ReadWorkbookHolder) - Constructor for class com.alibaba.excel.read.metadata.holder.xlsx.XlsxReadSheetHolder

xlsxReadWorkbookHolder() - Method in class com.alibaba.excel.context.xlsx.DefaultXlsxReadContext

xlsxReadWorkbookHolder() - Method in interface com.alibaba.excel.context.xlsx.XlsxReadContext

All information about the workbook you are currently working on.

XlsxReadWorkbookHolder - Class in com.alibaba.excel.read.metadata.holder.xlsx

Workbook holder

XlsxReadWorkbookHolder(ReadWorkbook) - Constructor for class com.alibaba.excel.read.metadata.holder.xlsx.XlsxReadWorkbookHolder

XlsxRowHandler - Class in com.alibaba.excel.analysis.v07.handlers.sax

XlsxRowHandler(XlsxReadContext) - Constructor for class com.alibaba.excel.analysis.v07.handlers.sax.XlsxRowHandler

XlsxSaxAnalyser - Class in com.alibaba.excel.analysis.v07

XlsxSaxAnalyser(XlsxReadContext, InputStream) - Constructor for class com.alibaba.excel.analysis.v07.XlsxSaxAnalyser

xlsxSAXParserFactoryName(String) - Method in class com.alibaba.excel.read.builder.ExcelReaderBuilder

SAXParserFactory used when reading xlsx.

XlsxTagHandler - Interface in com.alibaba.excel.analysis.v07.handlers

Tag handler

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