Package org.apache.poi.xssf.usermodel.helpers

Examples of org.apache.poi.xssf.usermodel.helpers.ColumnHelper

449
450
451
452
453
454
455
456
457
        XSSFSheet sheet = workbook.createSheet("Sheet 1");
        sheet.createRow(0).createCell(13).setCellValue("test");

        sheet.autoSizeColumn((short)13);

        ColumnHelper columnHelper = sheet.getColumnHelper();
        CTCol col = columnHelper.getColumn(13, false);
        assertTrue(col.getBestFit());
    }
View Full Code Here
452
453
454
455
456
457
458
459
460
461
462
463
464
    }
   
    public void testAutoSizeColumn() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
        ColumnHelper columnHelper = sheet.getColumnHelper();
        CTCol col = columnHelper.getColumn(13, false);
        assertNull(col);
        sheet.autoSizeColumn((short)13);
        col = columnHelper.getColumn(13, false);
        assertNotNull(col);
        assertTrue(col.getBestFit()); 
    }
View Full Code Here
159
160
161
162
163
164
165
166
167
        XSSFSheet sheet = workbook.createSheet("Sheet 1");
        sheet.createRow(0).createCell(13).setCellValue("test");

        sheet.autoSizeColumn(13);

        ColumnHelper columnHelper = sheet.getColumnHelper();
        CTCol col = columnHelper.getColumn(13, false);
        assertTrue(col.getBestFit());
    }
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
        } catch (XmlException e){
            throw new POIXMLException(e);
        }

        initRows(worksheet);
        columnHelper = new ColumnHelper(worksheet);

        // Look for bits we're interested in
        for(POIXMLDocumentPart p : getRelations()){
            if(p instanceof CommentsTable) {
               sheetComments = (CommentsTable)p;
View Full Code Here
163
164
165
166
167
168
169
170
     */
    @Override
    protected void onDocumentCreate(){
        worksheet = newSheet();
        initRows(worksheet);
        columnHelper = new ColumnHelper(worksheet);
        hyperlinks = new ArrayList<XSSFHyperlink>();
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.usermodel.helpers.ColumnHelper

  • org.apache.poi.ss.util.CellRangeAddress
  • org.apache.poi.xssf.usermodel.TestXSSFSheet
  • org.apache.poi.xssf.usermodel.XSSFSheet
  • org.apache.poi.xssf.util.CTColComparator
  • org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol
  • org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols
  • java.text.NumberFormat
  • java.awt.geom.AffineTransform
  • java.text.AttributedString
  • java.text.DecimalFormat
    • 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.