package test;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class Test11 {
public static void main(String[] args) throws Exception {
FileInputStream fs=new FileInputStream("d:/workbook.xls");
POIFSFileSystem ps=new POIFSFileSystem(fs);
HSSFWorkbook wb=new HSSFWorkbook(ps);
HSSFSheet sheet=wb.getSheetAt(0);
HSSFRow row=sheet.getRow(0);
System.out.println(sheet.getLastRowNum()+" "+row.getLastCellNum());
FileOutputStream out=new FileOutputStream("d:/workbook.xls");
row=sheet.createRow((short)(sheet.getLastRowNum()+1));
row.createCell((short)0).setCellValue(22);
row.createCell((short)1).setCellValue(11);
row.createCell((short)2).setCellValue(11);
row.createCell((short)3).setCellValue(11);
row.createCell((short)4).setCellValue(11);
row.createCell((short)5).setCellValue(11);
row.createCell((short)6).setCellValue(11);
row.createCell((short)7).setCellValue(11);
row.createCell((short)8).setCellValue(11);
row.createCell((short)9).setCellValue(33);
out.flush();
wb.write(out);
out.close();
System.out.println(row.getPhysicalNumberOfCells()+" "+row.getLastCellNum());
}
}
POI向已有的Excel模版写入数据
最新推荐文章于 2024-06-12 11:14:44 发布