1、这里用到的是xxx.xlsx的excel表,如果用.xls的旧版excel表可能会报错,需要自己调整代码
(简单的测试,取出内容根据业务自行处理)
public static void main(String[] args) throws Exception { File file = new File("D:\\test001\\qhData.xlsx"); FileInputStream inputStream = new FileInputStream(file); XSSFWorkbook wb = new XSSFWorkbook(inputStream); XSSFSheet sheet = wb.getSheetAt(0); //读取excel的第一行 XSSFRow row1 = sheet.getRow(0); for(int i = 0; i < row1.getLastCellNum(); i++){ //循环打印(此行)的每一列内容 System.out.println(row1.getCell(i)); //订单编号, ORDER_NO, LOWER(B1) } }