在Java编程中，如何在电子表格中创建不同类型的单元格？

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

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

以下是使用Java在电子表格中创建不同类型的单元格的程序。

package com.yiibai;

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

import java.util.Date;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

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

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

      //Creating a Spread sheet
      XSSFSheet spreadsheet = workbook.createSheet("单元格类型");
      XSSFRow row = spreadsheet.createRow((short) 2);

      row.createCell(0).setCellValue("单元格类型");
      row.createCell(1).setCellValue("单元格值");
      row = spreadsheet.createRow((short) 3);

      row.createCell(0).setCellValue("set cell type BLANK");
      row.createCell(1);
      row = spreadsheet.createRow((short) 4);

      row.createCell(0).setCellValue("set cell type BOOLEAN");
      row.createCell(1).setCellValue(true);
      row = spreadsheet.createRow((short) 5);

      row.createCell(0).setCellValue("set cell type ERROR");
      row.createCell(1).setCellValue(XSSFCell.CELL_TYPE_ERROR );
      row = spreadsheet.createRow((short) 6);

      row.createCell(0).setCellValue("set cell type date");
      row.createCell(1).setCellValue(new Date());
      row = spreadsheet.createRow((short) 7);

      row.createCell(0).setCellValue("set cell type numeric" );
      row.createCell(1).setCellValue(20 );
      row = spreadsheet.createRow((short) 8);

      row.createCell(0).setCellValue("set cell type string");
      row.createCell(1).setCellValue("A String");

      FileOutputStream out = new FileOutputStream(new File("typesofcells.xlsx"));
      workbook.write(out);
      out.close();
      System.out.println("typesofcells.xlsx written successfully");
   }
}

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

typesofcells.xlsx written successfully

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

纠错/补充 收藏