Sharepoint

If you have recently migrated from SharePoint 2010 to SharePoint 2013 or if you are configuring excel web access web part for SharePoint 2013 with named component, you might notice that you Excel web access web parts are showing some error or not showing any data even after you add your excel file location to Trusted locations in excel service application. There are multiple reasons behind this behavior of excel web access web part. If you are getting error "Workbook cannot be opened" as shown in below image, It is related to permissions to the service account used for Excel services. As all your excel files are stored in Content DB, service account used for Excel service should be having access to all respective web applications. You can use following cmdlets to get this issue resolved $webApplication = Get-SPWebApplication –Identity <URL of the Web application> $webApplication.GrantAccessToProcessIdentity("<insert service account&

Below code describes how to retrieve items from sharepoint list by specific view using client side object model Add reference “Microsoft.sharepoint.client.dll” and “Microsoft.sharepoint.client.Runtime.dll”. Write Below Code. using  Microsoft.SharePoint.Client; namespace  ConsoleApplication {        class   Program     {          static   void  main( string [] args)         {              using  ( ClientContext  ctx= new   ClientContext ( “http://siteurl” ))             {                  //Apply Credential                 ctx.Credentials =  new  System.Net. NetworkCredential ( “UserName” ,  “Password” );                  Web  web = ctx.Web;                 ctx.Load(web,w=>w.Lists);                  List  list = web.Lists.GetByTitle( “New List” );//Load list                 ctx.Load(list, l => l.Views);                 ctx.ExecuteQuery();                  CamlQuery  query =  new   CamlQuery ();                 ListItemCollection itemCo