Skip to Content
0

Unable to Read of Excel file (.XLSX) in SAP BODS

Apr 30 at 06:05 AM

82

avatar image
Former Member

error-log-bods.jpgfile-format-bods.jpgMy source file is Microsoft excel (.xlsx), while reading source file, most of file formats do not read .xlsx but read only .xls files even though the File Formats are created in similar manner. Could you please help me to fix the issue in SAP BODS job?

Error am facing in BODS Error Log below

File Format

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Apr 30 at 07:33 AM
0

What edition of BODS do you have ? BODS 4.X will support .xlxs format.

Whilst creating the file format did you use Import schema option to get the columns details ? Is it working ?

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

version2.jpgSAP BODS 4.2

version2.jpg (19.1 kB)
0
Former Member

Yes Vinayak,

While creating file format, I imported schema (Structure) and its completely came up as it is in file. But while reading it is throughing error in .XLSX format. But surprisingly while set .XLS then its reading fine.

0
Denise Meyer
Apr 30 at 06:29 PM
0

It is complaining about path and permissions. Can you check that the path is valid and that the user that starts the job server has permissoins to see the file?

Share
10 |10000 characters needed characters left characters exceeded