Java如何设置单元格中的文本的方向?

在Java编程中,如何设置单元格中的文本的方向?

注意:需要访问网址:http://poi.apache.org/download.html , 下载一个Apache POI软件包。这里下载最新版本:poi-bin-3.17-20170915.tar.gz解压并将全部.jar文件导入 。

需要导入全部包,如下图所示 -

参考示例:

http://poi.apache.org/spreadsheet/quick-guide.html

以下是使用Java设置单元格中的文本的方向的程序。

package com.zaixian;

import java.io.File;
import java.io.FileOutputStream;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class TextDirectionInCell {
    public static void main(String[] args) throws Exception {

        // Creating Workbook
        XSSFWorkbook workbook = new XSSFWorkbook();

        // Creating a Spread Sheet
        XSSFSheet spreadsheet = workbook.createSheet("Text direction");
        XSSFRow row = spreadsheet.createRow(2);
        XSSFCellStyle myStyle = workbook.createCellStyle();
        myStyle.setRotation((short) 0);
        XSSFCell cell = row.createCell(1);

        cell.setCellValue("0D angle");
        cell.setCellStyle(myStyle);

        // 30 degrees
        myStyle = workbook.createCellStyle();
        myStyle.setRotation((short) 30);

        cell = row.createCell(3);
        cell.setCellValue("30D angle");
        cell.setCellStyle(myStyle);

        // 90 degrees
        myStyle = workbook.createCellStyle();
        myStyle.setRotation((short) 90);

        cell = row.createCell(5);
        cell.setCellValue("90D angle");
        cell.setCellStyle(myStyle);

        // 120 degrees
        myStyle = workbook.createCellStyle();
        myStyle.setRotation((short) 120);

        cell = row.createCell(7);
        cell.setCellValue("120D angle");
        cell.setCellStyle(myStyle);

        // 270 degrees
        myStyle = workbook.createCellStyle();
        myStyle.setRotation((short) 270);
        cell = row.createCell(9);
        cell.setCellValue("270D angle");
        cell.setCellStyle(myStyle);

        // 360 degrees
        myStyle = workbook.createCellStyle();
        myStyle.setRotation((short) 360);

        cell = row.createCell(12);
        cell.setCellValue("360D angle");
        cell.setCellStyle(myStyle);
        FileOutputStream out = new FileOutputStream(new File("textdirection.xlsx"));

        workbook.write(out);
        out.close();

        System.out.println("textdirection.xlsx written successfully");
    }
}

执行上面示例代码,得到以下结果 -

textdirection.xlsx written successfully

创建的Excel文件内容,如下所示 -


上一篇: Java POI Excel 下一篇: Java POI Word