Package com.aspose.cells

Examples of com.aspose.cells.CellArea

14
15
16
17
18
19
20
21
22
23
24
   
    //Get the Cells collection in the first worksheet
    Cells cells = workbook.getWorksheets().get(0).getCells();
   
    //Create a cellarea i.e.., B3:C19
    CellArea ca = new CellArea();
    ca.StartRow = 2;
    ca.StartColumn =1;
    ca.EndRow = 18;
    ca.EndColumn = 2;
   
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
   
    //Define the second key
    sorter.setKey2(1);
   
    //Create a cells area (range).
    CellArea ca = new CellArea();
   
    //Specify the start row index.
    ca.StartRow = 1;
    //Specify the start column index.
    ca.StartColumn = 0;
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
   
    //Get the Cells collection in the first worksheet
    Cells cells = workbook.getWorksheets().get(0).getCells();
   
    //Create a cellarea i.e.., B3:C19
    CellArea ca = new CellArea();
    ca.StartRow = 2;
    ca.StartColumn =1;
    ca.EndRow = 18;
    ca.EndColumn = 2;
   
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    //Create an arraylist object
    //Get the merged cells list to put it into the arraylist object      
    ArrayList<CellArea> al = worksheet.getCells().getMergedCells();
   
    //Define cellarea
    CellArea ca;
   
    //Define some variables
    int frow, fcol, erow, ecol;
   
    // Print Message
    System.out.println("Merged Areas: \n"+ al.toString());
   
    //Loop through the arraylist and get each cellarea to unmerge it
    for(int i = al.size()-1 ; i > -1; i--)
    {
      ca = new CellArea();
      ca = (CellArea)al.get(i);
      frow = ca.StartRow;
      fcol = ca.StartColumn;
      erow = ca.EndRow;
      ecol = ca.EndColumn;
View Full Code Here
TOP

Related Classes of com.aspose.cells.CellArea

  • aspose.cells.AsposeCalculateSubTotals
  • cells.datahandling.AsposeDataSort
  • cells.formula.AsposeCreateSubTotals
  • cells.merge.AsposeDetectMergeCells
    • Copyright © 2018 www.massapicom. 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.