Index (ExcelUtil 1.0.6 API)

A C D E F G H I J L M N P R S T V W X
All Classes All Packages

A

addValidationData(XSSFSheet, int, int, int, int, XSSFDataValidationHelper, DataValidationConstraint) - Method in class com.github.tonyluo.excel.util.CellConstraint
align() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell: 水平对齐方式

C

CellConstraint - Class in com.github.tonyluo.excel.util
CellConstraint() - Constructor for class com.github.tonyluo.excel.util.CellConstraint
col() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell
colSplit() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet: colSplit Horizontal position of split.
columnIndex2Name(int) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
columnName2Index(String) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
com.github.tonyluo.excel - package com.github.tonyluo.excel
com.github.tonyluo.excel.annotation - package com.github.tonyluo.excel.annotation
com.github.tonyluo.excel.util - package com.github.tonyluo.excel.util
comment() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell: 单元格备注
constraintClass() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell
createConstraint(XSSFSheet, int, int, int, int) - Method in class com.github.tonyluo.excel.util.CellConstraint

D

dateFormat() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell: 时间格式化，日期类型时生效

E

EMPTY - Static variable in class com.github.tonyluo.excel.util.StringUtils: The empty String "".
ExcelCell - Annotation Type in com.github.tonyluo.excel.annotation: 实体字段与excel列号关联的注解
ExcelConverter - Class in com.github.tonyluo.excel.util: Usage: check Testcase ExcelConverterTest.java for detail
ExcelConverter() - Constructor for class com.github.tonyluo.excel.util.ExcelConverter
ExcelSheet - Annotation Type in com.github.tonyluo.excel.annotation: 表信息
ExcelUtil - Class in com.github.tonyluo.excel
ExcelUtil() - Constructor for class com.github.tonyluo.excel.ExcelUtil
exportToBytes(List<T>) - Static method in class com.github.tonyluo.excel.ExcelUtil: 导出Excel字节数据
exportToFile(String, List<T>) - Static method in class com.github.tonyluo.excel.ExcelUtil: 导出Excel文件到磁盘

F

FieldParser - Class in com.github.tonyluo.excel.util
format() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell: format: "#,##0.0000"
formatValue(Field, Object) - Static method in class com.github.tonyluo.excel.util.FieldParser: 参数格式化为String

G

generateWorkbook(List<T>) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
getAndFormatCellValue(Object) - Method in class com.github.tonyluo.excel.util.CellConstraint
getBeanListFromWorkBook(Workbook, Class<T>, int) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
getBeanListFromWorkBook(Workbook, Class<T>, int, int) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
getBeanListFromWorkBook(Workbook, Class<T>, int, int, int) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
getExplicitListValues() - Method in class com.github.tonyluo.excel.util.CellConstraint
getInstance(String) - Static method in class com.github.tonyluo.excel.util.CellConstraint
getRowByBean(T) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
getRowHeaderByClass(Class<T>) - Static method in class com.github.tonyluo.excel.util.ExcelConverter

H

headColor() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet: 表头/首行的颜色
hidden() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell

I

importExcel(Workbook, Class<T>, int, int, int) - Static method in class com.github.tonyluo.excel.ExcelUtil
importFromFile(File, Class<T>) - Static method in class com.github.tonyluo.excel.ExcelUtil
importFromFile(File, Class<T>, int) - Static method in class com.github.tonyluo.excel.ExcelUtil
importFromInputStream(InputStream, Class<T>) - Static method in class com.github.tonyluo.excel.ExcelUtil
importFromInputStream(InputStream, Class<T>, int) - Static method in class com.github.tonyluo.excel.ExcelUtil
importFromPath(String, Class<T>) - Static method in class com.github.tonyluo.excel.ExcelUtil
importFromPath(String, Class<T>, int) - Static method in class com.github.tonyluo.excel.ExcelUtil
IS_JAVA_1_6 - Static variable in class com.github.tonyluo.excel.util.NumberUtils
isBlank(CharSequence) - Static method in class com.github.tonyluo.excel.util.StringUtils: Checks if a CharSequence is empty (""), null or whitespace only.
isCreatable(String) - Static method in class com.github.tonyluo.excel.util.NumberUtils: Checks whether the String a valid Java number.
isEmpty(CharSequence) - Static method in class com.github.tonyluo.excel.util.StringUtils: Checks if a CharSequence is empty ("") or null.
isNotBlank(CharSequence) - Static method in class com.github.tonyluo.excel.util.StringUtils: Checks if a CharSequence is not empty (""), not null and not whitespace only.
isNotEmpty(CharSequence) - Static method in class com.github.tonyluo.excel.util.StringUtils: Checks if a CharSequence is not empty ("") and not null.

