public class SheetUtil extends Object
Sheet
相关工具类Constructor and Description |
---|
SheetUtil() |
Modifier and Type | Method and Description |
---|---|
static void |
addIgnoredErrors(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.util.CellRangeAddress cellRangeAddress,
org.apache.poi.ss.usermodel.IgnoredErrorType... ignoredErrorTypes)
设置忽略错误,即Excel中的绿色警告小标,只支持XSSFSheet和SXSSFSheet
见:https://stackoverflow.com/questions/23488221/how-to-remove-warning-in-excel-using-apache-poi-in-java |
static org.apache.poi.ss.util.CellRangeAddress |
getMergedRegion(org.apache.poi.ss.usermodel.Sheet sheet,
int x,
int y)
获取指定坐标点对应的合并单元格范围
|
static org.apache.poi.ss.usermodel.Sheet |
getOrCreateSheet(org.apache.poi.ss.usermodel.Workbook book,
int sheetIndex)
获取或者创建sheet表
自定义需要读取或写出的Sheet,如果给定的sheet不存在,创建之(命名为默认) 在读取中,此方法用于切换读取的sheet,在写出时,此方法用于新建或者切换sheet |
static org.apache.poi.ss.usermodel.Sheet |
getOrCreateSheet(org.apache.poi.ss.usermodel.Workbook book,
String sheetName)
获取或者创建sheet表
如果sheet表在Workbook中已经存在,则获取之,否则创建之 |
static boolean |
isEmpty(org.apache.poi.ss.usermodel.Sheet sheet)
sheet是否为空
|
static void |
walk(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.util.cellwalk.CellHandler cellHandler)
遍历Sheet中的所有单元格
|
static void |
walk(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.util.CellRangeAddress range,
org.apache.poi.ss.util.cellwalk.CellHandler cellHandler)
遍历Sheet中的指定区域单元格
|
public static org.apache.poi.ss.usermodel.Sheet getOrCreateSheet(org.apache.poi.ss.usermodel.Workbook book, String sheetName)
book
- 工作簿Workbook
sheetName
- 工作表名,null
表示默认Sheet
public static org.apache.poi.ss.usermodel.Sheet getOrCreateSheet(org.apache.poi.ss.usermodel.Workbook book, int sheetIndex)
book
- 工作簿Workbook
sheetIndex
- 工作表序号Sheet
public static boolean isEmpty(org.apache.poi.ss.usermodel.Sheet sheet)
sheet
- Sheet
public static void walk(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.cellwalk.CellHandler cellHandler)
sheet
- Sheet
cellHandler
- 单元格处理器public static void walk(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellRangeAddress range, org.apache.poi.ss.util.cellwalk.CellHandler cellHandler)
sheet
- Sheet
range
- 区域cellHandler
- 单元格处理器public static void addIgnoredErrors(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellRangeAddress cellRangeAddress, org.apache.poi.ss.usermodel.IgnoredErrorType... ignoredErrorTypes) throws UnsupportedOperationException
sheet
- Sheet
cellRangeAddress
- 指定单元格范围ignoredErrorTypes
- 忽略的错误类型列表UnsupportedOperationException
- 如果sheet不是XSSFSheetpublic static org.apache.poi.ss.util.CellRangeAddress getMergedRegion(org.apache.poi.ss.usermodel.Sheet sheet, int x, int y)
sheet
- Sheet
x
- x坐标,即列号y
- 行号Copyright © 2025. All rights reserved.