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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Video: Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :SharePoint
 
Watch a short video that shows how to programatically retrieve data from an Excel workbook.


View Complete Post


More Related Resource Links

Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How To)

  
Learn how to use the REST API to retrieve resources such as ranges, charts, tables, and PivotTables from workbooks stored on SharePoint Server 2010.

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.

Video: Creating an Excel Services and Bing Maps Mash-up for SharePoint 2010 (Visual How To)

  
Watch a short video as you learn to use Bing Maps AJAX controls to interact with Excel Web Access web parts.

Using the Calculation Power of Excel Using Excel Services in SharePoint Server 2010 (Visual How To)

  
Learn how to use Excel Web Services to harness the calculation power of Microsoft Excel programmatically.

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 Server 2010 - no Excel Services?

  
hello   I've installed sharepoint server and wanted to configure Excel Services ...   and I cannot find any Excel Services in Central Administration portal there is information that services are installed but there is no such option in Administration portal   what went wrong ?   regards  

Sharepoint 2010 Excel Services Extranet Access

  

Hi to all,
I've an environment that includes 3 machines: the sp2010 frontend (W2K8 R2), the sp2010 backend (SQL2008 R2), the analysis services backend (SQL2008 R2).

I've successfully setup my environment with Kerberos constrained delegation and the entire thing works fine with both performancepoint and excel services (the requirement was to pass the user's domain identity to the analysis backend): thanks to the excellent SP2010 Kerberos Guide.

Now I've extended this portal to the Extranet zone, assigned it a new host header and upgraded my SPNs to include the new fqdn and also added it to the necessary accounts in Active Directory.

In the intranet environment everything is fine. I've published the Sharepoint site to the external network onto the ISA 2006 and setup the Kerberos constrained delegation from the isa computer account to the Sharepoint SPN.

So here is the point: I can correctly access the Sharepoint site from external with Kerberos authentication, performancepoint is fine but I cannot open excel workbooks from this zone, I already trusted both the file and the data connection locations with the external fqdn but still no luck. Even the sample workbook does not open. The error is "error while trying to execute the requested action. Retry".

Anyone has any hint on the possible causes?

Thanks in

Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)

  

Hello,

In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

Excel
-----
An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name
-----
OK

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Creating an Excel Services and Bing Maps Mashup for SharePoint 2010 (Visual How To)

  
Learn how to use a Bing Maps AJAX control to interact with an Excel Web Access Web Part using the Excel ServicesECMAScript object model.

Video: Using the Excel Services 2010 REST API

  
Learn to use the Excel Services REST API to access items and work with data in a spreadsheet.

New Content on Excel Services and Word Automation Services Development for SharePoint Server 2010 (B

  
Check out the new visual how-to videos and articles that showcase how to create interactive solutions around Excel Services in SharePoint 2010, as well as book excerpts for Excel Services and Word Automation Services.

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.

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.

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

  
Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Interacting with the Excel Web Services API for SharePoint Server 2007

  
Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Converting Word Documents to PDF using SharePoint Server 2010 and Word Services (Visual How To)

  
Watch the video and explore code as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010.
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