1 2 17 18 19 package org.apache.poi.hssf.usermodel.examples; 20 21 import org.apache.poi.hssf.usermodel.HSSFCell; 22 import org.apache.poi.hssf.usermodel.HSSFRow; 23 import org.apache.poi.hssf.usermodel.HSSFSheet; 24 import org.apache.poi.hssf.usermodel.HSSFWorkbook; 25 26 import java.io.FileOutputStream ; 27 import java.io.IOException ; 28 import java.util.Date ; 29 30 public class CellTypes 31 { 32 public static void main(String [] args) 33 throws IOException 34 { 35 HSSFWorkbook wb = new HSSFWorkbook(); 36 HSSFSheet sheet = wb.createSheet("new sheet"); 37 HSSFRow row = sheet.createRow((short)2); 38 row.createCell((short) 0).setCellValue(1.1); 39 row.createCell((short) 1).setCellValue(new Date ()); 40 row.createCell((short) 2).setCellValue("a string"); 41 row.createCell((short) 3).setCellValue(true); 42 row.createCell((short) 4).setCellType(HSSFCell.CELL_TYPE_ERROR); 43 44 FileOutputStream fileOut = new FileOutputStream ("workbook.xls"); 46 wb.write(fileOut); 47 fileOut.close(); 48 } 49 } 50 | Popular Tags |