java使用POI读取excel模版并向固定表格里填写数据详解:public class ExportExcelDemo {
private HSSFWorkbook workbook = null;
/**
* 显示的导出表的标题
*/
private String title;
/**
* 导出表的列名
*/
private String[] rowName;
private List dataList = new ArrayList<>();
/**
* 构造方法,传入要导出的数据
*
* @param title
* @param rowName
* @param dataList
*/
public ExportExcelDemo(String title, String[] rowName, List dataList) {
this.dataList = dataList;
this.rowName = rowName;
this.title = title;
}
/**
* 判断文件的sheet是否存在
* @param filePath 文件路径
* @param sheetName 表格索引名
* @return
*/
public boolean sheetExist(String filePath,String sheetName){
boolean flag