Java EE (Java Enterprise Edition) General Discussion

Hi,

im trying to read an excel file using java. I get the excel file or rather the contents of the Excel file in an XML payload. so, i extract it using ByteInputStream. Then, i m trying to read the excel file usinf jexcel and jxl API provided for reading excel file.

The following is the snippet of the code:

ByteArrayInputStream ba = new ByteArrayInputStream(xmlData);
Workbook wb = Workbook.getWorkbook(ba);
But i get the following exception in the last statement

jxl.read.biff.BiffException: Unable to recognize OLE stream

Please help...i;m not able to figure wht is wrong with the code.

Thanks
Aks