作者:乔山办公网日期:
返回目录:excel表格制作
HSSFWorkbook wb = new HSSFWorkbook();
zhidao HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow row = sheet.createRow((short) 1);
HSSFCell cell = row.createCell((short) 1);
HSSFRichTextString content = new HSSFRichTextString("This is a test of message");
cell.setCellValue(content);
sheet.addMergedRegion(new Region(1,(short)1,1,(short)2));
FileOutputStream fileOut = new FileOutputStream("d:/Demo_02_05.xls");
wb.write(fileOut);
fileOut.close();
貌似zhidao现在的POI还无法实现你这版个要求
如果是删除行的话可以权用:
XSSFSheet xs = xwb.createSheet(sheetName);
XSSFRow yRow = xs.createRow(row);
xs.removeRow(yRow);
李煜《相见欢无言独上西楼》剪不断、理还乱,是离愁。别是一番滋味在心头。
sheet.setRowSumsBelow(false);
sheet.setRowSumsRight(false);