xyz.zhangbohan.common.tools

类 ExcelUtils

java.lang.Object

xyz.zhangbohan.common.tools.ExcelUtils

public class ExcelUtils
extends Object

Excel操作工具类

作者:

ChaiXY

字段概要

字段

限定符和类型	字段和说明
static String	OFFICE_EXCEL_XLS
static String	OFFICE_EXCEL_XLSX

构造器概要

构造器

构造器和说明
ExcelUtils()

方法概要

限定符和类型	方法和说明
static boolean	addSheet(String filepath, String sheetName, List<String> titles, List<Map<String,Object>> values) 添加一个Sheet
private static Map<String,org.apache.poi.ss.usermodel.CellStyle>	createStyles(org.apache.poi.ss.usermodel.Workbook wb) 设置格式
private static String	getSuffiex(String filepath) 获取后缀
static org.apache.poi.ss.usermodel.Workbook	getWorkbook(String filepath) 根据文件路径获取Workbook对象
static String	readExcel(String filepath, Integer sheetNo) 读取指定Sheet也的内容
private static String	readExcelSheet(org.apache.poi.ss.usermodel.Sheet sheet)
static org.apache.poi.ss.usermodel.Row	readTitle(org.apache.poi.ss.usermodel.Sheet sheet) 读取指定Sheet页的表头
static org.apache.poi.ss.usermodel.Row	readTitle(String filepath, int sheetNo) 读取指定Sheet页的表头
static void	writeExcel(String srcFilepath, String desFilepath) 将源文件的内容复制到新Excel文件(可供理解Excel使用,使用价值不大)
static boolean	writeExcel(String filepath, String sheetName, List<String> titles, List<Map<String,Object>> values) 创建Excel文件

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

OFFICE_EXCEL_XLS

public static final String OFFICE_EXCEL_XLS

另请参阅:

常量字段值

OFFICE_EXCEL_XLSX

public static final String OFFICE_EXCEL_XLSX

另请参阅:

常量字段值

构造器详细资料

ExcelUtils

public ExcelUtils()

方法详细资料

readExcel

public static String readExcel(String filepath,
                               Integer sheetNo)
                        throws org.apache.poi.EncryptedDocumentException,
                               org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                               IOException

读取指定Sheet也的内容

参数:

filepath - filepath 文件全路径

sheetNo - sheet序号,从0开始,如果读取全文sheetNo设置null

抛出:

org.apache.poi.EncryptedDocumentException

org.apache.poi.openxml4j.exceptions.InvalidFormatException

IOException

getWorkbook

public static org.apache.poi.ss.usermodel.Workbook getWorkbook(String filepath)
                                                        throws org.apache.poi.EncryptedDocumentException,
                                                               org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                                                               IOException

根据文件路径获取Workbook对象

参数:

filepath - 文件全路径

抛出:

org.apache.poi.EncryptedDocumentException

org.apache.poi.openxml4j.exceptions.InvalidFormatException

IOException

getSuffiex

private static String getSuffiex(String filepath)

获取后缀

参数:

filepath - filepath 文件全路径

readExcelSheet

private static String readExcelSheet(org.apache.poi.ss.usermodel.Sheet sheet)

readTitle

public static org.apache.poi.ss.usermodel.Row readTitle(String filepath,
                                                        int sheetNo)
                                                 throws IOException,
                                                        org.apache.poi.EncryptedDocumentException,
                                                        org.apache.poi.openxml4j.exceptions.InvalidFormatException

读取指定Sheet页的表头

参数:

filepath - filepath 文件全路径

sheetNo - sheet序号,从0开始,必填

抛出:

IOException

org.apache.poi.EncryptedDocumentException

org.apache.poi.openxml4j.exceptions.InvalidFormatException

readTitle

public static org.apache.poi.ss.usermodel.Row readTitle(org.apache.poi.ss.usermodel.Sheet sheet)
                                                 throws IOException

读取指定Sheet页的表头

抛出:

IOException

writeExcel

public static boolean writeExcel(String filepath,
                                 String sheetName,
                                 List<String> titles,
                                 List<Map<String,Object>> values)
                          throws IOException

创建Excel文件

参数:

filepath - filepath 文件全路径

sheetName - 新Sheet页的名字

titles - 表头

values - 每行的单元格

抛出:

IOException

addSheet

public static boolean addSheet(String filepath,
                               String sheetName,
                               List<String> titles,
                               List<Map<String,Object>> values)
                        throws IOException,
                               org.apache.poi.openxml4j.exceptions.InvalidFormatException

添加一个Sheet

参数:

filepath - filepath 文件全路径

sheetName - 新Sheet页的名字

titles - 表头

values - 每行的单元格

抛出:

IOException

org.apache.poi.openxml4j.exceptions.InvalidFormatException

createStyles

private static Map<String,org.apache.poi.ss.usermodel.CellStyle> createStyles(org.apache.poi.ss.usermodel.Workbook wb)

设置格式

writeExcel

public static void writeExcel(String srcFilepath,
                              String desFilepath)
                       throws IOException,
                              org.apache.poi.EncryptedDocumentException,
                              org.apache.poi.openxml4j.exceptions.InvalidFormatException

将源文件的内容复制到新Excel文件(可供理解Excel使用,使用价值不大)

参数:

srcFilepath - 源文件全路径

desFilepath - 目标文件全路径

抛出:

IOException

org.apache.poi.EncryptedDocumentException

org.apache.poi.openxml4j.exceptions.InvalidFormatException