.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SharePoint 2010 Excel Service Exception

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
 
SharePoint 2010 Excel Service Exception   I created Windows Form Application in Visual Studio 2010. I added Service Reference: http://<SharePoint _Server_Name>/_vti_bin/ExcelService.asmx. The code line: ExcelContract.XLWebService.ArrayOfAnyType returnData =              proxy.GetRangeA1(sessionID, sheetName, nameRange, false, out wsStatus);     throws exception: The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://schemas.microsoft.com/office/excel/server/webservices:GetRangeA1Response. The InnerException message was 'Error in line 1 position 361. Element 'http://schemas.microsoft.com/office/excel/server/webservices:anyType' I have the following app.config: <?xml version="1.0" encoding="utf-8" ?> <configuration>     <system.serviceModel>         <bindings>             <basicHttpBinding>                 <binding name="ExcelServiceSoap" closeTimeout="00:01:00" openTimeout="00:01:00"             


View Complete Post


More Related Resource Links

SharePoint 2010 with EXCEL Service- Support for Office 2003

  

Hi All,

 

I have an query. I am using EXCEL Service on SharePoint 2010. Some of users in my network has Office 2003 installed on there Laptop. I have a template which is designed in Office 2010 and uploaded to Document library,

My questions is:

1) Will users who have office 2003 or Office 2007 be able to use that template and fill in data?

 

 

 

 

 


Pathik

In sharepoint excel working fine in office 2007 but not in office 2010

  

Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.

 

This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.

 

Can you let me know why is problem is coming and how to resolve this.

 

Thanks

Sanjeev Tiwari

 


Sharepoint 2007 and Excel 2010 features

  

Does Sharepoint 2007 Server support the new Excel 2010 feaures like slicers? Or do i have to have Sharepoint 2010 to get that working (considering all other components besides Sharepoint 2010 are available in my Sharepoint 2007 environment) ?

- Thanks

RK

 


SharePoint 2010: Excel Services Resource Center

  
Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

  
Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Sample: Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

  
Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

  
This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

Video: SharePoint 2010: Creating Custom Service Applications

  
Do you need more than the services provided by SharePoint? In this advanced session targeted at high-end developers, you will learn how to create a custom SharePoint service. (Length: 36:31)

Video: Excel Services and SharePoint 2010 Business Intelligence

  
In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

SharePoint 2010 Search Service Application: "All Content" scope contains 0 items?

  
I've encountered a nasty bug in our setup. Our Search Service Application manages to crawl all content just fine. However, the scopes don't work. We've got a total of 570 items currently in our crawl database. 350 of these are of class 'People', and appear in the 'People' scope. The remaining 220 items should appear in 'All Content' as part of the intra (sites, documents etc), however the 'All Content' scope reports 0 items. I've tried the following: -Creating custom scopes (still 0 items) -Recreating the Search Service Application twice -Tried different accounts as the content access account. -Ensuring that the content access accounts do have 'full read policy' -Checked the crawl log for successful content (such as sites and documents). However, despite my efforts I still get 0 items for 'All Content'.  Has anyone else encountered this problem, or do you have any recommendation for us? Currently I don't see any other option than to reinstall everything.

