<dependency><groupId>net.sourceforge.jexcelapi</groupId><artifactId>jxl</artifactId><version>2.6.12</version></dependency>二、表格操作

1、讀取xls文件

測試文件為：

代碼：

public void test() throws IOException, BiffException {// 1、獲取文件,創(chuàng)建workbookFile file = new File('D:/test/自動化監(jiān)測數(shù)據(jù)上傳模板20210525.xls');Workbook workbook = Workbook.getWorkbook(file);// 2.獲取第一個工作表Sheet sheet = workbook.getSheet(0);// 3.獲取表中數(shù)據(jù)Range[] rangecell = sheet.getMergedCells();System.out.println('行：' + sheet.getRows());System.out.println('列：' + sheet.getColumns());for (int i = 0; i < sheet.getRows(); i++) { for (int j = 0; j < sheet.getColumns(); j++) {Cell cell = sheet.getCell(j, i);String contents = cell.getContents();System.out.print(contents + ' '); } System.out.println();}workbook.close(); }

輸出結(jié)果（注意合并單元格處，需要特殊處理）：

改造代碼如下：

public void test() throws IOException, BiffException {// 1、獲取文件,創(chuàng)建workbookFile file = new File('D:/test/自動化監(jiān)測數(shù)據(jù)上傳模板20210525.xls');Workbook workbook = Workbook.getWorkbook(file);// 2.獲取第一個工作表Sheet sheet = workbook.getSheet(0);// 3.獲取表中數(shù)據(jù)// 返回合并單元格數(shù)據(jù)Range[] rangecell = sheet.getMergedCells();System.out.println('行：' + sheet.getRows());System.out.println('列：' + sheet.getColumns());for (int i = 0; i < sheet.getRows(); i++) { for (int j = 0; j < sheet.getColumns(); j++) {Cell cell = sheet.getCell(j, i);String contents = cell.getContents();// 判斷當前單元格，是否為合并單元格for (Range r : rangecell) { if (i > r.getTopLeft().getRow() && i <= r.getBottomRight().getRow() && j >= r.getTopLeft().getColumn() && j <= r.getBottomRight().getColumn()) {contents = sheet.getCell(r.getTopLeft().getColumn(), r.getTopLeft().getRow()).getContents(); }}System.out.print(contents + ' '); } System.out.println();}workbook.close(); }

結(jié)果：

到此這篇關(guān)于java實現(xiàn)對excel文件的處理合并單元格的文章就介紹到這了,更多相關(guān)java excel文件合并單元格內(nèi)容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)！