Examples of org.apache.poi.ss.usermodel.Workbook.createSheet()

Class org.apache.poi.ss.usermodel.Workbook

Examples of org.apache.poi.ss.usermodel.Workbook.createSheet()

org.apache.poi.ss.usermodel.Workbook.createSheet()
Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return Sheet representing the new sheet.

     *
     * @author Philippe Laflamme
     */
    public void testBug48936() throws IOException {
        Workbook w = new XSSFWorkbook();
        Sheet s = w.createSheet();
        int i = 0;
        List<String> lst = readStrings("48936-strings.txt");
        for (String str : lst) {
            s.createRow(i++).createCell(0).setCellValue(str);
        }

View Full Code Here

public class ExcelExporter extends Exporter {


    @Override
  public void export(FacesContext context, DataTable table, String filename, boolean pageOnly, boolean selectionOnly, String encodingType, MethodExpression preProcessor, MethodExpression postProcessor) throws IOException {      
      Workbook wb = new HSSFWorkbook();
      Sheet sheet = wb.createSheet();
        
      if(preProcessor != null) {
        preProcessor.invoke(context.getELContext(), new Object[]{wb});
      }

View Full Code Here

    // Cloner cloner=new Cloner();


    // System.out.println(System.currentTimeMillis());
    for (int i = 0; i < book.getNumberOfSheets(); i++) {
      Sheet sheet = book.getSheetAt(i);
      Sheet newSheet = newBook.createSheet(sheet.getSheetName());
      copySheets(newSheet, sheet);
    }
    // newBook=cloner.deepClone(book);


    // System.out.println(System.currentTimeMillis());

View Full Code Here

  public void testBug47090a() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
    assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet2", "Sheet1");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet1");
  }

View Full Code Here

  public void testBug47090b() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.removeSheetAt(1);
    assertSheetOrder(workbook, "Sheet1");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet1", "Sheet0");    // Sheet0 because it uses "Sheet" + sheets.size() as starting point!
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet1", "Sheet0");
  }

View Full Code Here

  }
  
  public void testBug47090d() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet1", "Sheet2", "Sheet0");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2", "Sheet0");
      workbook.createSheet();  
    assertSheetOrder(workbook, "Sheet2", "Sheet0", "Sheet1");

View Full Code Here

      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet1", "Sheet2", "Sheet0");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2", "Sheet0");
      workbook.createSheet();  
    assertSheetOrder(workbook, "Sheet2", "Sheet0", "Sheet1");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet0", "Sheet1");
  }

View Full Code Here


    public void testApplyCellForGeneralFormat() {
        
        // Create a workbook, row and cell to test with
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = wb.createSheet();
        Row row = sheet.createRow(0);
        Cell cell0 = row.createCell(0);
        Cell cell1 = row.createCell(1);
        Cell cell2 = row.createCell(2);
        Cell cell3 = row.createCell(3);

View Full Code Here

    
    public void testApplyCellForAtFormat() {
        
        // Create a workbook, row and cell to test with
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = wb.createSheet();
        Row row = sheet.createRow(0);
        Cell cell0 = row.createCell(0);
        Cell cell1 = row.createCell(1);
        Cell cell2 = row.createCell(2);
        Cell cell3 = row.createCell(3);

View Full Code Here

    
    public void testApplyCellForDateFormat() {
        
        // Create a workbook, row and cell to test with
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = wb.createSheet();
        Row row = sheet.createRow(0);
        Cell cell0 = row.createCell(0);
        Cell cell1 = row.createCell(1);
        
        CellFormat cf = CellFormat.getInstance("dd/mm/yyyy");

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.