com.alibaba.excel.read.builder
类 ExcelReaderSheetBuilder
- java.lang.Object
-
- com.alibaba.excel.read.builder.ExcelReaderSheetBuilder
public class ExcelReaderSheetBuilder extends Object
Build sheet- 作者:
- Jiaju Zhuang
-
构造器概要
构造器 构造器和说明 ExcelReaderSheetBuilder()
ExcelReaderSheetBuilder(ExcelReader excelReader)
方法概要
所有方法 实例方法 具体方法 限定符和类型 方法和说明 ExcelReaderSheetBuilder
autoTrim(Boolean autoTrim)
Automatic trim includes sheet name and contentReadSheet
build()
void
doRead()
Sax read<T> List<T>
doReadSync()
Synchronous reads return resultsExcelReaderSheetBuilder
head(Class clazz)
You can only choose one of theExcelReaderBuilder.head(List)
andExcelReaderBuilder.head(Class)
ExcelReaderSheetBuilder
head(List<List<String>> head)
You can only choose one of theExcelReaderBuilder.head(List)
andExcelReaderBuilder.head(Class)
ExcelReaderSheetBuilder
headRowNumber(Integer headRowNumber)
Count the number of added heads when read sheet.ExcelReaderSheetBuilder
registerConverter(Converter converter)
Custom type conversions override the default.ExcelReaderSheetBuilder
registerReadListener(ReadListener readListener)
Custom type listener run after defaultExcelReaderSheetBuilder
sheetName(String sheetName)
sheet nameExcelReaderSheetBuilder
sheetNo(Integer sheetNo)
Starting from 0ExcelReaderSheetBuilder
use1904windowing(Boolean use1904windowing)
true if date uses 1904 windowing, or false if using 1900 date windowing.
-
构造器详细资料
ExcelReaderSheetBuilder
public ExcelReaderSheetBuilder()
ExcelReaderSheetBuilder
public ExcelReaderSheetBuilder(ExcelReader excelReader)
方法详细资料
sheetNo
public ExcelReaderSheetBuilder sheetNo(Integer sheetNo)
Starting from 0- 参数:
-
sheetNo
- - 返回:
sheetName
public ExcelReaderSheetBuilder sheetName(String sheetName)
sheet name- 参数:
-
sheetName
- - 返回:
headRowNumber
public ExcelReaderSheetBuilder headRowNumber(Integer headRowNumber)
Count the number of added heads when read sheet.0 - This Sheet has no head ,since the first row are the data
1 - This Sheet has one row head , this is the default
2 - This Sheet has two row head ,since the third row is the data
- 参数:
-
headRowNumber
- - 返回:
head
public ExcelReaderSheetBuilder head(List<List<String>> head)
You can only choose one of theExcelReaderBuilder.head(List)
andExcelReaderBuilder.head(Class)
- 参数:
-
head
- - 返回:
head
public ExcelReaderSheetBuilder head(Class clazz)
You can only choose one of theExcelReaderBuilder.head(List)
andExcelReaderBuilder.head(Class)
- 参数:
-
clazz
- - 返回:
registerConverter
public ExcelReaderSheetBuilder registerConverter(Converter converter)
Custom type conversions override the default.- 参数:
-
converter
- - 返回:
registerReadListener
public ExcelReaderSheetBuilder registerReadListener(ReadListener readListener)
Custom type listener run after default- 参数:
-
readListener
- - 返回:
use1904windowing
public ExcelReaderSheetBuilder use1904windowing(Boolean use1904windowing)
true if date uses 1904 windowing, or false if using 1900 date windowing. default is false- 参数:
-
use1904windowing
- - 返回:
autoTrim
public ExcelReaderSheetBuilder autoTrim(Boolean autoTrim)
Automatic trim includes sheet name and content- 参数:
-
autoTrim
- - 返回:
build
public ReadSheet build()
doRead
public void doRead()
Sax read
doReadSync
public <T> List<T> doReadSync()
Synchronous reads return results- 返回:
Copyright © 2018–2019 Alibaba Group. All rights reserved.