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.

  public void bug47090a() {
      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 bug47090b() {
      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

  
    @Test
  public void bug47090d() {
      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

    private XSSFPivotTable pivotTable;
    
    @Override
    public void setUp(){
        Workbook wb = new XSSFWorkbook();
        XSSFSheet sheet = (XSSFSheet) wb.createSheet();


        Row row1 = sheet.createRow(0);
        // Create a cell and put a value in it.
        Cell cell = row1.createCell(0);
        cell.setCellValue("Names");

View Full Code Here

        // create a new file
        FileOutputStream out = new FileOutputStream("workbook.xls");
        // create a new workbook
        Workbook wb = new HSSFWorkbook();
        // create a new sheet
        Sheet s = wb.createSheet();
        // declare a row object reference
        Row r = null;
        // declare a cell object reference
        Cell c = null;
        // create 3 cell styles

View Full Code Here

        //end draw thick black border




        // demonstrate adding/naming and deleting a sheet
        // create a sheet, set its title then delete it
        s = wb.createSheet();
        wb.setSheetName(1, "DeletedSheet");
        wb.removeSheetAt(1);
        //end deleted sheet


        // write the workbook to the output stream

View Full Code Here

public class ExcelExporter extends Exporter {


    @Override
  public void export(FacesContext context, DataTable table, String filename, boolean pageOnly, int[] excludeColumns, String encodingType, MethodExpression preProcessor, MethodExpression postProcessor) throws IOException {      
      Workbook wb = new HSSFWorkbook();
      Sheet sheet = wb.createSheet();
      List<UIColumn> columns = getColumnsToExport(table, excludeColumns);
      int numberOfColumns = columns.size();
        String rowIndexVar = table.getRowIndexVar();
      if(preProcessor != null) {
        preProcessor.invoke(context.getELContext(), new Object[]{wb});

View Full Code Here

 * How to set spklit and freeze panes
 */
public class SplitAndFreezePanes {
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        Sheet sheet3 = wb.createSheet("third sheet");
        Sheet sheet4 = wb.createSheet("fourth sheet");


        // Freeze just one row

View Full Code Here

 */
public class SplitAndFreezePanes {
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        Sheet sheet3 = wb.createSheet("third sheet");
        Sheet sheet4 = wb.createSheet("fourth sheet");


        // Freeze just one row
        sheet1.createFreezePane(0, 1, 0, 1);

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.