excel2007格式的

最新推荐文章于 2022-02-25 23:47:59 发布

lauphai

最新推荐文章于 2022-02-25 23:47:59 发布

阅读量87

点赞数

文章标签： J# C C++ C#

本文链接：https://blog.csdn.net/lauphai/article/details/83883863

版权


public static ArrayList read_xlsx(String path_sour, String path_end) {
		ArrayList al = new ArrayList();
		//String strPath = "c://22.xlsx";
		XSSFWorkbook xwb = null;
		try {
			xwb = new XSSFWorkbook(path_sour);
			// 读取第一章表格内容
			XSSFSheet sheet = xwb.getSheetAt(0);
			// 定义 row、cell
			XSSFRow row = null;
			@SuppressWarnings("unused")
			String cell = "";
			// 循环输出表格中的内容
			int row_num_1 = sheet.getFirstRowNum();
			int row_num_end = sheet.getLastRowNum();
			//System.out.println(sheet.getPhysicalNumberOfRows());

			for (int i = row_num_1; i < row_num_end; i++) {
				row = sheet.getRow(i);
//				for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++) {
//					// 通过 row.getCell(j).toString() 获取单元格内容，
//					cell = row.getCell(j).toString();
//					System.out.print(cell + "\t");
//				}
				// 通过 row.getCell(j).toString() 获取单元格内容
				if (row.getCell(1).toString().equals("")) {
					// break;
				} else {
					String[] str = new String[2];
					// cell = row.getCell(1).toString();
					// cell = row.getCell(2).toString();
					str[0] = row.getCell(1).toString();
					str[1] = path_end + row.getCell(2).toString();
					al.add(str);
				}
				// System.out.print(cell + "\t");
			}
			for (int i = 0; i < al.size(); i++) {
				System.out.println(((String[]) al.get(i))[0]);
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		return al;
	}