java实现对excel文件的处理合并单元格的操作

<dependency>

     <groupid>net.sourceforge.jexcelapi</groupid>

     <artifactid>jxl</artifactid>

     <version> 2.6 . 12 </version>

</dependency>

public void test() throws ioexception, biffexception {

         // 1、获取文件,创建workbook

         file file = new file( "d:/test/自动化监测数据上传模板20210525.xls" );

         workbook workbook = workbook.getworkbook(file);

         // 2.获取第一个工作表

         sheet sheet = workbook.getsheet( 0 );

         // 3.获取表中数据

         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();

     }

public void test() throws ioexception, biffexception {

         // 1、获取文件,创建workbook

         file file = new file( "d:/test/自动化监测数据上传模板20210525.xls" );

         workbook workbook = workbook.getworkbook(file);

         // 2.获取第一个工作表

         sheet sheet = workbook.getsheet( 0 );

         // 3.获取表中数据

         // 返回合并单元格数据

         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();

     }