package org.springblade.common.excel;

import com.alibaba.excel.write.handler.SheetWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;

public class MySheetWriteHandler implements SheetWriteHandler {
	@Override
	public void beforeSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {

	}

	@Override
	public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
		Workbook workbook = writeWorkbookHolder.getWorkbook();
		Sheet sheet = workbook.getSheetAt(0);
		Row row1 = sheet.createRow(0);
		row1.setHeight((short) 500);
		Cell cell = row1.createCell(0);
		//设置单元格内容
		cell.setCellValue("附件2");
		//设置标题
		Row row2 = sheet.createRow(1);
		row2.setHeight((short) 800);
		Cell cell1 = row2.createCell(0);
		cell1.setCellValue("存量建筑垃圾堆体治理进度月报表");
		CellStyle cellStyle = workbook.createCellStyle();
		cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
		cellStyle.setAlignment(HorizontalAlignment.CENTER);
		Font font = workbook.createFont();
		font.setBold(true);
		font.setFontHeight((short) 400);
		cellStyle.setFont(font);
		cell1.setCellStyle(cellStyle);
		sheet.addMergedRegionUnsafe(new CellRangeAddress(1, 1, 0, 17));
		//设置填表日期,填报人,联系方式
		Row row3 = sheet.createRow(2);
		row3.setHeight((short) 500);
		row3.createCell(1).setCellValue("填表日期");
		row3.createCell(11).setCellValue("填表人");
		row3.createCell(15).setCellValue("联系方式");
	}
}