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

问题描述

我要删除Excel文件中的表。

I have to delete a sheet from the Excel file.

下面是我的code片断：

Here's my code snippet :

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;

在此之后，我的，恰好我通过了同一工作簿，不需去除板材设置

帮我解决这个问题。任何帮助将是AP preciated

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屋！