Java 示例 - 为文本设置方向

• 

  问题描述

  如何使用 Java 为单元格中的文本设置方向。
• 

  解决方案

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

  
  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("C:/poiexcel/textdirection.xlsx"));
        
        workbook.write(out);
        out.close();
        
        System.out.println("textdirection.xlsx written successfully");
     }
  }
  

  复制
• 

  输出