| | |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | import org.apache.poi.ss.usermodel.BorderStyle; |
| | | import org.apache.poi.ss.usermodel.HorizontalAlignment; |
| | | import org.apache.poi.ss.usermodel.VerticalAlignment; |
| | | import org.springframework.beans.BeanUtils; |
| | |
| | | // 设置 垂直居中 |
| | | contentWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); |
| | | contentWriteCellStyle.setWriteFont(writeFont); |
| | | |
| | | // 设置边框 |
| | | // 下边框 |
| | | contentWriteCellStyle.setBorderBottom(BorderStyle.THIN); |
| | | // 左边框 |
| | | contentWriteCellStyle.setBorderLeft(BorderStyle.THIN); |
| | | // 上边框 |
| | | contentWriteCellStyle.setBorderTop(BorderStyle.THIN); |
| | | // 右边框 |
| | | contentWriteCellStyle.setBorderRight(BorderStyle.THIN); |
| | | contentWriteCellStyle.setWrapped(true); |
| | | HorizontalCellStyleStrategy horizontalCellStyleStrategy = |
| | | new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle); |