使用POI类库对EXCEL操作:
PoiTestM.java
java 代码
- package it;
- import org.apache.poi.hssf.usermodel.*;
- import java.io.*;
- public class PoiTestM {
- public static void main(String[] args) throws Exception{
- FileOutputStream fos = new FileOutputStream("e:\\jsp\\foo.xls");
- HSSFWorkbook wb = new HSSFWorkbook();
- HSSFSheet s = wb.createSheet();
- wb.setSheetName(0, "Matrix");
- for(short i =0;i<10;i++){
- HSSFRow row = s.createRow(i);
- for(short j = 0;j<10;j++){
- HSSFCell cell = row.createCell(j);
- cell.setCellValue(" "+i+" "+j);
- }
- }
- wb.write(fos);
- fos.close();
- }
- }