我有一个现有的xlsx文件,在第1行上有我的标题,我需要在第2行添加新行,并将其他所有内容向下移动,然后将我的数据添加到此行。你能帮我吗?
static void Append() throws EncryptedDocumentException, InvalidFormatException, IOException
{
InputStream inp = new FileInputStream("C:/workbook.xlsx");
Workbook wb = WorkbookFactory.create(inp);
Sheet sheet = wb.getSheetAt(0);
Row row = sheet.createRow((short) 2);
sheet.shiftRows(1, sheet.getLastRowNum()+1, 1, true,true);
row.createCell(0).setCellValue("A");
row.createCell(1).setCellValue("B");
row.createCell(2).setCellValue("This is a string");
row.createCell(3).setCellValue(true);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("C:/workbook.xlsx");
wb.write(fileOut);
fileOut.close();
}