Java中导出数据到Excel示例—poi

package biz;
 import java.io.FileOutputStream;
 import java.io.IOException;
 import java.util.Date;
 import org.apache.poi.hssf.usermodel.HSSFCell;
 import org.apache.poi.hssf.usermodel.HSSFCellStyle;
 import org.apache.poi.hssf.usermodel.HSSFDataFormat;
 import org.apache.poi.hssf.usermodel.HSSFRow;
 import org.apache.poi.hssf.usermodel.HSSFSheet;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;

 public class Test {

     public static void main(String[] args) throws IOException {
         HSSFWorkbook wb = new HSSFWorkbook();
         HSSFSheet sheet = wb.createSheet("new sheet");
         HSSFRow row = sheet.createRow((short)0);
       
         HSSFCell cell = row.createCell((short)0);
         cell.setCellValue(1);
         row.createCell((short)1).setCellValue(1.2);
         row.createCell((short)2).setCellValue("test");
         row.createCell((short)3).setCellValue(true);
        
         HSSFCellStyle cellStyle = wb.createCellStyle();
         cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));
        
         HSSFCell dCell = row.createCell((short)4);
         dCell.setCellValue(new Date());
         dCell.setCellStyle(cellStyle);
         HSSFCell csCell = row.createCell((short)5);
         csCell.setEncoding(HSSFCell.ENCODING_UTF_16);
         csCell.setCellValue("中文测试_Chinese Words Test");
         row.createCell((short)6).setCellType(HSSFCell.CELL_TYPE_ERROR);
         //定义文件输出流输出文件
         FileOutputStream fileOut = new FileOutputStream("D:\\workbook.xls");
         wb.write(fileOut);
         fileOut.close();
     }

}