IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

Errors while working with Excel Cintent Handler --compilation errors

  • 1.  Errors while working with Excel Cintent Handler --compilation errors

    Posted 12/01/08 04:32 PM

    Hi ,

    I just downloaded Excel contentHandler shareware and installed on the server , even I downloaded poi-2.5.1-final-20040804.jar file and placed in INTEGRATIONSERVER\LIB\JARS then restarted the server but getting errors

    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:14: package org.apache.poi.hssf.usermodel does not exist
    import org.apache.poi.hssf.usermodel.*;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:511: cannot resolve symbol
    symbol : class HSSFCell
    location: class EXCEL_contentHandler.util
    public static boolean isCellDateFormatted(HSSFCell cell)
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:68: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    HSSFWorkbook wb = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:70: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(new FileInputStream(file_name));
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:72: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(file_stream);
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:74: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(new ByteArrayInputStream(file_data.getBytes()));
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:76: cannot resolve symbol
    symbol : class HSSFSheet
    location: class EXCEL_contentHandler.util
    HSSFSheet sheet = wb.getSheetAt(0);
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:77: cannot resolve symbol
    symbol : class HSSFRow
    location: class EXCEL_contentHandler.util
    HSSFRow row = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:78: cannot resolve symbol
    symbol : class HSSFCell
    location: class EXCEL_contentHandler.util
    HSSFCell cell = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:97: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING)
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:128: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    case HSSFCell.CELL_TYPE_STRING:
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:136: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    case HSSFCell.CELL_TYPE_NUMERIC:
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:155: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    case HSSFCell.CELL_TYPE_BLANK:
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:243: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    HSSFWorkbook wb = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:245: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(new FileInputStream(file_name));
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:247: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(file_stream);
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:249: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(new ByteArrayInputStream(file_data.getBytes()));
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:251: cannot resolve symbol
    symbol : class HSSFSheet
    location: class EXCEL_contentHandler.util
    HSSFSheet sheet = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:252: cannot resolve symbol
    symbol : class HSSFRow
    location: class EXCEL_contentHandler.util
    HSSFRow row = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:253: cannot resolve symbol
    symbol : class HSSFCell
    location: class EXCEL_contentHandler.util
    HSSFCell cell = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:280: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING)
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:311: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    case HSSFCell.CELL_TYPE_STRING:
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:319: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    case HSSFCell.CELL_TYPE_NUMERIC:
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:337: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    case HSSFCell.CELL_TYPE_BLANK:
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:432: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    HSSFWorkbook wb = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:434: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(new FileInputStream(file_name));
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:436: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(file_stream);
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:438: cannot resolve symbol
    symbol : class HSSFWorkbook
    location: class EXCEL_contentHandler.util
    wb = new HSSFWorkbook(new ByteArrayInputStream(file_data.getBytes()));
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:440: cannot resolve symbol
    symbol : class HSSFSheet
    location: class EXCEL_contentHandler.util
    HSSFSheet sheet = wb.getSheetAt(0);
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:441: cannot resolve symbol
    symbol : class HSSFRow
    location: class EXCEL_contentHandler.util
    HSSFRow row = sheet.getRow(0);
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:442: cannot resolve symbol
    symbol : class HSSFCell
    location: class EXCEL_contentHandler.util
    HSSFCell cell = null;
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:454: cannot resolve symbol
    symbol : variable HSSFCell
    location: class EXCEL_contentHandler.util
    if (type == HSSFCell.CELL_TYPE_STRING)
    ^
    C:\webMethods65\IntegrationServer\packages\EXCEL_contentHandler\code\source\EXCEL_contentHandler\util.java:517: cannot resolve symbol
    symbol : class HSSFCellStyle
    location: class EXCEL_contentHandler.util
    HSSFCellStyle style = cell.getCellStyle();
    ^
    33 errors

    Please advice me where I am doing wrong , help is truly appreciated.

    Thanks,

    Raj


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 2.  RE: Errors while working with Excel Cintent Handler --compilation errors

    Posted 12/02/08 02:56 PM

    Problem solved as I just unzip the file which I downloaded from web i.e jar file and placed the same file on IS server .

    Thanks,

    Raj


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


Related Content