Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel Services Programmability   (RSS)
Sorry, but there are no more tags available to filter with.

New MSDN Article on Extending Excel Services Through UDFs

Posted Tuesday, February 06, 2007 1:11 PM by LuisBE
From yours truly: Summary: Optimize version 1 of the Excel Services programmability framework to extend Microsoft Office Excel 2007 and Excel Services functionalities to work with SharePoint lists, query tables on Excel Services, external workbook references, Read More...
1 Comments

Enable Paging in Your Array Formula UDFs

Posted Thursday, February 01, 2007 1:04 PM by LuisBE
As I alluded to earlier, one way to overcome the limitation that array formulas do not dynamically resize to fit the dimensionality of the data being returned by your UDF is to use paging. Here is a simple way of enabling paging, without having to modify Read More...
0 Comments

Consuming Business Data Catalog Entities in Excel Services

Posted Wednesday, January 31, 2007 8:47 PM by LuisBE
One of the coolest (only?) SharePoint external data features is the Business Data Catalog (BDC). The BDC is brand new with SharePoint 2007, and is not yet fully integrated into Excel and Excel Services... though, if you've read one or two other entries Read More...
0 Comments

Working Around Dimensional Limitations of Using Array Formulas for UDF Return Values.

Posted Tuesday, January 09, 2007 11:42 AM by LuisBE
As you have noticed, many of my samples below use an Array Formula in Excel to retrieve an array of data returned by your UDF code. The biggest issue with taking this approach is that you need to know ahead of time the exact dimensions of the data being Read More...
1 Comments

Using UDFs and Excel Formulas to Get a Query Table on Excel Services

Posted Monday, December 11, 2006 11:36 AM by LuisBE
As you may or may not know by now, one of the limitations in this version of Excel Services is the inability to publish workbooks containing Query Tables (tables that have external data as their source). There have been numerous blog posts on the web Read More...
1 Comments
Attachment(s): QT4Server.xlsx

Refreshing EWA Automatically when Sharepoint Filters are Changed

Posted Wednesday, November 08, 2006 10:08 PM by LuisBE
If you played around with the post on using UDFs to write to SQL databases, you probably ended up creating a PivotTable connected to the SQL database the UDFs were writing to in order to see the new data showing up on the database. As you would have noticed Read More...
8 Comments

Using UDFs to Write to SQL Databases from Excel Services

Posted Wednesday, November 08, 2006 9:14 PM by LuisBE
There are many reasons why writing straight to a SQL database is a desirable feature on a server. For example, one could imagine a solution where users would load up a workbook on Excel Services, change some parameters, and have that new data saved to Read More...
4 Comments

Reloading an EWA Workbook Programmatically.

Posted Thursday, October 26, 2006 11:06 PM by LuisBE
This will be a quickie. I mentioned the EwaGetSessionId(id) function on my earlier post and didn't want to forget the other useful Javascript function we're shipping in the EwrScripts.js file. With a simple Javascript function call you can trigger a workbook Read More...
0 Comments

Harvesting and Using the Session ID from EWA.

Posted Thursday, October 26, 2006 10:01 PM by LuisBE
Every time you open a workbook in Excel Services you are actually creating your own instance of that workbook. Excel Services keeps track of those instances by assigning them a text string called a session ID. Once a session is created you can perform Read More...
1 Comments

Customizing EWA in the XLViewer.aspx Page

Posted Thursday, October 19, 2006 1:54 AM by LuisBE
As you may have noticed if you have started to play around with Excel Services, the XLViewer.aspx page is the leanest way to open up a workbook on the server. There is very little Sharepoint UI added to this page and you are basically given a full screen Read More...
4 Comments
Attachment(s): MyXLViewer.aspx

Consuming Sharepoint Lists in Excel Services

Posted Thursday, September 28, 2006 11:42 PM by LuisBE
<UPDATE: New CS file attached with a minor bug fix and some major code reduction since I found the SharePoint format converter method :o) > There are a few features that the v1 of Excel Services will not support out of the box. One of these is grabbing Read More...
32 Comments
Attachment(s): Class1.cs

Impersonating EWA users in your UDFs

Posted Thursday, September 28, 2006 11:18 PM by LuisBE
Excel Services UDFs are generally run under the credentials of the service account used by the Office Server installation. This may not be exactly what you want if you would like your UDFs to return data that is specific to the user that opened the workbook. Read More...
1 Comments
 
Page view tracker