Package jxl

Examples of jxl.Cell


    if (columnIndex == null)
    {
      throw new JRException("Unknown column name : " + fieldName);
    }
    Sheet sheet = workbook.getSheet(0);
    Cell cell = sheet.getCell(columnIndex.intValue(), recordIndex);
    String fieldValue = cell.getContents();
    Class valueClass = jrField.getValueClass();
   
    if (valueClass.equals(String.class))
    {
      return fieldValue;
View Full Code Here


    Sheet sheet = workbook.getSheet(0);
    if (columnNames.size() == 0)
    {
      for(int columnIndex = 0; columnIndex < sheet.getColumns(); columnIndex++)
      {
        Cell cell = sheet.getCell(columnIndex, recordIndex);
        String columnName = cell.getContents();
        if (columnName != null && columnName.trim().length() > 0)
        {
          columnNames.put(columnName, Integer.valueOf(columnIndex));
        }
      }
    }
    else
    {
      Map newColumnNames = new HashMap();
      for(Iterator it = columnNames.values().iterator(); it.hasNext();)
      {
        Integer columnIndex = (Integer)it.next();
        Cell cell = sheet.getCell(columnIndex.intValue(), recordIndex);
        String columnName = cell.getContents();
       
        newColumnNames.put(columnName, columnIndex);
      }
      columnNames = newColumnNames;
    }
View Full Code Here

  }

  protected void extractTextFromSheet(Sheet sheet, StringBuffer text) throws IOException {
    for(int cptRow = 0; cptRow<sheet.getRows(); cptRow++) {
      for(int cptColumn = 0; cptColumn<sheet.getColumns(); cptColumn++) {
        Cell cell = sheet.getCell(cptColumn,cptRow);
        String cellText = cell.getContents();
        if( cellText!=null && cellText.length()>0 ) {
          appendText(text, cellText);
        }
      }
    }
View Full Code Here

            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

    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

    }
    Map<Point, String> result = new HashMap<Point, String>();
    int i, j;
    for (i = rowBegin; i < rowEnd; i++) {
      for (j = colBegin; j < colEnd; j++) {
        Cell c = rs.getCell(j, i);
        String s = c.getContents();
        result.put(new Point(j, i), s);
      }
    }
    return result;
  }
View Full Code Here

  }
 

  private String getString(Sheet sheet, int row, int col)
  {
    Cell cell = sheet.getCell(row,col);
    if (cell.getType() != CellType.LABEL)
      throw new RuntimeException("Expected cell type to be string at "+row+","+col);
   
    return  ((LabelCell) cell).getString();
  }
View Full Code Here

    return  ((LabelCell) cell).getString();
  }
 
  private Date getDate(Sheet sheet, int row, int col)
  {
    Cell cell = sheet.getCell(row,col);
    if (cell.getType() != CellType.DATE)
      throw new RuntimeException("Expected cell type to be date at "+row+","+col);
   
    return  ((DateCell) cell).getDate();
  }
View Full Code Here

    return  ((DateCell) cell).getDate();
  }
 
  private double getNumber(Sheet sheet, int row, int col)
  {
    Cell cell = sheet.getCell(row,col);
    if (cell.getType() != CellType.NUMBER)
      throw new RuntimeException("Expected cell type to be date at "+row+","+col);
   
    return  ((NumberCell) cell).getValue();
  }
View Full Code Here

            Cell[] row = sheet.getRow( i );
            newRow( listeners,
                    i,
                    row.length );
            for ( int cellNum = 0; cellNum < row.length; cellNum++ ) {
                Cell cell = row[cellNum];
                double num = 0;

                Range merged = getRangeIfMerged( cell,
                                                 mergedRanges );

                if ( merged != null ) {
                    Cell topLeft = merged.getTopLeft();
                    newCell( listeners,
                             i,
                             cellNum,
                             topLeft.getContents(),
                             topLeft.getColumn() );                   
                } else {
                  if (cell.getType() == CellType.NUMBER) {
                    NumberCell nc = (NumberCell) cell;
                    num = nc.getValue();
                  }                 
View Full Code Here

TOP

Related Classes of jxl.Cell

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.