使用 Apache POI 删除 Excel 工作表 [英] Delete an excel sheet using Apache POI

问题描述

我必须从 Excel 文件中删除工作表.

I have to delete a sheet from the Excel file.

这是我的代码片段:

FileInputStream fileStream = new FileInputStream(destFile);
POIFSFileSystem fsPoi = new POIFSFileSystem(fileStream);

HSSFWorkbook workbook = new HSSFWorkbook(fsPoi);

int index = 0;

HSSFSheet sheet = workbook.getSheet("Setup");
if(sheet != null)   {
    index = workbook.getSheetIndex(sheet);
    workbook.removeSheetAt(index);
}
return destFile;

在此之后，我获得与我通过的完全相同的工作簿，无需移除工作表设置"

帮我解决这个问题.任何帮助将不胜感激

Help me resolve this. Any help would be appreciated

推荐答案

编辑完工作簿后，需要重新编写.试试这个:-

After editing your workbook, you need to write it again. Try this:-

FileOutputStream output = new FileOutputStream(destFile);
workbook.write(output);
output.close();

编辑:-写回后，您可以返回您的destFile.

Edit:- After writing it back, you can return your destFile.

这篇关于使用 Apache POI 删除 Excel 工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！