package com.dy.pmsProduct.taskPlan;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.write.style.*;
|
import com.alibaba.excel.converters.Converter;
|
import com.alibaba.excel.enums.BooleanEnum;
|
import com.alibaba.excel.enums.poi.BorderStyleEnum;
|
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
|
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
|
import lombok.Data;
|
|
//参考： https://easyexcel.opensource.alibaba.com/docs/current/quickstart/write
|
@Data
|
@HeadRowHeight(40) //设置标题高度
|
@HeadFontStyle(fontName="宋体", fontHeightInPoints = 16)
|
@HeadStyle(wrapped = BooleanEnum.TRUE, shrinkToFit = BooleanEnum.TRUE,
|
horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER,
|
borderLeft = BorderStyleEnum.THIN, borderRight = BorderStyleEnum.THIN, borderTop = BorderStyleEnum.THIN, borderBottom = BorderStyleEnum.THIN,
|
leftBorderColor = 8, rightBorderColor = 8, topBorderColor = 8, bottomBorderColor = 8) //IndexedColors.BLACK
|
@ColumnWidth(16) //设置列宽
|
public class ExcelDeviceNoVo implements Converter<byte[]> {
|
@ColumnWidth(40)
|
@ExcelProperty("设备号")
|
public String deviceNo ;
|
}
|
