Examples of XSSFWorkbook

org.apache.poi.xssf.usermodel.XSSFWorkbook
High level representation of a SpreadsheetML workbook. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level object for creating new sheets/etc.
org.zkoss.poi.xssf.usermodel.XSSFWorkbook

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

    assertFalse(workbook.isWindowsLocked());
    assertFalse(workbook.isStructureLocked());
  }


  public void testShouldWriteStructureLock() throws Exception {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("workbookProtection_not_protected.xlsx");
    assertFalse(workbook.isStructureLocked());


    workbook.lockStructure();


    assertTrue(workbook.isStructureLocked());


    workbook.unLockStructure();


    assertFalse(workbook.isStructureLocked());
  }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook


    assertFalse(workbook.isStructureLocked());
  }


  public void testShouldWriteWindowsLock() throws Exception {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("workbookProtection_not_protected.xlsx");
    assertFalse(workbook.isWindowsLocked());


    workbook.lockWindows();


    assertTrue(workbook.isWindowsLocked());


    workbook.unLockWindows();


    assertFalse(workbook.isWindowsLocked());
  }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook


    assertFalse(workbook.isWindowsLocked());
  }


  public void testShouldWriteRevisionLock() throws Exception {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("workbookProtection_not_protected.xlsx");
    assertFalse(workbook.isRevisionLocked());


    workbook.lockRevision();


    assertTrue(workbook.isRevisionLocked());


    workbook.unLockRevision();


    assertFalse(workbook.isRevisionLocked());
  }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook


    assertFalse(workbook.isRevisionLocked());
  }


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


    wb.lockRevision();


    File tempFile = File.createTempFile("workbookProtection", ".xlsx");
    FileOutputStream out = new FileOutputStream(tempFile);
    wb.write(out);
    out.close();


    FileInputStream inputStream = new FileInputStream(tempFile);
    XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
    inputStream.close();


    assertTrue(workbook.isRevisionLocked());
  }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

    assertEquals(6, cc7.getRow());
    assertEquals(2, cc7.getColumn());
  }


  public void testWriteRead() {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("WithVariousData.xlsx");
    XSSFSheet sheet1 = workbook.getSheetAt(0);
    XSSFSheet sheet2 = workbook.getSheetAt(1);


    assertTrue( sheet1.hasComments() );
    assertFalse( sheet2.hasComments() );


    // Change on comment on sheet 1, and add another into
    //  sheet 2
    Row r5 = sheet1.getRow(4);
    Comment cc5 = r5.getCell(2).getCellComment();
    cc5.setAuthor("Apache POI");
    cc5.setString(new XSSFRichTextString("Hello!"));


    Row r2s2 = sheet2.createRow(2);
    Cell c1r2s2 = r2s2.createCell(1);
    assertNull(c1r2s2.getCellComment());


    Comment cc2 = sheet2.createComment();
    cc2.setAuthor("Also POI");
    cc2.setString(new XSSFRichTextString("A new comment"));
    c1r2s2.setCellComment(cc2);




    // Save, and re-load the file
    workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);


    // Check we still have comments where we should do
    sheet1 = workbook.getSheetAt(0);
    sheet2 = workbook.getSheetAt(1);
    assertNotNull(sheet1.getRow(4).getCell(2).getCellComment());
    assertNotNull(sheet1.getRow(6).getCell(2).getCellComment());
    assertNotNull(sheet2.getRow(2).getCell(1).getCellComment());


    // And check they still have the contents they should do

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

    assertEquals("Hello!",
        sheet1.getRow(4).getCell(2).getCellComment().getString().getString());
  }


  public void testReadWriteMultipleAuthors() {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("WithMoreVariousData.xlsx");
    XSSFSheet sheet1 = workbook.getSheetAt(0);
    XSSFSheet sheet2 = workbook.getSheetAt(1);


    assertTrue( sheet1.hasComments() );
    assertFalse( sheet2.hasComments() );


    assertEquals("Nick Burch",
        sheet1.getRow(4).getCell(2).getCellComment().getAuthor());
    assertEquals("Nick Burch",
        sheet1.getRow(6).getCell(2).getCellComment().getAuthor());
    assertEquals("Torchbox",
        sheet1.getRow(12).getCell(2).getCellComment().getAuthor());


    // Save, and re-load the file
    workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);


    // Check we still have comments where we should do
    sheet1 = workbook.getSheetAt(0);
    assertNotNull(sheet1.getRow(4).getCell(2).getCellComment());
    assertNotNull(sheet1.getRow(6).getCell(2).getCellComment());
    assertNotNull(sheet1.getRow(12).getCell(2).getCellComment());


    // And check they still have the contents they should do

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

    Workbook retval = null;
    
    //
    if ( this.useXLSXFileFormat() )
    {
      retval = new XSSFWorkbook( inputStream );
    }
    else
    {
      retval = new HSSFWorkbook( new POIFSFileSystem( inputStream ) );
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

         if (is.available() == 0)
         {
            return "";
         }


         XSSFWorkbook wb;
         try
         {
            wb = SecurityHelper.doPrivilegedIOExceptionAction(new PrivilegedExceptionAction<XSSFWorkbook>()
            {
               public XSSFWorkbook run() throws Exception
               {
                  return new XSSFWorkbook(is);
               }
            });
         }
         catch (IOException e)
         {
            throw new DocumentReadException("Can't open spreadsheet.", e);
         }
         catch (OpenXML4JRuntimeException e)
         {
            return builder.toString();
         }
         for (int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++)
         {
            XSSFSheet sheet = wb.getSheetAt(sheetNum);
            if (sheet != null)
            {
               for (int rowNum = sheet.getFirstRowNum(); rowNum <= sheet.getLastRowNum(); rowNum++)
               {
                  XSSFRow row = sheet.getRow(rowNum);

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

      reader.readDCProperties(SecurityHelper
         .doPrivilegedIOExceptionAction(new PrivilegedExceptionAction<XSSFWorkbook>()
         {
            public XSSFWorkbook run() throws Exception
            {
               return new XSSFWorkbook(is);
            }
         }));


      return reader.getProperties();
   }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

    this.title = title;
  }
  
  public XSSFWorkbook getWorkbook() {
    try {
      return new XSSFWorkbook(is);
    } catch (IOException e) {
      throw new ExcelConversionException(e);
    }
  }

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.