Examples of CreationHelper

org.apache.poi.ss.usermodel.CreationHelper
An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF. Works around a major shortcoming in Java, where we can't have static methods on interfaces or abstract classes. This allows you to get the appropriate class for a given interface, without you having to worry about if you're dealing with HSSF or XSSF, despite Java being quite rubbish.
org.zkoss.poi.ss.usermodel.CreationHelper

Examples of org.apache.poi.ss.usermodel.CreationHelper

       
       // Sheet 1 doesn't (yet)
       assertNull(sh1.getCommentsTable(false));
       
       // Try to add comments to Sheet 1
       CreationHelper factory = wb.getCreationHelper();
       Drawing drawing = sh1.createDrawingPatriarch();


       ClientAnchor anchor = factory.createClientAnchor();
       anchor.setCol1(0);
       anchor.setCol2(4);
       anchor.setRow1(0);
       anchor.setRow2(1);


       Comment comment1 = drawing.createCellComment(anchor);
       comment1.setString(
             factory.createRichTextString("I like this cell. It's my favourite."));
       comment1.setAuthor("Bob T. Fish");
       
       anchor = factory.createClientAnchor();
       anchor.setCol1(0);
       anchor.setCol2(4);
       anchor.setRow1(1);
       anchor.setRow2(1);
       Comment comment2 = drawing.createCellComment(anchor);
       comment2.setString(
             factory.createRichTextString("This is much less fun..."));
       comment2.setAuthor("Bob T. Fish");


       Cell c1 = sh1.getRow(0).createCell(4);
       c1.setCellValue(2.3);
       c1.setCellComment(comment1);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

     */
    @Test
    public void bug48325() {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet("Test");
        CreationHelper factory = wb.getCreationHelper();


        XSSFRow row = sheet.createRow(0);
        XSSFCell cell = row.createCell(0);


        XSSFFont font = wb.createFont();
        RichTextString rts = factory.createRichTextString("");
        rts.applyFont(font);
        cell.setCellValue(rts);


        sheet.autoSizeColumn(0);
    }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

        byte pictureDataWmf[] = POIDataSamples.getSlideShowInstance().readFile("santa.wmf");
        int indexWmf = wb.addPicture(pictureDataWmf, HSSFWorkbook.PICTURE_TYPE_WMF);


        HSSFSheet sheet = wb.createSheet();
        HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
        CreationHelper ch = wb.getCreationHelper();


        ClientAnchor anchor = ch.createClientAnchor();
        anchor.setCol1(2);
        anchor.setCol2(5);
        anchor.setRow1(1);
        anchor.setRow2(6);
        patriarch.createPicture(anchor, indexEmf);
        
        anchor = ch.createClientAnchor();
        anchor.setCol1(2);
        anchor.setCol2(5);
        anchor.setRow1(10);
        anchor.setRow2(16);
        patriarch.createPicture(anchor, indexPng);


        anchor = ch.createClientAnchor();
        anchor.setCol1(6);
        anchor.setCol2(9);
        anchor.setRow1(1);
        anchor.setRow2(6);
        patriarch.createPicture(anchor, indexWmf);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper


    public void testRemoveHyperlink(){
        Workbook wb = _testDataProvider.createWorkbook();
        Sheet sh = wb.createSheet("test");
        Row row = sh.createRow(0);
        CreationHelper helper = wb.getCreationHelper();


        Cell cell1 = row.createCell(1);
        Hyperlink link1 = helper.createHyperlink(Hyperlink.LINK_URL);
        cell1.setHyperlink(link1);
        assertNotNull(cell1.getHyperlink());
        cell1.removeHyperlink();
        assertNull(cell1.getHyperlink());


        Cell cell2 = row.createCell(0);
        Hyperlink link2 = helper.createHyperlink(Hyperlink.LINK_URL);
        cell2.setHyperlink(link2);
        assertNotNull(cell2.getHyperlink());
        cell2.setHyperlink(null);
        assertNull(cell2.getHyperlink());

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

                    xlCellStyle.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM);
                    break;
            }


            if (dataFormat != null) {
                CreationHelper createHelper = xlWorkbook.getCreationHelper();
                xlCellStyle.setDataFormat(createHelper.createDataFormat()
                        .getFormat(dataFormat));
            }


            xlCellStyles.put(new ExcelCellStyleAttributes(fg, bg, fontData,
                    dataFormat, hAlign, vAlign, vertical), xlCellStyle);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

                sh.autoSizeColumn(prop);
            }
        }


        protected CellStyle createDateFormatCellStyle(final Workbook wb) {
            CreationHelper createHelper = wb.getCreationHelper();
            SimpleDateFormat dateInstance = (SimpleDateFormat) DateFormat.getDateInstance(DateFormat.MEDIUM);
            String pattern = dateInstance.toPattern();
            short dateFormat = createHelper.createDataFormat().getFormat(pattern);
            CellStyle dateCellStyle = wb.createCellStyle();
            dateCellStyle.setDataFormat(dateFormat);
            return dateCellStyle;
        }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

        File.separator + "WithMoreVariousData.xlsx"
    );
    assertTrue(xml.exists());
      
    XSSFWorkbook workbook = new XSSFWorkbook(xml.toString());
    CreationHelper createHelper = workbook.getCreationHelper();
    assertEquals(3, workbook.getNumberOfSheets());
    XSSFSheet sheet = (XSSFSheet)workbook.getSheetAt(0);


    // Check hyperlinks
    assertEquals(4, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
    
    
    // Write out, and check


    // Load up again, check all links still there
    XSSFWorkbook wb2 = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertEquals(3, wb2.getNumberOfSheets());
    assertNotNull(wb2.getSheetAt(0));
    assertNotNull(wb2.getSheetAt(1));
    assertNotNull(wb2.getSheetAt(2));
    
    sheet = (XSSFSheet)wb2.getSheetAt(0);


    
    // Check hyperlinks again
    assertEquals(4, sheet.getNumHyperlinks());
    doTestHyperlinkContents(sheet);
    
    
    // Add one more, and re-check
    Row r17 = sheet.createRow(17);
    Cell r17c = r17.createCell(2);
    
    Hyperlink hyperlink = createHelper.createHyperlink(Hyperlink.LINK_URL);
    hyperlink.setAddress("http://poi.apache.org/spreadsheet/");
    hyperlink.setLabel("POI SS Link");
    r17c.setHyperlink(hyperlink);
    
    assertEquals(5, sheet.getNumHyperlinks());

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

                sh.autoSizeColumn(prop);
            }
        }


        protected CellStyle createDateFormatCellStyle(final Workbook wb) {
            CreationHelper createHelper = wb.getCreationHelper();
            SimpleDateFormat dateInstance = (SimpleDateFormat) DateFormat.getDateInstance(DateFormat.MEDIUM);
            String pattern = dateInstance.toPattern();
            short dateFormat = createHelper.createDataFormat().getFormat(pattern);
            CellStyle dateCellStyle = wb.createCellStyle();
            dateCellStyle.setDataFormat(dateFormat);
            return dateCellStyle;
        }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.CreationHelper

          row.createCell(0).setCellValue(1);
          //4.2 text 
          row.createCell(1).setCellValue("Text");
        
          //4.3 date cell
          CreationHelper createHelper = wb.getCreationHelper();
          CellStyle cellStyle = wb.createCellStyle();
          cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("m/d/yy h:mm"));
          Cell cell = row.createCell(2);
          cell.setCellValue(new Date());
          cell.setCellStyle(cellStyle);
  
          //4.4 boolean cell

View Full Code Here

Examples of org.zkoss.poi.ss.usermodel.CreationHelper

  
  public static Set<Ref>[] setCellHyperlink(Cell cell, int linkTarget, String address) {
    Hyperlink hlink = cell.getHyperlink();
    if (hlink == null) {
      Workbook wb = cell.getSheet().getWorkbook();
      CreationHelper createHelper = wb.getCreationHelper();
      Hyperlink link = createHelper.createHyperlink(linkTarget);
      link.setAddress(address);
      
      cell.setHyperlink(link);
    } else {

View Full Code Here

0 1 2 3 4 5

TOP

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.