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 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);
        // Freeze just one column

View Full Code Here

    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);
        // Freeze just one column
        sheet2.createFreezePane(1, 0, 1, 0);

View Full Code Here


public class SelectedSheet {


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


        Sheet sheet2 = wb.createSheet("another sheet");
        Sheet sheet3 = wb.createSheet(" sheet 3 ");
        sheet3.setSelected(true);
        wb.setActiveSheet(2);

View Full Code Here


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


        Sheet sheet2 = wb.createSheet("another sheet");
        Sheet sheet3 = wb.createSheet(" sheet 3 ");
        sheet3.setSelected(true);
        wb.setActiveSheet(2);


        // Create various cells and rows for spreadsheet.

View Full Code Here

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


        Sheet sheet2 = wb.createSheet("another sheet");
        Sheet sheet3 = wb.createSheet(" sheet 3 ");
        sheet3.setSelected(true);
        wb.setActiveSheet(2);


        // Create various cells and rows for spreadsheet.

View Full Code Here

 * An example of how to merge regions of cells.
 */
public class MergingCells {
    public static void main(String[] args) throws Exception {
        Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();
        Sheet sheet = wb.createSheet("new sheet");


        Row row = sheet.createRow((short) 1);
        Cell cell = row.createCell((short) 1);
        cell.setCellValue(new XSSFRichTextString("This is a test of merging"));

View Full Code Here

    public void testColumnWidthCompatibility() {
        Workbook wb1 = new HSSFWorkbook();
        Workbook wb2 = new XSSFWorkbook();


        Sheet sh1 = wb1.createSheet();
        Sheet sh2 = wb2.createSheet();


        assertEquals(sh1.getDefaultColumnWidth(), sh2.getDefaultColumnWidth());


        //if column width is not set, HSSF returns a wrong value which does not take into account
        //margins and borders, it is always less than the actual column width

View Full Code Here

    public void testRowHeightCompatibility(){
        Workbook wb1 = new HSSFWorkbook();
        Workbook wb2 = new XSSFWorkbook();


        Sheet sh1 = wb1.createSheet();
        Sheet sh2 = wb2.createSheet();


        sh2.setDefaultRowHeight(sh1.getDefaultRowHeight());


        assertEquals(sh1.getDefaultRowHeight(), sh2.getDefaultRowHeight());

View Full Code Here

     *  be doing... Someone who understands the goals a little
     *  better should really review this!
     */
    public void testSetColumnGroupCollapsed(){
      Workbook wb = new XSSFWorkbook();
      XSSFSheet sheet1 =(XSSFSheet) wb.createSheet();


      CTCols cols=sheet1.getCTWorksheet().getColsArray(0);
      assertEquals(0,cols.sizeOfColArray());


      sheet1.groupColumn( (short)4, (short)7 );

View Full Code Here

     *  be doing... Someone who understands the goals a little
     *  better should really review this!
     */
    public void testSetRowGroupCollapsed(){
      Workbook wb = new XSSFWorkbook();
      XSSFSheet sheet1 = (XSSFSheet)wb.createSheet();


      sheet1.groupRow( 5, 14 );
      sheet1.groupRow( 7, 14 );
      sheet1.groupRow( 16, 19 );

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.