excel导入导出

最新推荐文章于 2025-05-19 18:00:00 发布

原创最新推荐文章于 2025-05-19 18:00:00 发布 · 248 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了如何使用ExportXLSUtil类进行Excel数据的导出和导入操作，包括创建工作簿、生成工作表、填充数据、读取数据等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


public class ExportXLSUtil {

	public static void export(String filePath, Object[][] values) {
		WritableWorkbook book = null;
		try {
			book = Workbook.createWorkbook(new File(filePath));
			WritableSheet sheet = book.createSheet("Sheet_1", 0);
			for (int i = 0; i < values.length; i++) {
				for (int j = 0; j < values[i].length; j++) {
					String value = (String) values[i][j];
					Label label = new Label(i, j, value);
					sheet.addCell(label);
				}
			}
			book.write();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		} finally {
			try {
				if (book != null) {
					book.close();
				}
			} catch (WriteException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}

	public static void importExl(String filePath) {
		Workbook book = null;
		try {
			book = Workbook.getWorkbook(new File(filePath));
			Sheet sheet = book.getSheet(0);
			int column = sheet.getColumns();
			int rows = sheet.getRows();
			for (int i = 0; i < column; i++) {
				for (int j = 0; j < rows; j++) {
					Cell cell = sheet.getCell(i, j);
					String result = cell.getContents();
					System.out.println(result);
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (book != null) {
				book.close();
			}
		}
	}
}