0

We are doing some R&D on displaying excel sheets (simple sheets with no external data connection) and excel reports(which connect to sql db) on a SharePoint page.

I would like to know what are various web parts that are available for such purpose.

Thanks.

Improve this question

1 Answer 1

Reset to default
1

You can

Add Webpart -> Business Data -> Excel Web Access

Also you can use Excel Services and store the Excel File in trusted location.

Improve this answer
3
  • What is the difference between these approach? Also note that I use a user credential in excel when connecting to the analysis db. Will that work in sharepoint?
    – variable
    Commented May 29, 2015 at 0:12
  • Its same. For creds you need to create a connection file I believe.
    – Amal Hashim
    Commented May 29, 2015 at 0:21
  • But aren't creds already embedded in the sheet? The ones you supply when making connections in excel to the analysis db.
    – variable
    Commented May 29, 2015 at 2:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.