CF9 broke poi.jar reference.... please help

That is a weird one. I am not very familiar with the effects of compiling against a different version. Since you say it worked after you recompiled, maybe there is some linkage there. I will have to read up on that.

BTW: You can also get a NoMethodFound error even when there is only one version of a jar in your class loader. Though I do not think it applies in your case, it can happen if you are using multiple class loaders. Class loaders only recognize objects they loaded. So you could load the exact same class (from the same jar) in second class loader and it would be not recognized by the first. Even though it is exactly the same.

Anyway, I am glad to here you got it sorted out .. and exactly how you fixed it.

-Leigh

What version of poi is Adobe loading in CF9?  

Version 3.5-beta7-20090726

Could it be that the file now in the lib folder named

poi.jar is getting in the way of the class path loaded

poi.jar one we've been using??

Yep. That is a distinct possibility. Try removing the jar, restarting and see if it resolves the error.

-Leigh

Apologies in advance for being verbose, but here is the whole file here.

package com.lxe.importer;

import java.io.*;
import java.util.*;
import java.text.*;
import org.apache.poi.poifs.filesystem.*;
import org.apache.poi.hssf.usermodel.*;

/**
* Provides a way to retrieve the contents of a grid of Excel spreadsheet
* cells as delimeted strings.  This class represents one XLS file.
* 
* @author stan
* @version 1.00, Jan 27, 2004
*/
final class ExcelImporter implements Importer {
private final String xlsFile;
private DataDescriptor dataDescriptor = null;

public ExcelImporter(String xlsFile) {
  this.xlsFile = xlsFile;
}
public String getFileName() {
  return this.xlsFile;
}
// Example: 1234,Fixed_Balloon,A21:E34;G21:K34
public void setDescriptor(String descriptor) throws Exception {
  String parts[] = descriptor.split("[,]");
  if(parts.length < 2) throw new Exception("Descriptor should be '<sheet>,<ranges>': " + descriptor);
  String sheetName = parts[0].trim();
  String ranges[] = parts[1].trim().split("[;]");
  this.dataDescriptor = new DataDescriptor(sheetName, ranges);
}

public String getImport() throws Exception {
    File inFile = new File(this.xlsFile).getAbsoluteFile();
  InputStream in = new BufferedInputStream(new FileInputStream(inFile), 4096);
  POIFSFileSystem fs = new POIFSFileSystem(in);
  HSSFWorkbook wb = new HSSFWorkbook(fs);
  DataDescriptor descr = (DataDescriptor)this.dataDescriptor;
  StringBuffer str = new StringBuffer();
  this.importDataDescriptor(wb, descr);
  // Append the range data, one range per line
  String data[] = descr.getData();
  int len = data.length;
  for(int d = 0; d < len; d++) {
   str.append(data).append('\n');
  }
  in.close();
  return str.toString();
}

private DataDescriptor importDataDescriptor(HSSFWorkbook wb, DataDescriptor descr)
     throws Exception {
  HSSFSheet sheet = this.getWorkbookSheet(wb, descr.sheetName);
  if(sheet == null) throw new SheetNotFoundException(descr.sheetName);
  int len = descr.ranges.length;
  for(int i = 0; i < len; i++) {
   descr.setRangeData(i, this.getRangeValues(wb, sheet, descr.ranges));
  }
  return descr;
}
 
  private HSSFSheet getWorkbookSheet(HSSFWorkbook wb, String sheetName) {
    HSSFSheet sheet = null;
    int size = wb.getNumberOfSheets();
    for(int i = 0; i < size; i++) {
      String name = wb.getSheetName(i).trim();
      if(name.equals(sheetName)) {
        sheet = wb.getSheetAt(i);
        break;
      }
    }
    return sheet;
  }

// Return a delimeted list of values for the given range
// Example range: "B22:B24" could return "1.0,4.3,5.1"
private String getRangeValues(HSSFWorkbook wb, HSSFSheet sheet, String range) throws Exception {
  if(!range.matches("[A-Za-z][A-Za-z]?[0-9]+[:][A-Za-z][A-Za-z]?[0-9]+")) {
   throw new RangeFormatException("Improper Range Format: " + range);
  }
  StringBuffer str = new StringBuffer();
  int colon = range.indexOf(':');
  int rangeStart[];
  int rangeEnd[];
  rangeStart = this.getCell(range.substring(0, colon));
  rangeEnd = this.getCell(range.substring(colon + 1));
  for(int r = rangeStart[1]; r <= rangeEnd[1]; r++) {
   HSSFRow row = sheet.getRow(r);
   boolean addedFirstCell = false;
   for(int c = rangeStart[0]; c <= rangeEnd[0]; c++) {
    HSSFCell cell = (row==null)?null:row.getCell((short)c); 
    if(addedFirstCell) str.append(',');
    else addedFirstCell = true;
    if(cell == null) {
     str.append("");
    }
    else {
     int type = cell.getCellType();
     switch(type) {
       case HSSFCell.CELL_TYPE_BLANK:
       case HSSFCell.CELL_TYPE_ERROR:
         str.append("");
         break;
       case HSSFCell.CELL_TYPE_FORMULA:
         //String formula = cell.getCellFormula();
         //System.err.println("ExcelImporter Formula: " + formula);
         //Object value = this.evaluateFormula(sheet, formula);
         //if(!(value instanceof String)) str.append(value.toString());
         //else str.append('\"').append((String)value).append('\"');
         str.append("");
         break;
       case HSSFCell.CELL_TYPE_NUMERIC:
         if(HSSFDateUtil.isCellDateFormatted(cell)) {
         Date date = HSSFDateUtil.getJavaDate(cell.getNumericCellValue());
         SimpleDateFormat format = new SimpleDateFormat("MM/dd/yyyy");
         str.append('\"').append(format.format(date)).append('\"');
         }
         else {
          if(this.getDataFormat(wb, cell).indexOf("%") > -1) {  // Handle percentages
         str.append(cell.getNumericCellValue() * 100.0);          
          }
          else {
         str.append(cell.getNumericCellValue());
          }   
         }
        break;
       case HSSFCell.CELL_TYPE_STRING:  
         str.append('\"').append(cell.getStringCellValue()).append('\"'); 
         break;
      default:
        throw new Exception("Unsupported cell type: " + type);
     }
    }
   }
   str.append('\n');
  }
  return str.toString();
}

// Example cell: B22
private int[] getCell(String cell) {
  String column = cell.replaceFirst("[0-9]+", "");
  String row = cell.replaceFirst("[A-Za-z]+", "");
  return new int[]{ this.getColumnNumber(column), Integer.parseInt(row) - 1 };
}
  // Return the integer value of the given column designation
  // Note: This method only handles columns of 1 or 2 chars ("A" or "AA", not "AAA")
private int getColumnNumber(String columnLetters) {
  int column;
  if(columnLetters.length() == 1) {
   column = Character.toUpperCase(columnLetters.charAt(0)) - 'A';
  }
  else {
   column = Character.toUpperCase(columnLetters.charAt(1)) - 'A';
   column += (Character.toUpperCase(columnLetters.charAt(0)) - 'A' + 1) * 26;
  }
  return column;
}
private Object evaluateFormula(HSSFSheet sheet, String formula) {
  return formula;
}
private String getDataFormat(HSSFWorkbook wb, HSSFCell cell) {
  String format = "";
  try {
   HSSFDataFormat dformat = wb.createDataFormat();
    format = dformat.getFormat(cell.getCellStyle().getDataFormat());
  }
  catch(Exception ex) {}
  return format;
}


// Contains information for importing one set of ranges and their data for a sheet
private static class DataDescriptor {
  final String sheetName;
  final String ranges[];
  private String data[];
  DataDescriptor(String sheetName, String ranges[]) {
   this.sheetName = sheetName;
   this.ranges = ranges;
   this.data = new String[ranges.length];
  }
  public void setRangeData(int index, String data) {
   this.data[index] = data;
  }
  public String[] getData() {
   return this.data;
  }
}
}