poi解析csv
时间: 2023-08-21 22:01:39 浏览: 88
您可以使用Apache POI库解析CSV文件。下面是一个使用POI库解析CSV文件的示例代码:
```java
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class CsvToExcelConverter {
public static void main(String[] args) throws IOException {
String csvFilePath = "path/to/csv/file.csv";
String excelFilePath = "path/to/excel/file.xlsx";
BufferedReader reader = new BufferedReader(new FileReader(csvFilePath));
XSSFWorkbook workbook = new XSSFWorkbook();
Row row;
Cell cell;
int rowIndex = 0;
String line;
while ((line = reader.readLine()) != null) {
row = workbook.createSheet().createRow(rowIndex++);
String[] values = line.split(",");
for (int i = 0; i < values.length; i++) {
cell = row.createCell(i);
cell.setCellValue(values[i]);
}
}
workbook.write(new FileOutputStream(excelFilePath));
workbook.close();
reader.close();
}
}
```
这个示例代码将CSV文件转换为Excel文件,使用了Apache POI的XSSFWorkbook类来创建Excel工作簿,并使用BufferedReader来读取CSV文件的内容。您可以根据您的需求修改和调整此代码。