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();
???? }
}
?