J

JAVA_SPECIFICATION_VERSION - Static variable in class com.github.tonyluo.excel.util.NumberUtils

L

leftmostColumn() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet
locked() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell: //注：要锁定单元格需先为此表单设置保护密码，设置之后此表单默认为所有单元格锁定，可使用setLocked(false)为指定单元格设置不锁定。

M

main1(String[]) - Static method in class com.github.tonyluo.excel.XLSX2CSV

N

name() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell
name() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet: 表名称
notice() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet
NumberUtils - Class in com.github.tonyluo.excel.util: copy from org.apache.commons.lang3.math.NumberUtils
NumberUtils() - Constructor for class com.github.tonyluo.excel.util.NumberUtils

P

parseBoolean(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseByte(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseDate(String, ExcelCell) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseDouble(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseFloat(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseInstant(String, ExcelCell) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseInstantFromString(String, ExcelCell) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseInt(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseLong(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseShort(String) - Static method in class com.github.tonyluo.excel.util.FieldParser
parseValue(Field, Object) - Static method in class com.github.tonyluo.excel.util.FieldParser: 参数解析（支持：Byte、Boolean、String、Short、Integer、Long、Float、Double、Date）
process() - Method in class com.github.tonyluo.excel.XLSX2CSV: Initiates the processing of the XLS workbook file to CSV.
processSheet(Styles, SharedStrings, XSSFSheetXMLHandler.SheetContentsHandler, InputStream) - Method in class com.github.tonyluo.excel.XLSX2CSV: Parses and shows the content of one sheet using the specified styles and shared-strings tables.
protectSheet() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet
protectSheetPassword() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet

R

readFile(File) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
readFile(String) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
readFromInputStream(InputStream) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
readXSSFWorkbookFromInputStream(InputStream) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
required() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell
rowSplit() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet

S

setAndFormatCellValue(Cell, Object) - Method in class com.github.tonyluo.excel.util.CellConstraint
setRowWithBean(Workbook, XSSFSheet, Row, T, boolean) - Static method in class com.github.tonyluo.excel.util.ExcelConverter
StringUtils - Class in com.github.tonyluo.excel.util: copy from org.apache.commons.lang3.StringUtils
StringUtils() - Constructor for class com.github.tonyluo.excel.util.StringUtils

T

topRow() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelSheet
trimToEmpty(String) - Static method in class com.github.tonyluo.excel.util.StringUtils: Removes control characters (char <= 32) from both ends of this String returning an empty String ("") if the String is empty ("") after the trim or if it is null.
Type() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell

V

validation() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell

W

width() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell: 列宽 (大于0时生效; 如果不指定列宽，将会自适应调整宽度；) Set the width (character width)
wrapText() - Method in annotation type com.github.tonyluo.excel.annotation.ExcelCell

X

XLSX2CSV - Class in com.github.tonyluo.excel: A rudimentary XLSX -> CSV processor modeled on the POI sample program XLS2CSVmra from the package org.apache.poi.hssf.eventusermodel.examples.
XLSX2CSV(OPCPackage, PrintStream, int) - Constructor for class com.github.tonyluo.excel.XLSX2CSV: Creates a new XLSX -> CSV examples

A C D E F G H I J L M N P R S T V W X
All Classes All Packages