Monday, December 21, 2009

Add Excel Web Renderer Webpart From SilverLight ObjectModel

Hi,
First in How To's :)
To add a Excel Webpart from Silverlight oject Model -





ClientContext cnt = new Microsoft.SharePoint.Client.ClientContext("http://hydhtc130180d:3333/");
if (cnt == null)
{
throw new Exception("connection failed");
}
else
{
string ewaWebpart = "<?xml version='1.0' encoding='utf-8'?><webParts><webPart xmlns='http://schemas.microsoft.com/WebPart/v3'><metaData>";
ewaWebpart +="<type name='Microsoft.Office.Excel.WebUI.ExcelWebRenderer, Microsoft.Office.Excel.WebUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' />";
ewaWebpart +="<importErrorMessage>Cannot import this Web Part.</importErrorMessage>";
ewaWebpart +="</metaData>";
ewaWebpart +="<data>";
ewaWebpart += "<properties>";
ewaWebpart += "<property name='Title' type='string'>ExcelWebRenderer</property>";
ewaWebpart += "</properties>";
ewaWebpart +="</data></webPart></webParts>";
LimitedWebPartManager limitedWebPart = cnt.Web.GetFileByServerRelativeUrl("/SitePages/mypage.aspx").GetLimitedWebPartManager(PersonalizationScope.Shared);

WebPartDefinition ewaWebPartDef = limitedWebPart.ImportWebPart(ewaWebpart);
limitedWebPart.AddWebPart(ewaWebPartDef.WebPart,"Left",1);


cnt.ExecuteQueryAsync(s1, f1);

No comments:

Post a Comment