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