java操作excel

Java可以通过以下几种方式操作Excel文件：

1. 使用Apache POI库：Apache POI是一个开放源代码的Java库，可以读取和写入Microsoft Office格式的文档，包括Excel文件。可以使用POI库的XSSF类来读取和写入Excel文件。

2. 使用JExcelAPI库：JExcelAPI是一个Java库，可以读取和写入Microsoft Excel格式的文件。可以使用JExcelAPI库的Workbook类来读取和写入Excel文件。

3. 使用Java Excel API库：Java Excel API是一个Java库，可以读取和写入Microsoft Excel格式的文件。可以使用Java Excel API库的Workbook类来读取和写入Excel文件。

示例代码：

使用POI库读取Excel文件：

File file = new File("test.xlsx");
FileInputStream inputStream = new FileInputStream(file);
Workbook workbook = new XSSFWorkbook(inputStream);

Sheet sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(0);
Cell cell = row.getCell(0);

String value = cell.getStringCellValue();
System.out.println(value);

inputStream.close();

使用POI库写入Excel文件：

File file = new File("test.xlsx");
FileOutputStream outputStream = new FileOutputStream(file);
Workbook workbook = new XSSFWorkbook();

Sheet sheet = workbook.createSheet("Sheet1");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("Hello World!");

workbook.write(outputStream);
outputStream.close();

使用JExcelAPI库读取Excel文件：

File file = new File("test.xls");
Workbook workbook = Workbook.getWorkbook(file);

Sheet sheet = workbook.getSheet(0);
Cell cell = sheet.getCell(0, 0);

String value = cell.getContents();
System.out.println(value);

workbook.close();

使用JExcelAPI库写入Excel文件：

File file = new File("test.xls");
WritableWorkbook workbook = Workbook.createWorkbook(file);

WritableSheet sheet = workbook.createSheet("Sheet1", 0);
Label label = new Label(0, 0, "Hello World!");

sheet.addCell(label);

workbook.write();
workbook.close();

使用Java Excel API库读取Excel文件：

File file = new File("test.xls");
Workbook workbook = Workbook.getWorkbook(file);

Sheet sheet = workbook.getSheet(0);
Cell cell = sheet.getCell(0, 0);

String value = cell.getContents();
System.out.println(value);

workbook.close();

使用Java Excel API库写入Excel文件：

File file = new File("test.xls");
WritableWorkbook workbook = Workbook.createWorkbook(file);

WritableSheet sheet = workbook.createSheet("Sheet1", 0);
Label label = new Label(0, 0, "Hello World!");

sheet.addCell(label);

workbook.write();
workbook.close();