需要poi.jar包的支持
package com.mypack.core.utils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ExcelUtils {
public static HSSFWorkbook workbook;
public static HSSFSheet sheet;
/**
*
* <li>创建Excel工作薄</li>
*
* @param sheetName
* @return
*/
public static HSSFSheet createSheet(String sheetName) {
workbook = new HSSFWorkbook();
sheet = workbook.createSheet(sheetName);
return sheet;
}
/**
*
* <li>填充表单内容</li>
*
* @param titles
* @param sheetName
* @param rowIndex
*/
public static void fillSheetContent(String[] titles, int rowIndex) {
HSSFRow row = sheet.createRow((short) rowIndex);
if (titles != null) {
for (int i = 0; i < titles.length; i++) {
HSSFCell cell = row.createCell((short) i);
cell.setCellValue(new HSSFRichTextString(titles[i]));
}
}
}
}
Excel处理工具类
最新推荐文章于 2024-03-13 22:29:55 发布