fbpx

How To Add Excel Web Access Webpart In Sharepoint 2010

Are you looking to enhance data sharing and collaboration in Sharepoint 2010? Learn how to add the Excel Web Access WebPart with our comprehensive guide.

To add an Excel Web Access WebPart in SharePoint 2010, you need to follow a few steps. First, you need to add the necessary references to your project, such as Microsoft.Office.Excel.WebUI.dll. Then, you can instantiate the Excel Web Access WebPart and display a workbook programmatically. You also need to ensure that the location where the workbook is saved is a trusted location.

Steps to Add Excel Web Access Webpart In Sharepoint 2010

Follow these step-by-step instructions to successfully add the Excel Web Access WebPart in Sharepoint 2010. First, you need to add the necessary references to your project. This includes adding the “Microsoft.Office.Excel.WebUI.dll” reference to your solution.

Next, you can instantiate the Excel Web Access WebPart by adding the following code to your page or web part:

<WebPartPages:ExcelWebRenderer ID=”ExcelWebRenderer1″ runat=”server” WorkbookUrl=”path_to_workbook” />

Make sure to replace “path_to_workbook” with the actual URL of the workbook you want to display. Additionally, ensure that the workbook is saved in a trusted location to prevent any security restrictions from blocking its display.

By following these steps, you will be able to successfully add the Excel Web Access WebPart in Sharepoint 2010 and display your desired workbook programmatically.

Example of Table:

Column 1 Column 2 Column 3
Data 1 Data 2 Data 3
Data 4 Data 5 Data 6

Now that you know how to add the Excel Web Access WebPart in Sharepoint 2010, you can leverage its functionality to enhance your collaboration and data sharing capabilities. Whether you are working with Excel workbooks locally or in a SharePoint Online environment, this WebPart provides a powerful way to display and interact with Excel data in a SharePoint context.

Adding Excel Web Access Webpart in SharePoint Online

If you’re using SharePoint Online and want to include an Excel spreadsheet, follow these instructions to add the Excel Web Access WebPart using the Embed web part.

To begin, upload the Excel file to SharePoint Online. Ensure that the file is saved in a trusted location. Once the file is uploaded, open it in Excel Online.

Next, generate the embed code by selecting “File” from the Excel Online toolbar and choosing the “Embed” option. Customize the settings as needed, such as showing or hiding gridlines and headers. After selecting the desired options, click the “Generate” button to generate the embed code.

Now, navigate to your modern SharePoint Online page where you want to display the Excel Web Access WebPart. Add the Embed web part to the page, and then paste the embed code you generated earlier into the web part’s settings. Save the changes to your page.

Embed web part settings

Setting Description
Show toolbar Select whether to display the toolbar in the embedded spreadsheet.
Show footer Choose whether to show the footer, which includes information about the file and options to open it in Excel Online.
Show sheet tabs Specify whether to display the sheet tabs at the bottom of the embedded spreadsheet.
Hide gridlines Select whether to show or hide the gridlines in the embedded spreadsheet.
Hide headers Choose whether to display the column and row headers in the embedded spreadsheet.

By following these instructions, you can easily add the Excel Web Access WebPart in SharePoint Online and share your Excel spreadsheets with others in a visually appealing and interactive way.

Conclusion

By adding the Excel Web Access WebPart in Sharepoint 2010 or SharePoint Online, you can enhance data sharing and collaboration within your organization. This powerful tool allows you to seamlessly integrate Excel spreadsheets into your SharePoint environment, making it easier for team members to access and work with important data.

In SharePoint 2010, the process of adding the Excel Web Access WebPart involves a few simple steps. First, you need to add the necessary references to your project, such as Microsoft.Office.Excel.WebUI.dll. Then, you can instantiate the Excel Web Access WebPart and display a workbook programmatically. It’s important to ensure that the location where the workbook is saved is a trusted location to ensure smooth functionality.

In SharePoint Online, adding the Excel Web Access WebPart is done using the Embed web part. Although you can’t directly add the WebPart, you can upload the Excel file to SharePoint Online, open it in Excel Online, and generate the embed code. This code can then be pasted into the Embed web part on your modern SharePoint Online page, allowing you to display the Excel spreadsheet and share it with others.

By utilizing the Excel Web Access WebPart, you can make data sharing and collaboration more efficient and streamlined. Whether you’re using Sharepoint 2010 or SharePoint Online, this feature empowers your organization to leverage the full potential of Excel and enhance productivity.