Skip to Content
avatar image
Former Member

Sharepoint excel File.

Hi ,

I have a excel file in SharePoint , Kindly help me to extract this file using SAP BODS. Please provide the necessary steps needed to extract the file.

If we need to write a script please provide the exact steps which needs to be executed.

Note : Please don't give your answers on Fly. Provide the exact solution.

Regards

Teja

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 04, 2015 at 10:39 AM

    Hi Teja,

    Do  you have only Data Services or SAP BW installed? If you have SAP BW then you can follow below link.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 11:26 AM

    Hi ,

    I have only SAP Data Services, Kindly help me to extract SharePoint excel file through BODS. Your Inputs are highly appreciated.

    Regards

    Teja T

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      You need to automate the task of extracting the data from Sharepoint site to Excel or CSV.

      This can be done by VB script or through macro.

      The excel file should be available for BODS to be used as a source.

      Regards

      Arun Sasi

  • Mar 15, 2016 at 02:56 AM

    Hi Experts,

    I have the same requirement. Need to extract CSV file from SharePoint and store into HANA Studio Table. Could you please help me out this with solutions.

    Thanks in Advance!!

    Puneet

    Add comment
    10|10000 characters needed characters exceeded

    • Puneet, refer to

      The CSV file generated by the script(mentioned in above thread) would act as a Source for BODS job and then you can load the contents in SAP HANA table

      Regards

      Arun Sasi