Java 导入excel中有合并的单元格

Question

导入到合并的单元格就会提示有问题报null，该怎么办

Answer 1

给你个小例子，你慢慢测试动动手

    //把数据结构单门写在一个类中
            List<DataForExcel> list = new ArrayList<>();
            int i = 1;
            for (TCComponent component:results)
            {
                //获得属性值
                String[] itemAttributes = component.getProperties(new String[]{"item_id", "object_name"});
                TCComponentItem item = (TCComponentItem)component;
                TCComponentItemRevision rev = item.getLatestItemRevision();
                String[] revAttributes = rev.getProperties(new String[]{"item_revision_id", "creation_date", "object_desc"});

                int number = rev.getRelated("IMAN_specification").length;
                //将值递给构造函数
                DataForExcel dataExcel = new DataForExcel(i, itemAttributes[0],itemAttributes[1] , number, revAttributes[0], "", revAttributes[1], "", revAttributes[2]);
                i++;
                //添加到集合中
                list.add(dataExcel);
            }


            ExcelReader exc = new ExcelReader();
            try {
                exc.readTemplet(list, start, end, TemplatePath);//把list集合值传给导出excel的函数
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            };