1
PoiTransformer transformer = PoiTransformer.createTransformer(is, os);
        AreaBuilder areaBuilder = new XlsCommentAreaBuilder(transformer, false);
        List<Area> xlsAreaList = areaBuilder.build();

        int curSheetSize = 3;
        for(int i = 1; i < 1; i++) {
            Area mainArea = xlsAreaList.get(i);
            Area loopArea = mainArea.getCommandDataList().get(0).getCommand().getAreaList().get(0);
            loopArea.addAreaListener(new JxlsAreaListener(transformer, i));

            switch (i) {
                case 1 :
                    mainArea.applyAt(new CellRef("KOR!A1"), context);
                    break;
                case 2 :
                    mainArea.applyAt(new CellRef("JPN!A1"), context);                       
                    break;
                case 3 :
                    mainArea.applyAt(new CellRef("FRA!A1"), context);
                    break;
                case 4 :
                    mainArea.applyAt(new CellRef("AUS!A1"), context);
                    break;
                case 5 :
                    mainArea.applyAt(new CellRef("UK!A1"), context);
                    break;
                case 6 :
                    mainArea.applyAt(new CellRef("CAN!A1"), context);
                    break;
                case 7 :
                    mainArea.applyAt(new CellRef("MEX!A1"), context);
                    break;
            }

            mainArea.processFormulas();
        }

       transformer.write();

        is.close();
        os.close();

I hope the memo is deleted in the Excel file made from template. please.

is templete enter image description here

is Files created from templates enter image description here

RoyDaddy
  • 11
  • 1

0 Answers0