problem rename sharepoint 2010 search service application admin database

  
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Using Web Service in SharePoint 2010 Standard Web part using Visual Studio 2010

  
Hi All,               Have an issue with  Web service in calling  by SharePoint 2010 Standard Web part using Visual Studio 2010. If you can tell where I went wrong or tips to solve this would be great for me. What I have done is like this.. 1) Created new 'Empty SharePoint' project : as Farm solution 2) Added Web parts 3) Trying to add Web Service : There was no option for adding Web Service , so added as 'Add new Service' , this created entries in app.config file 4) ServiceName : shown as name space  (what  I'm  expecting is as Global  object with all methods ) 5) Created Object of namespace.ServiceName.ServiceSoapClient and tried to call one of it's method 6) Build and deployed 7) While viewing that web part it is showing an error as [InvalidOperationException: Could not find default endpoint element that references contract 'SerialKeyService.ServiceSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.]         Error in detail : [TargetInvocationException: Exception has been thrown by the target of an invocation.]   at System.RuntimeTypeHandle.CreateInstance(RuntimeType t

Problem With SharePoint Designer 2010 and the Search.asmx Web Service

  
I've created a web service datasource on a 2010 site using SharePoint Designer. When I try to make use of the datasource on a page I get the "The server returned a non-specific error when trying to get data from the data source..." message. The datasource connects to _vti_bin/search.asmx. I am using the QueryServiceSoap port and operation QueryX. I've tried various queryXml strings, including site & people searches using both SQL and keyword syntax. eg <?xml version="1.0" encoding="utf-8" ?><QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000"><Query domain="QDomain"> <SupportedFormats><Format>urn:Microsoft.Search.Response.Document.Document</Format></SupportedFormats> <Context>   <QueryText language="en-US" type="MSSQLFT"><![CDATA[ SELECT Size, Rank, Path, Title, Description, Write, Filename, Description, Author FROM scope() WHERE CONTAINS ('"Lorum"') AND  ( ("SCOPE" = 'All Sites') )   ORDER BY "Rank" DESC ]]></QueryText> </Context> <Range><StartAt>1</StartAt><Count>20</Count></Range> <EnableStemming>false</EnableStemming> <TrimDuplicates>true</TrimDuplicates> <IgnoreAllNoiseQuery>true&l

How to Programatically SetCredentials for Secure Store Service Application in Sharepoint 2010 using

  
I have to setup Credentials for Secure Store Service application programatically. To get Stored Credentials I have following code and its working fine. using (SPSite site = new SPSite("http://vtlssp2010Dev")) //using (SPSite site = new SPSite("http://" + System.Environment.MachineName + "/sites/Site_Name"))d { Console.WriteLine(site.RootWeb.CurrentUser.Name); SPServiceContext context = SPServiceContext.GetContext(site); prov.Context = context; try { SecureStoreCredentialCollection cc = prov.GetCredentials(appID); foreach (SecureStoreCredential c in cc) { IntPtr ptr = System.Runtime.InteropServices.Marshal.SecureStringToBSTR(c.Credential); string sDecrypString = System.Runtime.InteropServices.Marshal.PtrToStringUni(ptr); Console.WriteLine(sDecrypString); } } catch (Exception ex) { Console.WriteLine("Unable to get credentials for application " + appID); Console.WriteLine(ex.Message); } Console.ReadLine(); } } All I want is to programmatically do set credentials like explained in this example on msdn. http://msdn.microsoft.com/en-us/library/ff798456.aspx Please help. Shamshad Ali  

Search Service Application missing in SharePoint 2010

  
I installed SharePoint 2010 (Enterprise edition), enabled Enterprise features but it is missing Search Service Application when I look under Central Administration > Application Management > Manage Service Application.   When I click on New it doesn't even list "Search Service Application".    When I goto Upgrade and Patch Management > Check Product and Patch Installation Status, it tells me that "Microsoft Search Server 2010 Core" was Installed.  Under Manage services of server, "Sharepoint Foundation Search" is started.  Does anyone have an idea why the "Search Service Application" is missing and how can I install it?

Search Service Application missing in SharePoint 2010

  
I installed SharePoint 2010 (Enterprise edition), enabled Enterprise features but it is missing Search Service Application when I look under Central Administration > Application Management > Manage Service Application.   When I click on New it doesn't even list "Search Service Application".    When I goto Upgrade and Patch Management > Check Product and Patch Installation Status, it tells me that "Microsoft Search Server 2010 Core" was Installed.  Under Manager services of server, "Sharepoint Foundation Search" is started.  Does anyone have an idea why the "Search Service Application" is missing and how can I install it?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend