Package com.aspose.cells

Examples of com.aspose.cells.Workbook.save()

16
17
18
19
20
21
22
23
24
25
    //Copy data to a new sheet from an existing
    //sheet within the Workbook.
    sheets.addCopy("Sheet1");

    //Save the excel file.
    wb.save("data/AsposeCopyWorkbook.xls");
   
    System.out.println("Sheet copied successfully."); // Print Message
  }
}
View Full Code Here
20
21
22
23
24
25
26
27
28
29
        worksheet2.moveTo(0);
        worksheet1.moveTo(1);
        worksheet3.moveTo(2);

    //Save the excel file.
        workbook.save("data/AsposeMoveSheet.xls");
   
    System.out.println("Sheet moved successfully."); // Print Message
  }
}
View Full Code Here
17
18
19
20
21
22
23
24
25
26
    //Setting the zoom factor of the worksheet to 75    
    worksheet.setZoom(75);

    //Saving the modified Excel file in default format
    workbook.save("data/AsposeZoom.xls");
   
    System.out.println("Aspose Zoom Created.");
  }
}
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
   
    //Input data into C6 Cell.
    worksheet.getCells().get(5,2).setValue("This is a test of merging");
   
    //Save the Workbook.
    wbk.save("data/merge_Aspose.xls");
   
    // Print message
    System.out.println("Process completed successfully");
  }
}
View Full Code Here
8
9
10
11
12
13
14
15
16
17
  public static void main(String[] args) throws Exception
  {
    Workbook workbook = new Workbook(); // Creating a Workbook object

    //Workbooks can be saved in many formats
    workbook.save("data/newWorkBook_Aspose.xlsx", FileFormatType.XLSX);

    System.out.println("Worksheets are saved successfully."); // Print Message
  }
}
View Full Code Here
41
42
43
44
45
46
47
48
49
50
    //Saving the modified style to the "A1" cell.
    cell.setStyle(style);

    //Saving the Excel file
    workbook.save("data/AsposeBorders.xls");

    System.out.println("Aspose Borders Created.");
  }
}
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
    //Adding a new worksheet to the Workbook object
    WorksheetCollection worksheets = workbook.getWorksheets();
    Worksheet worksheet = worksheets.add("My Worksheet");

    //Saving the Excel file
        workbook.save("data/newWorksheet_Aspose.xls");
       
        //Print Message
        System.out.println("Sheet added successfully.");
  }
}
View Full Code Here
22
23
24
25
26
27
28
29
30
31
    // Specifying the cells range (from A1 cell to F20 cell) of the print area
    pageSetup.setPrintArea("A1:F20");

    // Workbooks can be saved in many formats
    workbook.save("data/AsposePrintArea.xlsx", FileFormatType.XLSX);

    System.out.println("Print Area Set successfully."); // Print Message
  }
}
View Full Code Here
36
37
38
39
40
41
42
43
44
45
    //font.setSubscript(true);

    cell.setStyle(style);

    //Saving the modified Excel file in default format
    workbook.save("data/AsposeFonts.xls");
   
    System.out.println("Aspose Fonts Created.");
  }
}
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
        //Applying freeze panes settings
        worksheet1.freezePanes(0,2,0,2); // Freezing Columns
        worksheet2.freezePanes(2,0,2,0); // Freezing Rows    

        //Saving the modified Excel file in default format
        workbook.save("data/workbook_Aspose.xls");
       
        //Print Message
        System.out.println("Panes freeze successfull.");
  }
}
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.