SAP Knowledge Base Article - Preview

1296454 - Cannot find worksheet - Error preparing to read <Excel File Format>:<Exception occurs when executing 'begin' method of the adapter operation with ID[number]>

Symptom

  • Not possible to get a job, based on an excel spreadsheet, to run.
  • The Excel workbook file contains macros and/or security enabled
  • The log on the Management Console shows the error message similar to: 
        25/11/08 13:52:45 Could not find worksheet Sheet1 in file <path>/<excelfile>.xls 25/11/08 13:52:45 Exception occurs when executing 'begin' method of the adapter operation with ID [15].
  • error code RUN-058105


Read more...

Environment

  • Data Integrator  (DI) 11.7 , Data Services (DS) 3.0 , Data Services 3.1 and Data Services 3.2
  • Unix, Linux, Solaris or AIX
  • BOExcelAdapter configured
  • Excel file as data source, any database table as target.

Product

SAP Data Integrator XI R2 Accelerated ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

Unix, BOExcelAdapter, Data Integrator, Data Services, DI, DS , KBA , EIM-DI , Data Integrator, Composer , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.