Working with Excel sheet in SAP BC 4.6

Hi,

I am new bie to SAP BC. I have 2 years of experience in Java. I am trying to read the incoming excel file through my java service. I am using HSSFWorkbook object. But it is giving me an error saying that "cannot resolve symbol symbol : class HSSFWorkbook ".

Even i have tried to import org.apache.poi.hssf.* to my java service. But it is giving me an error as “package org.apache.poi.hssf does not exist”.

Please help me…

Hello,
Make sure that the corresponding poi jar file is copied to the code/jars folder.
If you copied to static directory then you may need to restart the IS to load the classes.

Cheers
Guna

Thanks Guna for your reply. I didnt get poi jar file. But i used jxl.jar and i found the answer.

Where i can get poi jar file?.By using jxl.jar i can handle only Excel sheets, not the CSV files.

Regards,
Vas

http://poi.apache.org

Cheers
Guna