cancel
Showing results for 
Search instead for 
Did you mean: 

DS 4.0: Unable to read xlsx

Former Member
0 Kudos

Hi Experts,

We use BusinessObjects Data Services 4.0 SP2 Patch 4, version 14.0.2.409 on Windows 2008 Server.We have created BoExcelAdapter to read Excel source and we were not facing any issues in reading the Excel files so far.

Yesterday when we ran the job to read a new excel file, we received the error message 'Could not find worksheet ... in file ..'.

But the excel file has the specified worksheet.

Could you please guide me as to what has caused such an error and how to resolve this.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Arun and Nawfal,

I am sorry that there's typo in this message. Please refer to my question as follows:

http://scn.sap.com/thread/3346091

Many thanks!

Vicky

Former Member
0 Kudos

and if you want 2007, 2010 (new extention) support on Unix platform, upgrade to DS 4.1 SP1.

See PAR http://service.sap.com/bosap-support

thanks

Nawfal

Former Member
0 Kudos

Hi,

These versions are supported for Excel as a source on Windows: 97, 2000, XP, 2003, 2007, 2010,  (Microsoft Access Database Engine 2010 Redistributable is required.)

I see that you have also mentioned   BoExcelAdapter. So in Unix Data Services(in 4.0 SP3) only supports xls extension,   namley it will 97, 2000, XP, 2003.

Regards

Nawfal Tazi

Former Member
0 Kudos

Whats the version of your new excel file? I guess DS 4.0 won't support older versions, you need Office 2010 or 2010 drivers.

Arun