当前所在位置:珠峰网资料 >> 计算机 >> IT教育 >> 正文
Java存储Excel文件
发布时间:2010/10/22 10:15:08 来源:www.xue.net 编辑:城市总裁吧
     // 使用Java POI

  // 把要两个JAR文件放到lib/ext下

  // code run against the jakarta-poi-1.5.0-FINAL-20020506.jar.

  //                  and commons-logging-1.0.jar

  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;

  // code run against the jakarta-poi-1.5.0-FINAL-20020506.jar.

  //                  and commons-logging-1.0.jar

  public class aa {

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

  FileOutputStream fos = new FileOutputStream("d:\\foo.xls");

  HSSFWorkbook wb = new HSSFWorkbook();

  HSSFSheet s = wb.createSheet();

  wb.setSheetName(0, "Matrix");

  for (short i = 0; i < 50; i++) {

  HSSFRow row = s.createRow(i);

  for (short j = 0; j < 50; j++) {

  HSSFCell cell = row.createCell(j);

  cell.setCellValue("" + i + "," + j);

  }

  }

  wb.write(fos);

  fos.close();

  }

  }

广告合作:400-664-0084 全国热线:400-664-0084
Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15080520号-20
珠峰网 版权所有 All Rights Reserved