java 读取excel 转换csv_多个 EXCEL 文件如何合并成一个文件
时间: 2023-11-22 22:56:22 浏览: 81
Java 读取 Excel 文件可以使用 Apache POI 库,将读取的数据转换成 CSV 格式可以使用 OpenCSV 库。以下是一个将多个 Excel 文件合并成一个 CSV 文件的示例代码:
```java
import java.io.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import com.opencsv.CSVWriter;
public class ExcelToCsvConverter {
public static void main(String[] args) throws Exception {
String[] inputFiles = {"file1.xlsx", "file2.xlsx", "file3.xlsx"};
String outputFileName = "output.csv";
// Create CSV writer
CSVWriter writer = new CSVWriter(new FileWriter(outputFileName));
for (String inputFile : inputFiles) {
// Open Excel file
FileInputStream file = new FileInputStream(new File(inputFile));
Workbook workbook = new XSSFWorkbook(file);
// Get first sheet
Sheet sheet = workbook.getSheetAt(0);
// Loop through rows and write to CSV
for (Row row : sheet) {
String[] rowData = new String[row.getLastCellNum()];
for (int i = 0; i < row.getLastCellNum(); i++) {
Cell cell = row.getCell(i);
if (cell == null) {
rowData[i] = "";
} else {
rowData[i] = cell.toString();
}
}
writer.writeNext(rowData);
}
// Close Excel file
file.close();
workbook.close();
}
// Close CSV writer
writer.close();
}
}
```
此代码将多个 Excel 文件读取到内存中,然后将每个文件的第一个工作表写入一个 CSV 文件。你可以根据需要进行修改以满足自己的需求。