Package org.apache.poi.hssf.util

Examples of org.apache.poi.hssf.util.Region

800
801
802
803
804
805
806
807
808
809
810
                MergeBlock merge = it.next();
                if (merge.include(y, x)) {
                    if (x == merge.getStartColumn() && y == merge.getStartRow()) {
                        x2 = (short) (x + merge.getColumnSpan());
                        y2 = (short) (y + merge.getRowSpan());
                        xlsSheet.addMergedRegion(new Region(y, x, y2, x2));

                        break;
                    }
                }
            }
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
        HSSFRow row = sheet.createRow((short) 0);
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue(new HSSFRichTextString(categorie
            .getDiscipline().getNom()));

        sheet.addMergedRegion(new Region(0, (short) 0, 0, (short) 1));

        cell = row.createCell((short) 2);
        cell.setCellValue(new HSSFRichTextString(categorie.getNom()));

        sheet.addMergedRegion(new Region(0, (short) 2, 0, (short) 5));

        cell = row.createCell((short) 6);
        cell.setCellValue(new HSSFRichTextString(categorie.getSexe()));

        HSSFUtils.applyStyle(row, style);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
 
  public void testCloneSheetBasic(){
    try{
      HSSFWorkbook b = new HSSFWorkbook();
      HSSFSheet s = b.createSheet("Test");
      s.addMergedRegion(new Region((short)0,(short)0,(short)1,(short)1));
      HSSFSheet clonedSheet = b.cloneSheet(0);
     
      assertEquals("One merged area", 1, clonedSheet.getNumMergedRegions());

    }
View Full Code Here
717
718
719
720
721
722
723
724
     * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)}
     */
    public Region getMergedRegionAt(int index) {
        CellRangeAddress cra = getMergedRegion(index);

        return new Region(cra.getFirstRow(), (short)cra.getFirstColumn(),
                cra.getLastRow(), (short)cra.getLastColumn());
    }
View Full Code Here
723
724
725
726
727
728
729
730
     * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)}
     */
    public Region getMergedRegionAt(int index) {
        CellRangeAddress cra = getMergedRegion(index);

        return new Region(cra.getFirstRow(), (short)cra.getFirstColumn(),
                cra.getLastRow(), (short)cra.getLastColumn());
    }
View Full Code Here
656
657
658
659
660
661
662
663
     * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)}
     */
    public Region getMergedRegionAt(int index) {
        CellRangeAddress cra = getMergedRegion(index);
       
        return new Region(cra.getFirstRow(), (short)cra.getFirstColumn(),
                cra.getLastRow(), (short)cra.getLastColumn());
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
            if (headerRow <= 0) {
                headerRow = HEADER_ROW;
            }
            headerRow = Math.min(headerRow, MAX_ROWS);
            for (int h = 0, lenH = headers.length; h < lenH; h++) {
                @SuppressWarnings("deprecation")
                Region region = new Region(0, (short) h, (short) headerRow - 1, (short) h);// 合并从第rowFrom行columnFrom列
                sheet.addMergedRegion(region);// 到rowTo行columnTo的区域
                // 得到所有区域
                sheet.getNumMergedRegions();
                if (cellWidth > 0) {
                    sheet.setColumnWidth(h, cellWidth);
View Full Code Here
731
732
733
734
735
736
737
738
     * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)}
     */
    public Region getMergedRegionAt(int index) {
        CellRangeAddress cra = getMergedRegion(index);

        return new Region(cra.getFirstRow(), (short)cra.getFirstColumn(),
                cra.getLastRow(), (short)cra.getLastColumn());
    }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
                           final ElementProcessor parent)
        throws IOException
    {
        super.initialize(attributes, parent);
       
        Region region = new Region(getStartRow(),
                                   (short)getStartCol(),
                                   getEndRow(),                                  
                                   (short)getEndCol());
       
//        if (region.getRowFrom() == 0 &&
//            region.getColumnFrom() ==0)
//            getLogger().debug("got 0,0");
     
        getLogger().debug("region area is "+region.getArea());
        if(region.getArea() < MAX_AREA) {  //protect against stupid mega regions
                                       //of generally NOTHING and no real
                                       //puprose created by gnumeric
            getLogger().debug("region added");
            _style = getSheet().addStyleRegion(region
                                      ); //test
View Full Code Here
321
322
323
324
325
326
327
328
329
330
331
332
333
334
     */
     HSSFCellStyle getCellStyleForRegion(short row, short col) {
        Iterator iregions = regions.keySet().iterator();       
       
        while (iregions.hasNext()) {
            Region region = ((Region) iregions.next());
//            if (col == 1)
//                getLogger().debug("breakpoint support");
            if ( region.contains(row, col) ) {
                //getLogger().debug("Returning style for " + row +"," + col);
                return (HSSFCellStyle) regions.get( region );
            }
        }
        //getLogger().debug("returning null for "+row+","+col);
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.util.Region

  • com.jfinal.ext.render.excel.PoiKit
  • net.fqsc.inscriptions.view.component.principalcontent.admin.evenements.reports.plaques.ListePlaquePanel
  • net.loyin.jFinal.render.excel.ExcelKit
  • no.ugland.utransprod.util.excel.ExcelUtil
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPCell
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPMerge
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPStyleRegion
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.Sheet
  • org.apache.poi.hssf.record.cf.CellRange
  • org.apache.poi.hssf.usermodel.examples.MergedCells
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.