Skip to Content
0

How to read data from Excel files using SAP data services

Jan 19, 2017 at 05:32 PM

275

avatar image

Hi,

Is there document on how to read data from spreadsheet using data services? I need to read certain rows and columns in a sheet and cannot find instruction on how. I know IBM data stage can do this.

Thanks!

10 |10000 characters needed characters left characters exceeded

Hi,

Thank you much for the information.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mrityunjay Pandey Jan 19, 2017 at 06:31 PM
0

Hi Xu,

You need to have Microsoft office 64 bit install on your client system. Then only this will work. If this condition is met , you can create Excel Workbook type file format as shown below.


dsp.jpg (71.0 kB)
Share
10 |10000 characters needed characters left characters exceeded
Sid Nirgudkar Jan 23, 2017 at 08:22 AM
0

Hi Lina,

Here's a pretty good blog to get started on how to import from an Excel file.

https://blogs.sap.com/2012/12/26/how-to-import-an-excel-file-in-data-services/

Once you are able to read the excel, you can then filter according to your needs.

Regards,

Sid

Share
10 |10000 characters needed characters left characters exceeded