none
Excel Services in a non-web part page

    Question

  • Hi All:

    Will Excel Services only work correctly on a web part page?

    I am trying to display a simple chart through SP2010 Excel Services.  I configure the web part using SP Designer and save the page (.aspx). But when I open the newly created page, it displays the chart along with dozens and dozens of microsoft office icons.  The page is absolutely filled with nonsense.

    When I create the same chart directly from a web part page, Excel Services works as expected.  I get the bizarre behavior only when I create a new .aspx page from SP Designer and then add the web part the web part to the blank page.

    Any direction you may have is sincerely appreciated.  Thanks


    joshkra

    Friday, January 25, 2013 2:57 PM

Answers

  • I came back to this problem and realized the following:

    1) First insert a 'web part zone' onto the page before inserting the 'web part'

    2) Save the page and 'refresh' it

    3) Return to browser in order to connect the chart and customize

    It looks as though I was putting a 'web part' on a page with no 'web part zone'. 


    joshkra

    • Marked as answer by joshkrag Tuesday, February 12, 2013 3:27 PM
    Tuesday, February 12, 2013 3:27 PM

All replies

  • Its advisable to use page edit view and use excel web access/ chart webpart. What webpart you are trying to configure via SP designer? what type of a page is it? Can you post the webpart zone code here?

    Following links should help:

    http://www.dotnetcurry.com/ShowArticle.aspx?ID=816 

    http://www.codeproject.com/Articles/22239/Displaying-Charts-in-SharePoint-using-Excel-Servic


    sharing is learning Whenever you see a reply and if you think is helpful, click "Vote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Mark As Answer"

    Saturday, January 26, 2013 4:04 AM
  • Thanks for your reply.  I viewed the links and by just using the browser was able to successfully connect a chart webpart to excel data.  My objective, however, is to do the same but on a site page from SP Designer to create a clean dashboard of metrics, without the standard list of libraries, etc on the left of the page.

    Here is some additional detail:

    1) I open SP Designer

    2) Select Create new ASPX page (Edit in Advanced Mode)

    3) Add a Web Part Zone

    4) Within Zone, Add a Web Part

    5) Select the Excel Services Webpart and point it to the published, named range in the library

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <%@ Page Language="C#" inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
    <%@ Register tagprefix="WebControls" namespace="Microsoft.Office.Server.WebControls" assembly="Microsoft.Office.Server.Chart, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
    <%@ Register tagprefix="WebUI" namespace="Microsoft.Office.Excel.WebUI" assembly="Microsoft.Office.Excel.WebUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
    <html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">
    
    <head runat="server">
    <meta name="WebPartPageExpansion" content="full" />
    <meta name="ProgId" content="SharePoint.WebPartPage.Document" />
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Untitled 1</title>
    </head>
    
    <body>
    
    <form id="form1" runat="server">
    <WebUI:ExcelWebRenderer runat="server" AllowRemove="True" AllowHide="True" WorkbookUri="https://portal.vrsn.com/sites/nds/namingservices/business_insight/gtld_model/Book5.xlsx" VisibleItem="data" ExportMode="All" PartImageLarge="/_layouts/images/ewr023.gif" MissingAssembly="Cannot import this Web Part." ID="g_ec88b6ec_91aa_4962_8128_16adeda5db32" DetailLink="" AllowEdit="True" HelpMode="Modeless" IsIncluded="True" Description="Use the Excel Web Access to interact with an Excel workbook as a Web page." FrameState="Normal" Dir="Default" AllowZoneChange="True" AllowMinimize="True" IsIncludedFilter="" Title="Excel Web Access - Book5" PartOrder="0" FrameType="TitleBarOnly" CatalogIconImageUrl="/_layouts/images/ewr023.gif" HelpLink="" PartImageSmall="/_layouts/images/ewr023.gif" AllowConnect="True" ConnectionID="00000000-0000-0000-0000-000000000000" ExportControlledProperties="True" TitleIconImageUrl="/_layouts/images/ewr023.gif" ChromeType="TitleOnly" SuppressWebPartChrome="False" IsVisible="True" ZoneID="ImportedPartZone" __MarkupType="vsattributemarkup" __WebPartId="{ec88b6ec-91aa-4962-8128-16adeda5db32}" WebPart="true" Height="400px" Width=""></WebUI:ExcelWebRenderer>
    <br />
    

    6) Save Page and preview reveals the following in the browser:


    joshkra

    Monday, January 28, 2013 3:47 PM
  • I came back to this problem and realized the following:

    1) First insert a 'web part zone' onto the page before inserting the 'web part'

    2) Save the page and 'refresh' it

    3) Return to browser in order to connect the chart and customize

    It looks as though I was putting a 'web part' on a page with no 'web part zone'. 


    joshkra

    • Marked as answer by joshkrag Tuesday, February 12, 2013 3:27 PM
    Tuesday, February 12, 2013 3:27 PM