Package jxl

Examples of jxl.Cell

248
249
250
251
252
253
254
255
    excelView.setUrl("template");
    excelView.render(new HashMap(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template", cell.getContents());
  }
View Full Code Here
278
279
280
281
282
283
284
285
    excelView.setUrl("template");
    excelView.render(new HashMap(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template American English", cell.getContents());
  }
View Full Code Here
308
309
310
311
312
313
314
315
    excelView.setUrl("template");
    excelView.render(new HashMap(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template auf Deutsch", cell.getContents());
  }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
143
144
145
  private String globalTimeFormat = null;
  private TimeZone globalTimeZone = TimeZone.getDefault();

  private void loadConfig( Workbook _xlsWorkbook )
  {
    final Cell gtFormatCell = _xlsWorkbook.findCellByName( "GlobalTimeFormat" );
    if (null != gtFormatCell) {
      this.globalTimeFormat = gtFormatCell.getCellFormat().getFormat().getFormatString();
    }
    final Cell gtZoneNameCell = _xlsWorkbook.findCellByName( "GlobalTimeZoneName" );
    if (null != gtZoneNameCell) {
      this.globalTimeZone = TimeZone.getTimeZone( gtZoneNameCell.getContents() );
    }
  }
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
271
272
273
  {
    if (_styles.containsKey( _styleName )) {
      return _styles.get( _styleName );
    }
    else {
      final Cell styleCell = getTemplateCell( _styleName );
      if (null != styleCell) {
        final CellView styleFormat = _isRow ? this.templateSheet.getRowView( styleCell.getRow() )
            : this.templateSheet.getColumnView( styleCell.getColumn() );
        final CellView targetFormat = new CellView();

        copyRowOrColAttributes( styleFormat, targetFormat );

        _styles.put( _styleName, targetFormat );
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
     
      Sheet sheet = workbook.getSheet(sheetName);
       
        int startRow, startCol, endRow, endCol, ci, cj;
       
        Cell tableStart = sheet.findCell(tableName);
        startRow = tableStart.getRow();
        startCol = tableStart.getColumn();

        Cell tableEnd= sheet.findCell(tableName, startCol+1,startRow+1, 100, 64000,  false);               

        endRow=tableEnd.getRow();
        endCol=tableEnd.getColumn();
       
        LOGGER.debug("startRow="+startRow+", endRow="+endRow+", startCol="+startCol+", endCol="+endCol);
       
        tableArray = new String[endRow-startRow-1][endCol-startCol-1];
        ci=0;
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
     
        for (int numeroDeColonne : colonnesALire) {
         
         
          String valeurDeLaCellule;
          Cell cellule = feuilleTrajets.getCell(numeroDeColonne,numeroDeLigne);
         
          if (cellule.getType() == CellType.DATE) {
            //Une cellule de feuille de calcul qui contient une date
            DateCell celluleDate = (DateCell) cellule;
            Date date = celluleDate.getDate();
            valeurDeLaCellule = new SimpleDateFormat(MotsCleProjet.TIME_FORMAT).format(date);
          } else {
            valeurDeLaCellule = cellule.getContents();
          }
            ligne.put(numeroDeColonne,valeurDeLaCellule);
      }
      trajetListener.onTrajet(ligne.get(0), decodeurTrajet.decode(ligne));
    }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
            Cell[] row = sheet.getRow( i );
            newRow( listeners,
                    i,
                    row.length );
            for ( int cellNum = 0; cellNum < row.length; cellNum++ ) {
                Cell cell = row[cellNum];

                Range merged = getRangeIfMerged( cell,
                                                 mergedRanges );

                if ( merged != null ) {
                    Cell topLeft = merged.getTopLeft();
                    newCell( listeners,
                             i,
                             cellNum,
                             topLeft.getContents(),
                             topLeft.getColumn() );
                } else {
                    newCell( listeners,
                             i,
                             cellNum,
                             cell.getContents(),
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
    Range getRangeIfMerged(Cell cell,
                           Range[] mergedRanges) {
        for ( int i = 0; i < mergedRanges.length; i++ ) {
            Range r = mergedRanges[i];
            Cell topLeft = r.getTopLeft();
            Cell bottomRight = r.getBottomRight();
            if ( cell.getRow() >= topLeft.getRow() && cell.getRow() <= bottomRight.getRow() && cell.getColumn() >= topLeft.getColumn() && cell.getColumn() <= bottomRight.getColumn() ) {
                return r;
            }
        }
        return null;
    }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
      Workbook book = Workbook.getWorkbook(new File(excel_file_name));
      sl = new ArrayList();
      for (int s = 0; s < sheet_count; s++) {
        Sheet sheet = book.getSheet(s);
        al = new ArrayList();
        Cell cellKey;
        Cell cellValue;
        for (int i = 0; i < column_count; i++) {
          List columndatas = new ArrayList();
          cellKey = sheet.getCell(i, i);
          for (int k = 0; k < row_count; k++) {
            cellValue = sheet.getCell(i, k);
            // System.out.println("��:" + (k + 1) + "�е�" + (i + 1) +
            // "��ֵ��:"+ cellValue.getContents());
            columndatas.add(cellValue.getContents());
          }// end for k
          al.add(columndatas);// ��һ�����ݷ�װ���ܵ�list��
        }// end for i
        book.close();
      }// end if s
View Full Code Here
TOP

Related Classes of jxl.Cell

  • baseconocimiento.ArchivoExcelBaseConocimiento
  • br.eti.kinoshita.selenium.DataDrivenSeleniumWebTest
  • com.nexirius.multimail.datamodel.ImportArrayModel
  • com.vsked.excel.ExcelOperate
  • importation.xls.XlsTourneeImportateur
  • jxl.biff.CellFinder
  • jxl.demo.Demo
  • jxl.demo.Features
  • jxl.demo.Formulas
  • net.sf.jasperreports.engine.data.JRXlsDataSource
    • 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.