Excel工具类代码
package util;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Optional;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.io.IOUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
/**
* Excel表格工具类
*
* @author zoult on 2019/5/20
*/
public class ExcelUtils {
private Workbook workbook;
public ExcelUtils(Workbook workbook) {
this.workbook = workbook;
}
public ExcelUtils(File file) throws FileNotFoundException, IOException {
FileInputStream is = null;
try {
is = new FileInputStream(file);
if (file.getName().endsWith(".xls")) {
// Excel2003及以前版本
workbook = new HSSFWorkbook(is);
} else {
// Excel2007及以后版本
workbook = new XSSFWorkbook(is);
}
} finally {
IOUtils.closeQuietly(is);
}
}
public ExcelUtils(InputStream is, String fileName) throws IOException {
try {
if (fileName.endsWith(".xls")) {
// Excel2003及以前版本
workbook