java修改excel文件xlsx
时间: 2023-12-01 07:02:57 浏览: 36
可以使用Apache POI这个Java库来实现对Excel文件(包括xlsx格式)的读取和修改。以下是一个简单的示例代码,演示如何使用POI来修改xlsx文件:
```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 ExcelModifier {
public static void main(String[] args) {
String filePath = "path/to/excel.xlsx";
String sheetName = "Sheet1";
int rowIndex = 1;
int columnIndex = 2;
try (FileInputStream inputStream = new FileInputStream(filePath)) {
Workbook workbook = new XSSFWorkbook(inputStream);
Sheet sheet = workbook.getSheet(sheetName);
Row row = sheet.getRow(rowIndex);
Cell cell = row.getCell(columnIndex);
cell.setCellValue("New Value");
try (FileOutputStream outputStream = new FileOutputStream(filePath)) {
workbook.write(outputStream);
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
```
以上代码将会打开一个名为“excel.xlsx”的文件,然后在第2行第3列的单元格上写入“New Value”,最后将修改保存回文件。注意,这段代码应该在try-with-resources语句块中运行以确保文件流被正确关闭。