Skip to Content
avatar image
Former Member

How to read data from Excel files using SAP data services

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 19, 2017 at 06:31 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 23, 2017 at 08:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded