Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet()

Class org.apache.poi.xssf.usermodel.XSSFWorkbook

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet()

org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet()
Create an XSSFSheet for this workbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return XSSFSheet representing the new sheet.

        assertTrue(newCol.getHidden());
    }


    public void testGetOrCreateColumn() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
        ColumnHelper columnHelper = sheet.getColumnHelper();
        CTCol col = columnHelper.getOrCreateColumn(3, false);
        assertNotNull(col);
        assertNotNull(columnHelper.getColumn(3, false));

View Full Code Here

        final Workbook wb = new XSSFWorkbook();
        final String sheetName =  cls.getSimpleName();
        final File tempFile = File.createTempFile(ExcelConverter.class.getName(), sheetName + XLSX_SUFFIX);


        final FileOutputStream fos = new FileOutputStream(tempFile);
        final Sheet sheet = wb.createSheet(sheetName);
        
        final ExcelConverter.RowFactory rowFactory = new RowFactory(sheet);
        final Row headerRow = rowFactory.newRow();
        
        // header row

View Full Code Here

        hlink_font.setUnderline(Font.U_SINGLE);
        hlink_font.setColor(IndexedColors.BLUE.getIndex());
        hlink_style.setFont(hlink_font);


        Cell cell;
        Sheet sheet = wb.createSheet("Hyperlinks");
        //URL
        cell = sheet.createRow(0).createCell((short)0);
        cell.setCellValue("URL Link");


        Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_URL);

View Full Code Here

        cell.setCellStyle(hlink_style);


        //link to a place in this workbook


        //create a target sheet and cell
        Sheet sheet2 = wb.createSheet("Target Sheet");
        sheet2.createRow(0).createCell((short)0).setCellValue("Target Cell");


        cell = sheet.createRow(3).createCell((short)0);
        cell.setCellValue("Worksheet Link");
        Hyperlink link2 = createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT);

View Full Code Here




  public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();
        CreationHelper creationHelper = wb.getCreationHelper();
        Sheet sheet = wb.createSheet("new sheet");


        // Create a row and put some cells in it. Rows are 0 based.
        Row row = sheet.createRow((short)0);
        // Create a cell and put a value in it.
        Cell cell = row.createCell((short)0);

View Full Code Here

    public static void main(String[] args) throws IOException {
        Workbook wb = new XSSFWorkbook();


        CreationHelper factory = wb.getCreationHelper();


        Sheet sheet = wb.createSheet();


        Cell cell1 = sheet.createRow(3).createCell(5);
        cell1.setCellValue("F4");


        Drawing drawing = sheet.createDrawingPatriarch();

View Full Code Here

        assertTrue(newCol.getHidden());
    }


    public void testGetOrCreateColumn() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet("Sheet 1");
        ColumnHelper columnHelper = sheet.getColumnHelper();


        // Check POI 0 based, OOXML 1 based
        CTCol col = columnHelper.getOrCreateColumn1Based(3, false);
        assertNotNull(col);

View Full Code Here

        assertNull(columnHelper.getColumn(30, false));
    }


    public void testGetSetColDefaultStyle() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CTWorksheet ctWorksheet = sheet.getCTWorksheet();
        ColumnHelper columnHelper = sheet.getColumnHelper();


        // POI column 3, OOXML column 4
        CTCol col = columnHelper.getOrCreateColumn1Based(4, false);

View Full Code Here

    assertFalse(workbook.isRevisionLocked());
  }


  public void testIntegration() throws Exception {
    XSSFWorkbook wb = new XSSFWorkbook();
    wb.createSheet("Testing purpose sheet");
    assertFalse(wb.isRevisionLocked());


    wb.lockRevision();


    File tempFile = TempFile.createTempFile("workbookProtection", ".xlsx");

View Full Code Here

        if(chart == null) throw new IllegalStateException("chart not found in the template");


        // embedded Excel workbook that holds the chart data
        POIXMLDocumentPart xlsPart = chart.getRelations().get(0);
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet();


        CTChart ctChart = chart.getCTChart();
        CTPlotArea plotArea = ctChart.getPlotArea();


        CTPieChart pieChart = plotArea.getPieChartArray(0);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.