来一个excel导入的java的工具类
时间: 2024-03-05 11:53:57 浏览: 23
好的,以下是一个使用Apache POI库实现的Excel导入的Java工具类:
```java
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
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.ss.usermodel.WorkbookFactory;
public class ExcelReader {
public static List<List<String>> readExcel(File file) throws IOException {
List<List<String>> data = new ArrayList<>();
Workbook workbook = WorkbookFactory.create(new FileInputStream(file));
Sheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowIterator = sheet.rowIterator();
while (rowIterator.hasNext()) {
List<String> rowData = new ArrayList<>();
Row row = rowIterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
switch (cell.getCellType()) {
case STRING:
rowData.add(cell.getStringCellValue());
break;
case NUMERIC:
rowData.add(String.valueOf(cell.getNumericCellValue()));
break;
case BOOLEAN:
rowData.add(String.valueOf(cell.getBooleanCellValue()));
break;
default:
rowData.add("");
break;
}
}
data.add(rowData);
}
workbook.close();
return data;
}
}
```
这个工具类可以读取Excel文件的第一个工作表并将其转换为一个二维字符串列表,每个列表代表一行数据,每个元素代表一个单元格的值。你可以根据自己的需求修改代码。