Package jxl

Examples of jxl.Sheet


    }
    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))
    {
View Full Code Here


  /**
   *
   */
  private void readHeader()
  {
    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

                Renderer.instance().render("/simple.xhtml");

                DocumentData data = (DocumentData) Contexts.getEventContext().get("testExport");
                Workbook workbook = Workbook.getWorkbook(new ByteArrayInputStream(((ByteArrayDocumentData)data).getData()));
                Sheet sheet = workbook.getSheet("Developers");
               
                assert sheet != null;

                assert "Daniel Roth".equals(sheet.getCell(0, 0).getContents());
                assert "Nicklas Karlsson".equals(sheet.getCell(0, 1).getContents());

            }
        }.run();
    }
View Full Code Here

  protected String extractText(InputStream inputStream) throws IOException {
    StringBuffer text=new StringBuffer();
    try {
      Workbook workbook=Workbook.getWorkbook(inputStream);
      for(int cpt = 0; cpt<workbook.getNumberOfSheets(); cpt++) {
        Sheet sheet = workbook.getSheet(cpt);
        extractTextFromSheet(sheet,text);
      }
    } catch(BiffException ex) {
      ex.printStackTrace();
    }
View Full Code Here

    public void parseFile(InputStream inStream) {
        try {
            Workbook workbook = Workbook.getWorkbook( inStream );

            if ( _useFirstSheet ) {
                Sheet sheet = workbook.getSheet( 0 );
                processSheet( sheet,
                              (List) _listners.get( DEFAULT_RULESHEET_NAME ) );
            } else {
                Set sheetNames = _listners.keySet();
                for ( Iterator iter = sheetNames.iterator(); iter.hasNext(); ) {
                    String sheetName = (String) iter.next();
                    Sheet sheet = workbook.getSheet( sheetName );
                    processSheet( sheet,
                                  (List) _listners.get( sheetName ) );

                }
            }
View Full Code Here

    int colEnd, rowEnd;
    int index = 0;
    String filename = "E:/���ж��˵�/2012/3.xls";

    ExcelService eService = new ExcelService();
    Sheet rs = eService.getSheet(filename, index);
    rowEnd = rs.getRows();
    // rowEnd = 10000;
    colEnd = rs.getColumns();
    Map<Point, String> result = eService.readExcel(rs, rowBegin, rowEnd, colBegin, colEnd);

    String sql = "insert into data_to_import "
        + "(SETTLE_DATE, PAN, ACC_TYPE, TXN_NAME, TXN_AMT, FEE_AMT, CNAME, TID, SP_MID, SP_TID, TRACE1, RRN, TXN_DATE, TRANS_ID, AERA ) "
        + " values (?,?,?,?,?,?,?,?,?,?,?,?,?,SEQ_DATA_TO_IMPORT.NEXTVAL,?)";
View Full Code Here

    }
    return result;
  }

  public Map<Point, String> readExcel(String filename) throws BiffException, IOException {
    Sheet rs = getSheet(filename, 0);
    return readExcel(rs, 0, rs.getRows(), 0, rs.getColumns());
  }
View Full Code Here

  }

  public Sheet getSheet(String filename, int index) throws BiffException, IOException {
    InputStream is = null;
    Workbook rwb = null;
    Sheet rs = null;
    try {
      is = new FileInputStream(filename);
      rwb = Workbook.getWorkbook(is);
      rs = rwb.getSheet(0);
    } finally {
View Full Code Here

   * @throws BiffException
   * @throws IOException
   */
  public Map<Point, String> readExcel(String filename, int index, int rowBegin, int rowEnd, int colBegin, int colEnd)
      throws BiffException, IOException {
    Sheet rs = getSheet(filename, 0);
    return readExcel(rs, rowBegin, rowEnd, colBegin, colEnd);
  }
View Full Code Here

    int rowBegin = 0;
    String filename = "d:/user/sfhq083/����/���ж��˵�/2011.5�����ж��˵�.xls";
    String target = "E:/���ж��˵�/2011/5.xls";

    ExcelService eService = new ExcelService();
    Sheet rs = eService.getSheet(filename, index);
    rowEnd = rs.getRows();
    // rowEnd = 10000;
    colEnd = rs.getColumns();
    Map<Point, String> result = eService.readExcel(rs, rowBegin, rowEnd, colBegin, colEnd);

    eService.writeExcel(result, target, rowBegin, rowEnd, colBegin, colEnd);

  }
View Full Code Here

TOP

Related Classes of jxl.Sheet

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.