weiweichen1985

永久域名 http://weiweichen1985.javaeye.com

2008-06-16

poi之控制台生成xls

package com.cw.common;

import org.apache.poi.hssf.usermodel.*;
import java.io.FileOutputStream;
 
public class PoiTest {

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

		FileOutputStream fos = new FileOutputStream("e:\\a.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();
	}
}