本文概述
- Apache POI Excel对齐单元格示例
【apache poi excel对齐单元格】让我们看一个示例，在该示例中，我们还将创建一个单元并对其进行对齐。
Apache POI Excel对齐单元格示例
package poiexample;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
public class AlignExample {
public static void main(String[] args) throws FileNotFoundException, IOException {
Workbook wb = new HSSFWorkbook();
try(OutputStream os = new FileOutputStream("srcmini.xls")) {
Sheet sheet = wb.createSheet("New Sheet");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("srcmini");
CellStyle cellStyle = wb.createCellStyle();
row = sheet.createRow(5);
cell = row.createCell(0);
// Top Left alignment
HSSFCellStyle style1 = (HSSFCellStyle) wb.createCellStyle();
sheet.setColumnWidth(0, 8000);
cell.setCellValue("Top Left");
cell.setCellStyle(style1);
row = sheet.createRow(6);
cell = row.createCell(1);
row.setHeight((short) 800);
wb.write(os);
}catch(Exception e) {
System.out.println(e.getMessage());
}
}}输出：
文章图片
推荐阅读
- apache poi excel单元格
- apache poi excel日期单元格
- apache poi excel工作簿
- apache poi excel文档处理
- apache poi安装
- apache poi的特性
- apache poi架构
- apache poi的介绍
- apache poi入门教程