XSSFWorkbook 删除sheet
时间: 2024-01-01 15:55:56 浏览: 35
要使用XSSFWorkbook删除sheet表,需要导入poi-ooxml包中的XSSFWorkbook类。可以通过以下代码实现删除sheet表的功能:
```java
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public void removeSheet(XSSFWorkbook workbook, String name) {
System.out.println("删除===" + name + "sheet表");
workbook.removeSheetAt(workbook.getSheetIndex(name));
}
```
在你的代码中调用该方法即可实现删除指定名称的sheet表。记得在使用该方法之前,先确保已经正确导入了所需的包。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Java用POI删除一个Excel的特定sheet表](https://blog.csdn.net/java0825/article/details/126346693)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [poi-xssfworkbook.jar](https://download.csdn.net/download/qq_33393312/10772780)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]