poi 导出合并execl 的单元格,根据其中的某一列的值合并

int [] field_arr ={0,1,6,7,8,9}; //要合并的数据为那几列
for(int m =0;m <field_arr.length;m++){
    int field = field_arr[m];
    int begin =1;
    int end =1;
    int onId =0;
    int type =0; //根据类型判断的参数
    for(int j =0;j<rest.size();j++){
        List<Object> vou = (List<Object>) rest.get(j);
        int begin1 =1;
        begin1 =begin;
        int end1 =1;
        if(type ==0) {
            onId =Integer.parseInt( vou.get(10).toString());
            type =1;
            end ++;
            if(end ==rest.size()+1){
            end1 =end-1;
            hssfSheet.addMergedRegion(new CellRangeAddress(begin1, end1, field, field));
         }      
      }        else {
                int onlyId1 = Integer.parseInt( vou.get(10).toString());//当前的onlyId
                if(onlyId1==onId ) {
                    end++;
                   
                }
                else {
                    end1 =end-1;
                    hssfSheet.addMergedRegion(new CellRangeAddress(begin1, end1, field, field));
                    begin =end++;
                    end =end++;
                    type =0; //设置type=0 然后给onlyId 重新赋值
                }
        }
    }
}

版权声明:本文为a863922230原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。