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.

 View Only
Expand all | Collapse all

Working with Excel sheet in SAP BC 4.6

  • 1.  Working with Excel sheet in SAP BC 4.6

    Posted Thu January 22, 2009 06:57 AM

    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…


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


  • 2.  RE: Working with Excel sheet in SAP BC 4.6

    Posted Thu January 22, 2009 10:48 AM

    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


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


  • 3.  RE: Working with Excel sheet in SAP BC 4.6

    Posted Thu January 22, 2009 12:15 PM

    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


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


  • 4.  RE: Working with Excel sheet in SAP BC 4.6