> WENDY'S HOUSE <

import java.io.FileOutputStream; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class Test { private String filePath; private String rowData1[] = new String[3]; private String rowData2[] = new String[3]; public void initData(){ filePath = "C:/test.xls"; rowData1[0] = new String("accpjerry"); rowData1[1] = new String("男"); rowData1[2] = new String("24"); rowData2[0] = new String("snow"); rowData2[1] = new String("女"); rowData2[2] = new String("21"); } public int exportExcel(){ try{ FileOutputStream fileOut = new FileOutputStream(filePath); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); HSSFRow row = sheet.createRow(0); //创建第1行 HSSFCell cell = row.createCell((short)0); //创建每行的第1列 cell.setEncoding((short)1); //设置列的格式(文本或数字) cell.setCellValue(rowData1[0]); //设置数据 cell = row.createCell((short)1); //创建每行的第2列 cell.setEncoding((short)1); //设置列的格式(文本或数字) cell.setCellValue(rowData1[1]); //设置数据 cell = row.createCell((short)2); //创建每行的第3列 cell.setEncoding((short)1); //设置列的格式(文本或数字) cell.setCellValue(rowData1[2]); //设置数据 row = sheet.createRow(1); //创建第2行 cell = row.createCell((short)0); //创建每行的第1列 cell.setEncoding((short)1); //设置列的格式(文本或数字) cell.setCellValue(rowData2[0]); //设置数据 cell = row.createCell((short)1); //创建每行的第2列 cell.setEncoding((short)1); //设置列的格式(文本或数字) cell.setCellValue(rowData2[1]); //设置数据 cell = row.createCell((short)2); //创建每行的第3列 cell.setEncoding((short)1); //设置列的格式(文本或数字) cell.setCellValue(rowData2[2]); //设置数据 wb.write(fileOut); fileOut.close(); }catch(Exception e){ e.printStackTrace(); } return 0; } /** * @param args */ public static void main(String[] args) { Test test = new Test(); test.initData(); test.exportExcel(); } }