java删除excel列
时间: 2023-08-21 14:07:50 浏览: 53
您可以使用 Apache POI 库来操作 Excel 文件并删除列。以下是一个简单的示例代码,假设您要删除第二列:
```java
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelColumnDeleter {
public static void main(String[] args) throws Exception {
String inputFile = "input.xlsx";
String outputFile = "output.xlsx";
FileInputStream inputStream = new FileInputStream(inputFile);
Workbook workbook = new XSSFWorkbook(inputStream);
Sheet sheet = workbook.getSheetAt(0);
for (Row row : sheet) {
Cell cell = row.getCell(1); // get the cell in the second column
row.removeCell(cell); // delete the cell
}
inputStream.close();
FileOutputStream outputStream = new FileOutputStream(outputFile);
workbook.write(outputStream);
workbook.close();
outputStream.close();
}
}
```
请注意,这将删除第二列中的每个单元格。如果您只想删除整个列,而不是其中的单元格,则需要进行一些更改。