如何使用poi在已存在的excel中插入一行？？？

[YellowSnake]

例如：在第一和第二行中插入一行？？？

[cold_blooded]

package testz1;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;

public class Hello {
public Hello() {
}

public static void main(String[] args)

{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow row = sheet.createRow( (short) 0);
createCell(wb, row, (short) 0, HSSFCellStyle.ALIGN_CENTER, 1);
createCell(wb, row, (short) 1, HSSFCellStyle.ALIGN_CENTER_SELECTION, 1);
createCell(wb, row, (short) 2, HSSFCellStyle.ALIGN_FILL, 1);
createCell(wb, row, (short) 3, HSSFCellStyle.ALIGN_GENERAL, 1);
createCell(wb, row, (short) 4, HSSFCellStyle.ALIGN_JUSTIFY, 1);
createCell(wb, row, (short) 5, HSSFCellStyle.ALIGN_LEFT, 1);
createCell(wb, row, (short) 6, HSSFCellStyle.ALIGN_RIGHT, 1);

HSSFRow row2 = sheet.createRow( (short) 1);
row2.setRowNum( (short) 5);
createCell(wb, row2, (short) 0, HSSFCellStyle.ALIGN_CENTER, 2);
createCell(wb, row2, (short) 1, HSSFCellStyle.ALIGN_CENTER_SELECTION, 2);
createCell(wb, row2, (short) 2, HSSFCellStyle.ALIGN_FILL, 2);
createCell(wb, row2, (short) 3, HSSFCellStyle.ALIGN_GENERAL, 2);
createCell(wb, row2, (short) 4, HSSFCellStyle.ALIGN_JUSTIFY, 2);
createCell(wb, row2, (short) 5, HSSFCellStyle.ALIGN_LEFT, 2);
createCell(wb, row2, (short) 6, HSSFCellStyle.ALIGN_RIGHT, 2);

HSSFRow row3 = sheet.createRow( (short) 1);
createCell(wb, row3, (short) 0, HSSFCellStyle.ALIGN_CENTER, 3);
createCell(wb, row3, (short) 1, HSSFCellStyle.ALIGN_CENTER_SELECTION, 3);
createCell(wb, row3, (short) 2, HSSFCellStyle.ALIGN_FILL, 3);
createCell(wb, row3, (short) 3, HSSFCellStyle.ALIGN_GENERAL, 3);
createCell(wb, row3, (short) 4, HSSFCellStyle.ALIGN_JUSTIFY, 3);
createCell(wb, row3, (short) 5, HSSFCellStyle.ALIGN_LEFT, 3);
createCell(wb, row3, (short) 6, HSSFCellStyle.ALIGN_RIGHT, 3);

try {
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
}
catch (Exception e) {}
}

private static void createCell(HSSFWorkbook wb, HSSFRow row, short column,
short align, int i) {
HSSFCell cell = row.createCell(column);
cell.setCellValue(Integer.toString(i));
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment(align);
cell.setCellStyle(cellStyle);
}

}

[turbocrm]

跪求大家，帮我看看这个问题，谢谢！！！！！！！！！！！！！

http://expert.csdn.net/Expert/topic/2633/2633574.xml?temp=.6377375