convert Excel File to CSV or WmDoc

Hi All,

we have an requirement, that customers sends Excel file to us(directory).
we need to pick that Excel file and process it.

problem I am facing is how to convert Excel file to csv or WmDoc via code.
I searched and came to know, we have a package EXCEL_contentHandler .
I tried it but no use.

can anyone help me out from this. it’s very urgent
more over i don’t know java. so please give me points in details. thanks

Thanks in Advance

use the API’s in


i have Java service code
try {
IDataCursor pipelineCursor = pipeline.getCursor();
byte[] excelBytes = (byte[]) IDataUtil.get(pipelineCursor, “excelBytes”);
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new;
jxl.Sheet[] sheets = rwb.getSheets();
IData[] resultSheets = new IData[sheets.length];
for (int i = 0; i < sheets.length; i++) {
IData idata = IDataFactory.create();
IDataCursor cursor = idata.getCursor();
IDataUtil.put(cursor, “sheetName”, sheets[i].getName());
int rows = sheets[i].getRows();
int columns = sheets[i].getColumns();
IData[] sheetData = new IData[rows];
for (int j = 0; j < rows; j++) {
IData rowData = IDataFactory.create();
IDataCursor rowCursor = rowData.getCursor();
for (int k = 0; k < columns; k++) {
IDataUtil.put(rowCursor, “field” + (k + 1), sheets[i].getCell(k, j).getContents());
sheetData[j] = rowData;
IDataUtil.put(cursor, “sheetData”, sheetData);
resultSheets[i] = idata;

        pipelineCursor = pipeline.getCursor();
        IDataUtil.put(pipelineCursor, "sheets", resultSheets);
    } catch (Exception ex) {
        throw new ServiceException(ex);

and i have put Jar file at package/code/jar.
but still am getting below error

/operations/webmethods/webMethods6/IntegrationServer/packages/practice/code/source/kishore/ cannot find symbol
symbol : class io
location: class
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new;