Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.Sheet

73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
    _workbook = null;
  }
 
  @Test
  public void testCellNumberFormatter() {
    Sheet sheet1 = _workbook.getSheet("Sheet1");
    Row row2 = sheet1.getRow(1);
    Row row3 = sheet1.getRow(2);
    Row row4 = sheet1.getRow(3);
    Row row5 = sheet1.getRow(4);
    Row row6 = sheet1.getRow(5);
    Row row7 = sheet1.getRow(6);
    Row row8 = sheet1.getRow(7);
    Row row9 = sheet1.getRow(8);
    Row row10 = sheet1.getRow(9);
 
    testOneRow(row2); // 1/4
    testOneRow(row3); // 21/25
    testOneRow(row4); // 312/943
    testOneRow(row5); // 1/2
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
   */
  public static int shiftSheetLeft(Spreadsheet spreadsheet) {
    final Book book = spreadsheet.getBook();
    if (book != null) {
      String name = spreadsheet.getSelectedSheet().getSheetName();
      Sheet sheet = spreadsheet.getSelectedSheet();
      int index = book.getSheetIndex(sheet);
      if (index > 0) {
        int newIdx = index - 1;
        book.setSheetOrder(name, index - 1);
        return newIdx;
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
   */
  public static int shiftSheetRight(Spreadsheet spreadsheet) {
    final Book book = spreadsheet.getBook();
    if (book != null) {
      String name = spreadsheet.getSelectedSheet().getSheetName();
      Sheet sheet = spreadsheet.getSelectedSheet();
      int index = book.getSheetIndex(sheet);
      if (index < book.getNumberOfSheets() - 1) {
        int newIdx = index + 1;
        book.setSheetOrder(name, newIdx);
        SpreadsheetCtrl ctrl = (SpreadsheetCtrl) spreadsheet.getExtraCtrl();
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
  public void onRangeAdd() {
    final Book book = spreadsheet.getBook();
    if (book == null) {
      return;
    }
    Sheet sheet = spreadsheet.getSelectedSheet();
    int sheetindex = book.getSheetIndex(sheet);
    int left = spreadsheet.getSelection().getLeft();
    int top = spreadsheet.getSelection().getTop();
    int right = spreadsheet.getSelection().getRight();
    int bottom = spreadsheet.getSelection().getBottom();
View Full Code Here
72
73
74
75
76
77
78
79
80
81
    _workbook = null;
  }
 
  @Test
  public void testCellNumberFormatter() {
    Sheet sheet1 = _workbook.getSheet("Sheet1");
    Row row2 = sheet1.getRow(1);
 
    testCell(row2, 0, " -   "); //1 space - 3 spaces
  }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
    if (book == null) {
      return;
    }
    int numSheet = book.getNumberOfSheets();
    for (int i = 0; i < numSheet; i++) {
      Sheet sheet = ss.getSheet(i);
      PrintSetup setup = sheet.getPrintSetup();
      setup.setLandscape(isLandscape);
    }
  }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
    if (book == null) {
      return;
    }
    int numSheet = book.getNumberOfSheets();
    for (int i = 0; i < numSheet; i++) {
      Sheet sheet = ss.getSheet(i);
      PrintSetup setup = sheet.getPrintSetup();
      setup.setLandscape(orgOrientation);
    }
  }
View Full Code Here
113
114
115
116
117
118
119
120
121
    if (book == null) {
      return;
    }
    int numSheet = book.getNumberOfSheets();
    for (int i = 0; i < numSheet; i++) {
      Sheet sheet = ss.getSheet(i);
      PrintSetup setup = sheet.getPrintSetup();
    }
  }
View Full Code Here
125
126
127
128
129
130
131
132
133
    if (book == null) {
      return;
    }
    int numSheet = book.getNumberOfSheets();
    for (int i = 0; i < numSheet; i++) {
      Sheet sheet = ss.getSheet(i);
      PrintSetup setup = sheet.getPrintSetup();
    }
  }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
    _workbook = null;
  }
 
  @Test
  public void testCellNumberFormatter() {
    Sheet sheet1 = _workbook.getSheet("Sheet1");
    Row row2 = sheet1.getRow(1);
    Row row3 = sheet1.getRow(2);
    Row row4 = sheet1.getRow(3);
    Row row5 = sheet1.getRow(4);
    Row row6 = sheet1.getRow(5);
    Row row7 = sheet1.getRow(6);
    Row row8 = sheet1.getRow(7);
    Row row9 = sheet1.getRow(8);
    Row row10 = sheet1.getRow(9);
 
    testOneRow(row2); // 1/4
    testOneRow(row3); // 21/25
    testOneRow(row4); // 312/943
    testOneRow(row5); // 1/2
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.usermodel.Sheet

  • org.zkoss.zss.app.file.ExportToHtmlWindowCtrl
  • org.zkoss.zss.app.file.ExportToPdfWindowCtrl
  • org.zkoss.zss.app.RangeHelper
  • org.zkoss.zss.app.sheet.SheetHelper
  • org.zkoss.zss.model.impl.Book14XlsTextFormatTest
  • org.zkoss.zss.model.impl.Book14XlsxTextFormatTest
  • org.zkoss.zss.model.impl.Book16XlsTextFormatTest
    • 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.