Excels (orion-kit 2.0.1 API)

java.lang.Object
- cn.orionsec.kit.office.excel.Excels

```
public class Excels
extends Object
```
excel 工具类

Since:

2020/4/6 15:50

Version:

1.0.0

Author:

Jiahang Li

Method Summary

All Methods Static Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`static void`	`addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet, int startRow, int endRow, int startColumn, int endColumn, String[] options)` 添加下拉框
`static void`	`addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet, int startRow, int endRow, int column, String[] options)` 添加下拉框
`static void`	`addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet, int startRow, int column, String[] options)` 添加下拉框
`static void`	`addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet, int column, String[] options)` 添加下拉框
`static void`	`close(org.apache.poi.ss.usermodel.Workbook workbook)` 关闭workbook
`static void`	`copyCellValue(org.apache.poi.ss.usermodel.Cell source, org.apache.poi.ss.usermodel.Cell target)` 复制cell的值
`static SheetCopier`	`copySheet(org.apache.poi.ss.usermodel.Workbook resourceWorkbook, org.apache.poi.ss.usermodel.Workbook targetWorkbook, int resourceIndex)` 复制sheet 新建sheet
`static SheetCopier`	`copySheet(org.apache.poi.ss.usermodel.Workbook resourceWorkbook, org.apache.poi.ss.usermodel.Workbook targetWorkbook, int resourceIndex, int targetIndex)` 复制sheet 如果未找到目标sheet 则新建sheet
`static org.apache.poi.ss.usermodel.Comment`	`createComment(org.apache.poi.ss.usermodel.Sheet sheet, int column, int row, CommentOption option)` 创建批注
`static org.apache.poi.ss.usermodel.Comment`	`createComment(org.apache.poi.ss.usermodel.Sheet sheet, int column, int row, String comment)` 创建批注
`static PictureParser`	`createPictureParser(org.apache.poi.ss.usermodel.Sheet sheet)` 创建图片解析器
`static PictureParser`	`createPictureParser(org.apache.poi.ss.usermodel.Workbook workbook, int index)` 创建图片解析器
`static PictureParser`	`createPictureParser(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet)` 创建图片解析器
`static void`	`filterFirstRow(org.apache.poi.ss.usermodel.Sheet sheet)` 筛选首行
`static void`	`filterFirstRow(org.apache.poi.ss.usermodel.Sheet sheet, int lastColumn)` 筛选首行
`static void`	`filterFirstRow(org.apache.poi.ss.usermodel.Sheet sheet, int firstColumn, int lastColumn)` 筛选首行
`static void`	`filterRow(org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex)` 筛选行
`static void`	`filterRow(org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex, int lastColumn)` 筛选行
`static void`	`filterRow(org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex, int firstColumn, int lastColumn)` 筛选行
`static void`	`freezeFirstRow(org.apache.poi.ss.usermodel.Sheet sheet)` 冻结首行
`static void`	`freezeRow(org.apache.poi.ss.usermodel.Sheet sheet, int lastRow)` 冻结行
`static org.apache.poi.ss.usermodel.Cell`	`getCell(org.apache.poi.ss.usermodel.Sheet sheet, int row, int column)` 获取单元格 (可能为null)
`static String`	`getCellComment(org.apache.poi.ss.usermodel.Cell cell)` 获取批注
`static Date`	`getCellDate(org.apache.poi.ss.usermodel.Cell cell)` 获取时间
`static Date`	`getCellDate(org.apache.poi.ss.usermodel.Cell cell, CellOption option)` 获取时间
`static Date`	`getCellDate(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.CellType type, CellOption option)` 获取时间
`static BigDecimal`	`getCellDecimal(org.apache.poi.ss.usermodel.Cell cell)` 获取数字
`static BigDecimal`	`getCellDecimal(org.apache.poi.ss.usermodel.Cell cell, CellOption option)` 获取数字
`static BigDecimal`	`getCellDecimal(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.CellType type, CellOption option)` 获取数字
`static String`	`getCellHyperUrl(org.apache.poi.ss.usermodel.Cell cell)` 获取超链接
`static Integer`	`getCellInteger(org.apache.poi.ss.usermodel.Cell cell)` 获取数字
`static Integer`	`getCellInteger(org.apache.poi.ss.usermodel.Cell cell, CellOption option)` 获取数字
`static Integer`	`getCellInteger(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.CellType type, CellOption option)` 获取数字
`static Long`	`getCellLong(org.apache.poi.ss.usermodel.Cell cell)` 获取数字
`static Long`	`getCellLong(org.apache.poi.ss.usermodel.Cell cell, CellOption option)` 获取数字
`static Long`	`getCellLong(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.CellType type, CellOption option)` 获取数字
`static org.apache.poi.ss.usermodel.Cell`	`getCellMerge(org.apache.poi.ss.usermodel.Sheet sheet, int row, int column)` 获取单元格如果是合并则获取合并后的
`static String`	`getCellPhone(org.apache.poi.ss.usermodel.Cell cell)` 获取手机号
`static String`	`getCellPhone(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.CellType type)` 获取手机号
`static org.apache.poi.ss.usermodel.CellStyle`	`getCellStyle(org.apache.poi.ss.usermodel.Sheet sheet, int row, int column)` 获取单元格样式 (可能为null)
`static String`	`getCellValue(org.apache.poi.ss.usermodel.Cell cell)` 获取String的值
`static String`	`getCellValue(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.CellType type)` 获取String的值
`static <T> T`	`getCellValue(org.apache.poi.ss.usermodel.Cell cell, ExcelReadType type)` 通过类型获取值
`static <T> T`	`getCellValue(org.apache.poi.ss.usermodel.Cell cell, ExcelReadType type, CellOption option)` 通过类型获取值
`static org.apache.poi.xssf.usermodel.XSSFColor`	`getColor(String rgb)` 获取颜色
`static int`	`getColumnCount(org.apache.poi.ss.usermodel.Sheet sheet)` 获取列数
`static int`	`getColumnCount(org.apache.poi.ss.usermodel.Sheet sheet, int rowNum)` 获取列数
`static int`	`getColumnNumber(String s)` 获取列对应的数值 A -> 1 Z -> 26 AA -> 27
`static String`	`getColumnSymbol(int column)` 获取数值对应的列 1 -> A 26 -> Z 27 -> AA
`static ExcelFieldType`	`getFieldType(Class<?> clazz)` 获取字段类型
`static ExcelFieldType`	`getFieldType(Object o)` 获取字段类型
`static FooterOption`	`getFooter(org.apache.poi.ss.usermodel.Sheet sheet)` 获取页脚
`static HeaderOption`	`getHeader(org.apache.poi.ss.usermodel.Sheet sheet)` 获取页眉
`static int`	`getPhysicalRowCount(org.apache.poi.ss.usermodel.Sheet sheet)` 获取实际总行数 (不全)
`static PropertiesOption`	`getProperties(org.apache.poi.ss.usermodel.Workbook workbook)` 获取属性
`static org.apache.poi.ss.usermodel.Row`	`getRow(org.apache.poi.ss.usermodel.Sheet sheet, int index)` 获取行 (可能为null)
`static int`	`getRowCount(org.apache.poi.ss.usermodel.Sheet sheet)` 获取最后一行的位置 (索引+1 但有可能行为空)
`static org.apache.poi.ss.usermodel.CellStyle`	`getRowStyle(org.apache.poi.ss.usermodel.Sheet sheet, int index)` 获取行样式 (可能为null)
`static byte[]`	`getThumbnail(org.apache.poi.ss.usermodel.Workbook workbook)` 获取缩略图
`static int`	`getWidth(double width)` 获取 poi 的 width
`static int`	`getWidth(int width)` 获取 poi 的 width
`static boolean`	`isStreamingSheet(Class<?> clazz)` 是否为流式读取的sheet
`static boolean`	`isStreamingSheet(org.apache.poi.ss.usermodel.Sheet sheet)` 是否为流式读取的sheet
`static boolean`	`isStreamingWorkbook(Class<?> clazz)` 是否为流式读取的workbook
`static boolean`	`isStreamingWorkbook(org.apache.poi.ss.usermodel.Workbook workbook)` 是否为流式读取的workbook
`static void`	`mergeCell(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellRangeAddress region)` 合并单元格
`static void`	`mergeCell(org.apache.poi.ss.usermodel.Sheet sheet, int row, int firstColumn, int lastColumn)` 合并单元格
`static void`	`mergeCell(org.apache.poi.ss.usermodel.Sheet sheet, int firstRow, int lastRow, int firstColumn, int lastColumn)` 合并单元格
`static void`	`mergeCellBorder(org.apache.poi.ss.usermodel.Sheet sheet, int borderCode, int colorIndex, org.apache.poi.ss.util.CellRangeAddress region)` 合并单元格边框
`static void`	`mergeCellBorder(org.apache.poi.ss.usermodel.Sheet sheet, int borderCode, int colorIndex, int row, int firstColumn, int lastColumn)` 合并单元格边框
`static void`	`mergeCellBorder(org.apache.poi.ss.usermodel.Sheet sheet, int borderCode, int colorIndex, int firstRow, int lastRow, int firstColumn, int lastColumn)` 合并单元格边框
`static org.apache.poi.ss.util.CellRangeAddress`	`mergeCellRange(int row, int firstColumn, int lastColumn)` 合并单元格
`static org.apache.poi.ss.util.CellRangeAddress`	`mergeCellRange(int firstRow, int lastRow, int firstColumn, int lastColumn)` 合并单元格
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(File file)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(File file, int rowCache)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(File file, int rowCache, int bufferSize)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(File file, String password)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(File file, String password, int rowCache)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(File file, String password, int rowCache, int bufferSize)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(InputStream in)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(InputStream in, int rowCache)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(InputStream in, int rowCache, int bufferSize)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(InputStream in, String password)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(InputStream in, String password, int rowCache)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(InputStream in, String password, int rowCache, int bufferSize)` 获取流式workbook
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(String file)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(String file, int rowCache)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(String file, int rowCache, int bufferSize)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(String file, String password)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(String file, String password, int rowCache)`
`static org.apache.poi.ss.usermodel.Workbook`	`openStreamingWorkbook(String file, String password, int rowCache, int bufferSize)`
`static org.apache.poi.ss.usermodel.Workbook`	`openWorkbook(File file)`
`static org.apache.poi.ss.usermodel.Workbook`	`openWorkbook(File file, String password)`
`static org.apache.poi.ss.usermodel.Workbook`	`openWorkbook(InputStream in)`
`static org.apache.poi.ss.usermodel.Workbook`	`openWorkbook(InputStream in, String password)` 获取workbook
`static org.apache.poi.ss.usermodel.Workbook`	`openWorkbook(String file)`
`static org.apache.poi.ss.usermodel.Workbook`	`openWorkbook(String file, String password)`
`static short`	`paletteColor(org.apache.poi.ss.usermodel.Workbook workbook, short index, byte[] rgb)` 调色板主要用与 HSSFColor
`static short`	`paletteColor(org.apache.poi.ss.usermodel.Workbook workbook, short index, String rgb)` 调色板主要用与 HSSFColor
`static org.apache.poi.ss.usermodel.CellStyle`	`parseColumnStyle(org.apache.poi.ss.usermodel.Workbook workbook, ExportFieldOption option)` 解析列样式
`static org.apache.poi.ss.usermodel.Font`	`parseFont(org.apache.poi.ss.usermodel.Workbook workbook, FontOption option)` 解析字体
`static org.apache.poi.ss.usermodel.PrintSetup`	`parsePrint(org.apache.poi.ss.usermodel.Sheet sheet, PrintOption option)` 解析打印
`static org.apache.poi.ss.usermodel.CellStyle`	`parseStyle(org.apache.poi.ss.usermodel.Workbook workbook, ExportFieldOption option)` 解析样式
`static org.apache.poi.ss.usermodel.CellStyle`	`parseTitleStyle(org.apache.poi.ss.usermodel.Workbook workbook, TitleOption option)` 解析标题样式
`static void`	`setCellValue(org.apache.poi.ss.usermodel.Cell cell, Object value)` 设置cell的值
`static void`	`setCellValue(org.apache.poi.ss.usermodel.Cell cell, Object value, ExcelFieldType type)` 设置cell的值
`static void`	`setCellValue(org.apache.poi.ss.usermodel.Cell cell, Object value, ExcelFieldType type, CellOption option)` 设置cell的值
`static void`	`setDefaultProperties(org.apache.poi.ss.usermodel.Workbook workbook)` 设置默认配置属性
`static void`	`setFooter(org.apache.poi.ss.usermodel.Sheet sheet, FooterOption option)` 获取页脚
`static void`	`setHeader(org.apache.poi.ss.usermodel.Sheet sheet, HeaderOption option)` 设置页眉
`static void`	`setLink(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Cell cell, ExcelLinkType linkType, String address, ExcelFieldType textType, CellOption option, Object text)` 设置超链接
`static void`	`setLink(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Cell cell, ExcelLinkType linkType, String address, ExcelFieldType textType, Object text)` 设置超链接
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, byte[] image, int rowIndex, int columnIndex)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, byte[] image, int rowIndex, int columnIndex, ExcelPictureType type)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, byte[] image, int rowIndex, int columnIndex, String fileName)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, byte[] image, int rowIndex, int columnIndex, String fileName, ExcelPictureType type)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, File image, int rowIndex, int columnIndex)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, File image, int rowIndex, int columnIndex, ExcelPictureType type)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, File image, int rowIndex, int columnIndex, String fileName)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, InputStream image, int rowIndex, int columnIndex)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, InputStream image, int rowIndex, int columnIndex, ExcelPictureType type)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, InputStream image, int rowIndex, int columnIndex, String fileName)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, String image, int rowIndex, int columnIndex)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, String image, int rowIndex, int columnIndex, ExcelPictureType type)` 添加图片
`static org.apache.poi.ss.usermodel.Picture`	`setPicture(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, String image, int rowIndex, int columnIndex, String fileName)` 添加图片
`static void`	`setProperties(org.apache.poi.ss.usermodel.Workbook workbook, PropertiesOption option)` 设置属性
`static void`	`setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook, byte[] thumbnail)` 设置缩略图
`static void`	`setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook, byte[] thumbnail, String fileName)` Deprecated. XLS 设置写入会报错
`static void`	`setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook, File thumbnail)` 设置缩略图
`static void`	`setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook, InputStream thumbnail)` 设置缩略图
`static void`	`setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook, InputStream thumbnail, String fileName)` 设置缩略图
`static void`	`setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook, String thumbnail)` 设置缩略图
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, File file)`
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, File file, String password)`
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, OutputStream out)`
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, OutputStream out, boolean close)` 写入workbook到流
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, OutputStream out, String password)`
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, OutputStream out, String password, boolean close)` 写入workbook到流
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, String file)`
`static void`	`write(org.apache.poi.ss.usermodel.Workbook workbook, String file, String password)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getColumnNumber
```
public static int getColumnNumber(String s)
```
获取列对应的数值 A -> 1 Z -> 26 AA -> 27

Parameters:

s - 列

Returns:

number

getColumnSymbol
```
public static String getColumnSymbol(int column)
```
获取数值对应的列 1 -> A 26 -> Z 27 -> AA

Parameters:

column - 列

Returns:

symbol

getWidth
```
public static int getWidth(int width)
```
获取 poi 的 width

Parameters:

width - width

Returns:

poi width

getWidth
```
public static int getWidth(double width)
```
获取 poi 的 width

Parameters:

width - width

Returns:

poi width

getCellValue

public static <T> T getCellValue(org.apache.poi.ss.usermodel.Cell cell,
                                 ExcelReadType type)

通过类型获取值

Type Parameters:: T - T
Parameters:: cell - cell; type - type 不包含picture
Returns:: value

getCellValue

public static <T> T getCellValue(org.apache.poi.ss.usermodel.Cell cell,
                                 ExcelReadType type,
                                 CellOption option)

通过类型获取值

Type Parameters:: T - T
Parameters:: cell - cell; type - type; option - option
Returns:: value
See Also:: 可能为null, 可能为null, 可能为null, 可能为null, 可能为null, 可能为null, 为null, 不为null, 不为null

getCellValue

public static String getCellValue(org.apache.poi.ss.usermodel.Cell cell)

获取String的值

Parameters:: cell - cell
Returns:: value

getCellValue

public static String getCellValue(org.apache.poi.ss.usermodel.Cell cell,
                                  org.apache.poi.ss.usermodel.CellType type)

获取String的值

Parameters:: cell - cell; type - type
Returns:: value

getCellDecimal

public static BigDecimal getCellDecimal(org.apache.poi.ss.usermodel.Cell cell)

获取数字

Parameters:: cell - cell
Returns:: BigDecimal

getCellDecimal

public static BigDecimal getCellDecimal(org.apache.poi.ss.usermodel.Cell cell,
                                        CellOption option)

获取数字

Parameters:: cell - cell; option - option
Returns:: BigDecimal

getCellDecimal

public static BigDecimal getCellDecimal(org.apache.poi.ss.usermodel.Cell cell,
                                        org.apache.poi.ss.usermodel.CellType type,
                                        CellOption option)

获取数字

Parameters:: cell - cell; type - type; option - option
Returns:: BigDecimal

getCellInteger

public static Integer getCellInteger(org.apache.poi.ss.usermodel.Cell cell)

获取数字

Parameters:: cell - cell
Returns:: Integer

getCellInteger

public static Integer getCellInteger(org.apache.poi.ss.usermodel.Cell cell,
                                     CellOption option)

获取数字

Parameters:: cell - cell; option - option
Returns:: Integer

getCellInteger

public static Integer getCellInteger(org.apache.poi.ss.usermodel.Cell cell,
                                     org.apache.poi.ss.usermodel.CellType type,
                                     CellOption option)

获取数字

Parameters:: cell - cell; type - type; option - option
Returns:: BigDecimal

getCellLong

public static Long getCellLong(org.apache.poi.ss.usermodel.Cell cell)

获取数字

Parameters:: cell - cell
Returns:: Long

getCellLong

public static Long getCellLong(org.apache.poi.ss.usermodel.Cell cell,
                               CellOption option)

获取数字

Parameters:: cell - cell; option - option
Returns:: Long

getCellLong

public static Long getCellLong(org.apache.poi.ss.usermodel.Cell cell,
                               org.apache.poi.ss.usermodel.CellType type,
                               CellOption option)

获取数字

Parameters:: cell - cell; type - type; option - option
Returns:: Long

getCellDate

public static Date getCellDate(org.apache.poi.ss.usermodel.Cell cell)

获取时间

Parameters:: cell - cell
Returns:: 时间

getCellDate

public static Date getCellDate(org.apache.poi.ss.usermodel.Cell cell,
                               CellOption option)

获取时间

Parameters:: cell - cell; option - option
Returns:: 时间

getCellDate

public static Date getCellDate(org.apache.poi.ss.usermodel.Cell cell,
                               org.apache.poi.ss.usermodel.CellType type,
                               CellOption option)

获取时间

Parameters:: cell - cell; type - type; option - option
Returns:: 时间

getCellPhone

public static String getCellPhone(org.apache.poi.ss.usermodel.Cell cell)

获取手机号

Parameters:: cell - cell
Returns:: 手机号

getCellPhone

public static String getCellPhone(org.apache.poi.ss.usermodel.Cell cell,
                                  org.apache.poi.ss.usermodel.CellType type)

获取手机号

Parameters:: cell - cell
Returns:: 手机号

getCellComment

public static String getCellComment(org.apache.poi.ss.usermodel.Cell cell)

获取批注

Parameters:: cell - cell
Returns:: 批注

getCellHyperUrl

public static String getCellHyperUrl(org.apache.poi.ss.usermodel.Cell cell)

获取超链接

Parameters:: cell - cell
Returns:: 超链接url

getRow

public static org.apache.poi.ss.usermodel.Row getRow(org.apache.poi.ss.usermodel.Sheet sheet,
                                                     int index)

获取行 (可能为null)

Parameters:: sheet - sheet; index - index
Returns:: row

getRowStyle

public static org.apache.poi.ss.usermodel.CellStyle getRowStyle(org.apache.poi.ss.usermodel.Sheet sheet,
                                                                int index)

获取行样式 (可能为null)

Parameters:: sheet - sheet; index - index
Returns:: row

getCell

public static org.apache.poi.ss.usermodel.Cell getCell(org.apache.poi.ss.usermodel.Sheet sheet,
                                                       int row,
                                                       int column)

获取单元格 (可能为null)

Parameters:: sheet - sheet; row - rowIndex; column - columnIndex
Returns:: cell

getCellStyle

public static org.apache.poi.ss.usermodel.CellStyle getCellStyle(org.apache.poi.ss.usermodel.Sheet sheet,
                                                                 int row,
                                                                 int column)

获取单元格样式 (可能为null)

Parameters:: sheet - sheet; row - rowIndex; column - columnIndex
Returns:: cell

getCellMerge

public static org.apache.poi.ss.usermodel.Cell getCellMerge(org.apache.poi.ss.usermodel.Sheet sheet,
                                                            int row,
                                                            int column)

获取单元格如果是合并则获取合并后的

Parameters:: sheet - sheet; row - rowIndex; column - columnIndex
Returns:: cell

getFieldType
```
public static ExcelFieldType getFieldType(Object o)
```
获取字段类型

Parameters:

o - object

See Also:

ExcelFieldType

getFieldType
```
public static ExcelFieldType getFieldType(Class<?> clazz)
```
获取字段类型

Parameters:

clazz - clazz

See Also:

ExcelFieldType

setCellValue

public static void setCellValue(org.apache.poi.ss.usermodel.Cell cell,
                                Object value)

设置cell的值

Parameters:: cell - cell; value - value

setCellValue

public static void setCellValue(org.apache.poi.ss.usermodel.Cell cell,
                                Object value,
                                ExcelFieldType type)

设置cell的值

Parameters:: cell - cell; value - value; type - type

setCellValue

public static void setCellValue(org.apache.poi.ss.usermodel.Cell cell,
                                Object value,
                                ExcelFieldType type,
                                CellOption option)

设置cell的值

Parameters:: cell - cell; value - value; type - type; option - 参数

copyCellValue

public static void copyCellValue(org.apache.poi.ss.usermodel.Cell source,
                                 org.apache.poi.ss.usermodel.Cell target)

复制cell的值

Parameters:: source - 原始; target - 目标

getRowCount
```
public static int getRowCount(org.apache.poi.ss.usermodel.Sheet sheet)
```
获取最后一行的位置 (索引+1 但有可能行为空)

Parameters:

sheet - sheet

Returns:

总行数

getPhysicalRowCount
```
public static int getPhysicalRowCount(org.apache.poi.ss.usermodel.Sheet sheet)
```
获取实际总行数 (不全)

Parameters:

sheet - sheet

Returns:

总行数

getColumnCount

public static int getColumnCount(org.apache.poi.ss.usermodel.Sheet sheet)

获取列数

Parameters:: sheet - sheet
Returns:: 列数

getColumnCount

public static int getColumnCount(org.apache.poi.ss.usermodel.Sheet sheet,
                                 int rowNum)

获取列数

Parameters:: sheet - sheet; rowNum - 行索引
Returns:: 列数

getColor

public static org.apache.poi.xssf.usermodel.XSSFColor getColor(String rgb)

获取颜色

Parameters:: rgb - rgb
Returns:: xssf color

paletteColor

public static short paletteColor(org.apache.poi.ss.usermodel.Workbook workbook,
                                 short index,
                                 String rgb)

调色板主要用与 HSSFColor

Parameters:: index - index; rgb - color
Returns:: colorIndex

paletteColor

public static short paletteColor(org.apache.poi.ss.usermodel.Workbook workbook,
                                 short index,
                                 byte[] rgb)

调色板主要用与 HSSFColor

Parameters:: index - index; rgb - color
Returns:: colorIndex

createPictureParser

public static PictureParser createPictureParser(org.apache.poi.ss.usermodel.Sheet sheet)

创建图片解析器

Parameters:: sheet - sheet
Returns:: PictureParser

createPictureParser

public static PictureParser createPictureParser(org.apache.poi.ss.usermodel.Workbook workbook,
                                                int index)

创建图片解析器

Parameters:: workbook - workbook; index - sheetIndex
Returns:: PictureParser

createPictureParser

public static PictureParser createPictureParser(org.apache.poi.ss.usermodel.Workbook workbook,
                                                org.apache.poi.ss.usermodel.Sheet sheet)

创建图片解析器

Parameters:: workbook - workbook; sheet - sheet
Returns:: PictureParser

getThumbnail

public static byte[] getThumbnail(org.apache.poi.ss.usermodel.Workbook workbook)

获取缩略图

Parameters:: workbook - workbook
Returns:: 缩略图

setThumbnail

public static void setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook,
                                File thumbnail)

设置缩略图

Parameters:: workbook - workbook; thumbnail - 缩略图

setThumbnail

public static void setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook,
                                String thumbnail)

设置缩略图

Parameters:: workbook - workbook; thumbnail - 缩略图

setThumbnail

public static void setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook,
                                InputStream thumbnail)

设置缩略图

Parameters:: workbook - workbook; thumbnail - 缩略图

setThumbnail

public static void setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook,
                                byte[] thumbnail)

设置缩略图

Parameters:: workbook - workbook; thumbnail - 缩略图

setThumbnail

public static void setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook,
                                InputStream thumbnail,
                                String fileName)

设置缩略图

Parameters:: workbook - workbook; thumbnail - 缩略图; fileName - 文件名

setThumbnail

public static void setThumbnail(org.apache.poi.ss.usermodel.Workbook workbook,
                                byte[] thumbnail,
                                String fileName)

Deprecated. XLS 设置写入会报错

设置缩略图

Parameters:: workbook - workbook; thumbnail - 缩略图; fileName - 文件名
See Also:: 519

getProperties

public static PropertiesOption getProperties(org.apache.poi.ss.usermodel.Workbook workbook)

获取属性

Parameters:: workbook - workbook
Returns:: 属性

setProperties

public static void setProperties(org.apache.poi.ss.usermodel.Workbook workbook,
                                 PropertiesOption option)

设置属性

Parameters:: workbook - workbook; option - 属性

setDefaultProperties

public static void setDefaultProperties(org.apache.poi.ss.usermodel.Workbook workbook)

设置默认配置属性

Parameters:: workbook - workbook

getHeader

public static HeaderOption getHeader(org.apache.poi.ss.usermodel.Sheet sheet)

获取页眉

Parameters:: sheet - sheet
Returns:: 页眉

setHeader

public static void setHeader(org.apache.poi.ss.usermodel.Sheet sheet,
                             HeaderOption option)

设置页眉

Parameters:: sheet - sheet; option - 页眉

getFooter

public static FooterOption getFooter(org.apache.poi.ss.usermodel.Sheet sheet)

获取页脚

Parameters:: sheet - sheet
Returns:: 页脚

setFooter

public static void setFooter(org.apache.poi.ss.usermodel.Sheet sheet,
                             FooterOption option)

获取页脚

Parameters:: sheet - sheet; option - 页脚

createComment

public static org.apache.poi.ss.usermodel.Comment createComment(org.apache.poi.ss.usermodel.Sheet sheet,
                                                                int column,
                                                                int row,
                                                                String comment)

创建批注

Parameters:: sheet - sheet; column - 列索引; row - 行索引; comment - 批注
Returns:: 批注

createComment

public static org.apache.poi.ss.usermodel.Comment createComment(org.apache.poi.ss.usermodel.Sheet sheet,
                                                                int column,
                                                                int row,
                                                                CommentOption option)

创建批注

Parameters:: sheet - sheet; column - 列索引; row - 行索引; option - 批注
Returns:: 批注

parseStyle

public static org.apache.poi.ss.usermodel.CellStyle parseStyle(org.apache.poi.ss.usermodel.Workbook workbook,
                                                               ExportFieldOption option)

解析样式

Parameters:: workbook - workbook; option - option

parseColumnStyle

public static org.apache.poi.ss.usermodel.CellStyle parseColumnStyle(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                     ExportFieldOption option)

解析列样式

Parameters:: workbook - workbook; option - option

parseTitleStyle

public static org.apache.poi.ss.usermodel.CellStyle parseTitleStyle(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                    TitleOption option)

解析标题样式

Parameters:: workbook - workbook; option - option

parseFont

public static org.apache.poi.ss.usermodel.Font parseFont(org.apache.poi.ss.usermodel.Workbook workbook,
                                                         FontOption option)

解析字体

Parameters:: workbook - workbook; option - option
Returns:: font

parsePrint

public static org.apache.poi.ss.usermodel.PrintSetup parsePrint(org.apache.poi.ss.usermodel.Sheet sheet,
                                                                PrintOption option)

解析打印

Parameters:: sheet - sheet; option - option
Returns:: PrintSetup

setLink

public static void setLink(org.apache.poi.ss.usermodel.Workbook workbook,
                           org.apache.poi.ss.usermodel.Cell cell,
                           ExcelLinkType linkType,
                           String address,
                           ExcelFieldType textType,
                           Object text)

设置超链接

Parameters:: workbook - workbook; cell - cell; linkType - 链接类型; address - 链接地址; textType - 文本类型; text - 文本

setLink

public static void setLink(org.apache.poi.ss.usermodel.Workbook workbook,
                           org.apache.poi.ss.usermodel.Cell cell,
                           ExcelLinkType linkType,
                           String address,
                           ExcelFieldType textType,
                           CellOption option,
                           Object text)

设置超链接

Parameters:: workbook - workbook; cell - cell; linkType - 链接类型; address - 链接地址; textType - 文本类型; text - 文本

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             File image,
                                                             int rowIndex,
                                                             int columnIndex)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             File image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             String fileName)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; fileName - 文件名
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             File image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             ExcelPictureType type)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; type - 文件类型
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             String image,
                                                             int rowIndex,
                                                             int columnIndex)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             String image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             String fileName)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; fileName - 文件名
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             String image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             ExcelPictureType type)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; type - 文件类型
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             InputStream image,
                                                             int rowIndex,
                                                             int columnIndex)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             InputStream image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             String fileName)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; fileName - 文件名
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             InputStream image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             ExcelPictureType type)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; type - 文件类型
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             byte[] image,
                                                             int rowIndex,
                                                             int columnIndex)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             byte[] image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             String fileName)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; fileName - 文件名
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             byte[] image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             ExcelPictureType type)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; type - 文件类型
Returns:: Picture

setPicture

public static org.apache.poi.ss.usermodel.Picture setPicture(org.apache.poi.ss.usermodel.Workbook workbook,
                                                             org.apache.poi.ss.usermodel.Sheet sheet,
                                                             byte[] image,
                                                             int rowIndex,
                                                             int columnIndex,
                                                             String fileName,
                                                             ExcelPictureType type)

添加图片

Parameters:: workbook - workbook; sheet - sheet; image - 图片; rowIndex - 行索引; columnIndex - 列索引; fileName - 文件名; type - 文件类型
Returns:: Picture

freezeFirstRow

public static void freezeFirstRow(org.apache.poi.ss.usermodel.Sheet sheet)

冻结首行

Parameters:: sheet - sheet

freezeRow

public static void freezeRow(org.apache.poi.ss.usermodel.Sheet sheet,
                             int lastRow)

冻结行

Parameters:: sheet - sheet; lastRow - 结束行索引不包含

filterFirstRow

public static void filterFirstRow(org.apache.poi.ss.usermodel.Sheet sheet)

筛选首行

Parameters:: sheet - sheet

filterFirstRow

public static void filterFirstRow(org.apache.poi.ss.usermodel.Sheet sheet,
                                  int lastColumn)

筛选首行

Parameters:: sheet - sheet; lastColumn - 结束列索引

filterFirstRow

public static void filterFirstRow(org.apache.poi.ss.usermodel.Sheet sheet,
                                  int firstColumn,
                                  int lastColumn)

筛选首行

Parameters:: sheet - sheet; firstColumn - 开始列索引; lastColumn - 结束列索引

filterRow

public static void filterRow(org.apache.poi.ss.usermodel.Sheet sheet,
                             int rowIndex)

筛选行

Parameters:: sheet - sheet; rowIndex - 行索引

filterRow

public static void filterRow(org.apache.poi.ss.usermodel.Sheet sheet,
                             int rowIndex,
                             int lastColumn)

筛选行

Parameters:: sheet - sheet; rowIndex - 行索引; lastColumn - 结束列索引

filterRow

public static void filterRow(org.apache.poi.ss.usermodel.Sheet sheet,
                             int rowIndex,
                             int firstColumn,
                             int lastColumn)

筛选行

Parameters:: sheet - sheet; rowIndex - 行索引; firstColumn - 开始列索引; lastColumn - 结束列索引

mergeCellRange

public static org.apache.poi.ss.util.CellRangeAddress mergeCellRange(int row,
                                                                     int firstColumn,
                                                                     int lastColumn)

合并单元格

Parameters:: row - 合并行索引; firstColumn - 合并开始列索引; lastColumn - 合并结束列索引
Returns:: merge

mergeCellRange

public static org.apache.poi.ss.util.CellRangeAddress mergeCellRange(int firstRow,
                                                                     int lastRow,
                                                                     int firstColumn,
                                                                     int lastColumn)

合并单元格

Parameters:: firstRow - 合并开始行索引; lastRow - 合并结束行索引; firstColumn - 合并开始列索引; lastColumn - 合并结束列索引
Returns:: merge

mergeCell

public static void mergeCell(org.apache.poi.ss.usermodel.Sheet sheet,
                             int row,
                             int firstColumn,
                             int lastColumn)

合并单元格

Parameters:: sheet - sheet; row - 合并行索引; firstColumn - 合并开始列索引; lastColumn - 合并结束列索引

mergeCell

public static void mergeCell(org.apache.poi.ss.usermodel.Sheet sheet,
                             int firstRow,
                             int lastRow,
                             int firstColumn,
                             int lastColumn)

合并单元格

Parameters:: sheet - sheet; firstRow - 合并开始行索引; lastRow - 合并结束行索引; firstColumn - 合并开始列索引; lastColumn - 合并结束列索引

mergeCell

public static void mergeCell(org.apache.poi.ss.usermodel.Sheet sheet,
                             org.apache.poi.ss.util.CellRangeAddress region)

合并单元格

Parameters:: sheet - sheet; region - region

mergeCellBorder

public static void mergeCellBorder(org.apache.poi.ss.usermodel.Sheet sheet,
                                   int borderCode,
                                   int colorIndex,
                                   int row,
                                   int firstColumn,
                                   int lastColumn)

合并单元格边框

Parameters:: sheet - sheet; borderCode - 边框; colorIndex - 颜色; row - 合并行索引; firstColumn - 合并开始列索引; lastColumn - 合并结束列索引

mergeCellBorder

public static void mergeCellBorder(org.apache.poi.ss.usermodel.Sheet sheet,
                                   int borderCode,
                                   int colorIndex,
                                   int firstRow,
                                   int lastRow,
                                   int firstColumn,
                                   int lastColumn)

合并单元格边框

Parameters:: sheet - sheet; borderCode - 边框; firstRow - 合并开始行索引; lastRow - 合并结束行索引; firstColumn - 合并开始列索引; lastColumn - 合并结束列索引

mergeCellBorder

public static void mergeCellBorder(org.apache.poi.ss.usermodel.Sheet sheet,
                                   int borderCode,
                                   int colorIndex,
                                   org.apache.poi.ss.util.CellRangeAddress region)

合并单元格边框

Parameters:: sheet - sheet; borderCode - 边框; region - region

addSelectOptions

public static void addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet,
                                    int column,
                                    String[] options)

添加下拉框

Parameters:: sheet - sheet; column - 开始列索引; options - 选项

addSelectOptions

public static void addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet,
                                    int startRow,
                                    int column,
                                    String[] options)

添加下拉框

Parameters:: sheet - sheet; startRow - 开始行索引; column - 开始列索引; options - 选项

addSelectOptions

public static void addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet,
                                    int startRow,
                                    int endRow,
                                    int column,
                                    String[] options)

添加下拉框

Parameters:: sheet - sheet; startRow - 开始行索引; endRow - 结束行索引; column - 列索引; options - 选项

addSelectOptions

public static void addSelectOptions(org.apache.poi.ss.usermodel.Sheet sheet,
                                    int startRow,
                                    int endRow,
                                    int startColumn,
                                    int endColumn,
                                    String[] options)

添加下拉框

Parameters:: sheet - sheet; startRow - 开始行索引; endRow - 结束行索引; startColumn - 开始列索引; endColumn - 结束列索引; options - 选项

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         String file)

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         File file)

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         OutputStream out)

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         OutputStream out,
                         boolean close)

写入workbook到流

Parameters:: workbook - workbook; out - 流; close - 是否关闭流

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         String file,
                         String password)

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         File file,
                         String password)

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         OutputStream out,
                         String password)

write

public static void write(org.apache.poi.ss.usermodel.Workbook workbook,
                         OutputStream out,
                         String password,
                         boolean close)

写入workbook到流

Parameters:: workbook - workbook; out - 流; password - password; close - 是否关闭流

close

public static void close(org.apache.poi.ss.usermodel.Workbook workbook)

关闭workbook

Parameters:: workbook - workbook

copySheet

public static SheetCopier copySheet(org.apache.poi.ss.usermodel.Workbook resourceWorkbook,
                                    org.apache.poi.ss.usermodel.Workbook targetWorkbook,
                                    int resourceIndex)

复制sheet 新建sheet

Parameters:: resourceWorkbook - 源表; targetWorkbook - 目标表; resourceIndex - 源sheet索引
Returns:: CopySheet

copySheet

public static SheetCopier copySheet(org.apache.poi.ss.usermodel.Workbook resourceWorkbook,
                                    org.apache.poi.ss.usermodel.Workbook targetWorkbook,
                                    int resourceIndex,
                                    int targetIndex)

复制sheet 如果未找到目标sheet 则新建sheet

Parameters:: resourceWorkbook - 源表; targetWorkbook - 目标表; resourceIndex - 源sheet索引; targetIndex - 目标sheet索引
Returns:: CopySheet

openWorkbook

public static org.apache.poi.ss.usermodel.Workbook openWorkbook(InputStream in)

openWorkbook

public static org.apache.poi.ss.usermodel.Workbook openWorkbook(String file)

openWorkbook

public static org.apache.poi.ss.usermodel.Workbook openWorkbook(File file)

openWorkbook

public static org.apache.poi.ss.usermodel.Workbook openWorkbook(String file,
                                                                String password)

openWorkbook

public static org.apache.poi.ss.usermodel.Workbook openWorkbook(File file,
                                                                String password)

openWorkbook

public static org.apache.poi.ss.usermodel.Workbook openWorkbook(InputStream in,
                                                                String password)

获取workbook

Parameters:: in - 文件流
Returns:: StreamingWorkbook

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(String file)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(File file)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(InputStream in)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(String file,
                                                                         String password)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(File file,
                                                                         String password)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(InputStream in,
                                                                         String password)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(String file,
                                                                         int rowCache)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(File file,
                                                                         int rowCache)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(InputStream in,
                                                                         int rowCache)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(String file,
                                                                         String password,
                                                                         int rowCache)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(File file,
                                                                         String password,
                                                                         int rowCache)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(InputStream in,
                                                                         String password,
                                                                         int rowCache)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(String file,
                                                                         int rowCache,
                                                                         int bufferSize)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(File file,
                                                                         int rowCache,
                                                                         int bufferSize)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(InputStream in,
                                                                         int rowCache,
                                                                         int bufferSize)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(String file,
                                                                         String password,
                                                                         int rowCache,
                                                                         int bufferSize)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(File file,
                                                                         String password,
                                                                         int rowCache,
                                                                         int bufferSize)

openStreamingWorkbook

public static org.apache.poi.ss.usermodel.Workbook openStreamingWorkbook(InputStream in,
                                                                         String password,
                                                                         int rowCache,
                                                                         int bufferSize)

获取流式workbook

Parameters:: in - 文件流; password - 密码; rowCache - row缓存; bufferSize - 缓冲区大小
Returns:: StreamingWorkbook

isStreamingWorkbook
```
public static boolean isStreamingWorkbook(org.apache.poi.ss.usermodel.Workbook workbook)
```
是否为流式读取的workbook

Parameters:

workbook - workbook

Returns:

true StreamingWorkbook

isStreamingWorkbook
```
public static boolean isStreamingWorkbook(Class<?> clazz)
```
是否为流式读取的workbook

Parameters:

clazz - workbook class

Returns:

true StreamingWorkbook

isStreamingSheet
```
public static boolean isStreamingSheet(org.apache.poi.ss.usermodel.Sheet sheet)
```
是否为流式读取的sheet

Parameters:

sheet - sheet

Returns:

true StreamingSheet

isStreamingSheet
```
public static boolean isStreamingSheet(Class<?> clazz)
```
是否为流式读取的sheet

Parameters:

clazz - sheet class

Returns:

true StreamingSheet

Class Excels

Method Summary

Methods inherited from class java.lang.Object

Method Detail

getColumnNumber

getColumnSymbol

getWidth

getWidth

getCellValue

getCellValue

getCellValue

getCellValue

getCellDecimal

getCellDecimal

getCellDecimal

getCellInteger

getCellInteger

getCellInteger

getCellLong

getCellLong

getCellLong

getCellDate

getCellDate

getCellDate

getCellPhone

getCellPhone

getCellComment

getCellHyperUrl

getRow

getRowStyle

getCell

getCellStyle

getCellMerge

getFieldType

getFieldType

setCellValue

setCellValue

setCellValue

copyCellValue

getRowCount

getPhysicalRowCount

getColumnCount

getColumnCount

getColor

paletteColor

paletteColor

createPictureParser

createPictureParser

createPictureParser

getThumbnail

setThumbnail

setThumbnail

setThumbnail

setThumbnail

setThumbnail

setThumbnail

getProperties

setProperties

setDefaultProperties

getHeader

setHeader

getFooter

setFooter

createComment

createComment

parseStyle

parseColumnStyle

parseTitleStyle

parseFont

parsePrint

setLink

setLink

setPicture

setPicture

setPicture

setPicture

setPicture

setPicture

setPicture

setPicture