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? Commented May 29, 2015 at 0:12
  • Its same. For creds you need to create a connection file I believe. 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. Commented May 29, 2015 at 2:58

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.