如何把excel数据导入java

发布网友 发布时间：2022-04-20 19:10

我来回答

共2个回答

热心网友 时间：2023-09-18 07:30

用第三方组件poi读取，给个例子你参考一下
public class ApachePOIExcelRead {

private static final String FILE_NAME = "/tmp/MyFirstExcel.xlsx";

public static void main(String[] args) {

try {

FileInputStream excelFile = new FileInputStream(new File(FILE_NAME));
Workbook workbook = new XSSFWorkbook(excelFile);
Sheet datatypeSheet = workbook.getSheetAt(0);
Iterator<Row> iterator = datatypeSheet.iterator();

while (iterator.hasNext()) {

Row currentRow = iterator.next();
Iterator<Cell> cellIterator = currentRow.iterator();

while (cellIterator.hasNext()) {

Cell currentCell = cellIterator.next();
//getCellTypeEnum shown as deprecated for version 3.15
//getCellTypeEnum ill be renamed to getCellType starting from version 4.0
if (currentCell.getCellTypeEnum() == CellType.STRING) {
System.out.print(currentCell.getStringCellValue() + "--");
} else if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
System.out.print(currentCell.getNumericCellValue() + "--");
}

}
System.out.println();

}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}

}
}

热心网友 时间：2023-09-18 07:31

poi 搜索下 这个 试一试