1、创建一个sheet,把创建的单元格放入sheet中
WritableWorkbook wb = null;//创建空工作薄
wb = Workbook.createWorkbook(out);
WritableSheet sheet = wb.createSheet(fileName, 0);//创建sheet表单
sheet.addCell(createCell(colIndex, rowIndex, value, wcf));
2、创建图片单元格,记得加载包import jxl.write.WritableImage;
public static WritableCell createCell(int colIndex, int rowIndex, Object value, WritableCellFormat wcf) {
WritableCell cell = null;
if (value == null) {
cell = new jxl.write.Label(colIndex, rowIndex, "");
} else if (value instanceof String) {
cell = ExportExcelUtil.createLabelCell(colIndex, rowIndex, value.toString(), wcf);
} else if (value instanceof Date) {
cell = ExportExcelUtil.createDateTimeCell(colIndex, rowIndex, (Date) value, wcf);
} else if (value instanceof Integer) {
cell = ExportExcelUtil.createNumberCell(colIndex, rowIndex, ((Integer) value).doubleValue(), wcf);
} else if (value instanceof Long) {
cell = ExportExcelUtil.createNumberCell(colIndex, rowIndex, ((Long) value).doubleValue(), wcf);
} else if (value instanceof Double) {
cell = ExportExcelUtil.createNumberCell(colIndex, rowIndex, ((Double) value).doubleValue(), wcf);
} else if (value instanceof Float) {
cell = ExportExcelUtil.createNumberCell(colIndex, rowIndex, ((Float) value).doubleValue(), wcf);
} else if (value instanceof File) {
cell = (WritableCell) ExportExcelUtil.createImageCell(colIndex, rowIndex, (File) value);
}else {
cell = new jxl.write.Label(colIndex, rowIndex, "");
}
return cell;
}
/**
* 创建图片单元格
*
* @param col
* 列序号
* @param row
* 行序号
* @param date
* 日期数据
* @return
*/
public static WritableImage createImageCell(int col, int row, File image) {
WritableImage iCell = null;
iCell = new jxl.write.WritableImage(col, row, 1, 1, image);
return iCell;
}