Compartilhar via


LuisBE on Services

A blog maintained by Luis Bitencourt-Emilio (LuisBE) and geared toward Excel Services programmability and solutions. Focused on the v1 of Excel Services in Office 2007, and the ongoing planning of v2 in Office 14.

Excel Services Calculation Issue Update & Fix!

Please check out David's post for links to the fixes....

Date: 10/10/2007

Calculation Issue Post on Excel Blog

This same calculation issue affects Excel Services, and is being addressed concurrently....

Date: 09/26/2007

Dear Friends and Family, I recently accepted the challenge to raise funds to support the JDRF...

Date: 05/11/2007

Excel Services Team Looking for Customer Connections!

The Excel services team is looking for companies that are using Excel services and are willing to...

Date: 05/10/2007

New blog from an Excel Services Tester

Another one of our prolific Excel Services testers has started up a blog here:...

Date: 05/01/2007

Microsoft Office is Searching for Talented Devs!

Microsoft Office is looking for talented developers to work on cutting edge web-based technologies...

Date: 04/04/2007

Excel Services step-by-step guides

Technet now has some interesting tutorials for Excel Services. Check them out at...

Date: 03/13/2007

New MSDN Article on Extending Excel Services Through UDFs

From yours truly: Summary: Optimize version 1 of the Excel Services programmability framework to...

Date: 02/06/2007

Enable Paging in Your Array Formula UDFs

As I alluded to earlier, one way to overcome the limitation that array formulas do not dynamically...

Date: 02/01/2007

Consuming Business Data Catalog Entities in Excel Services

One of the coolest (only?) SharePoint external data features is the Business Data Catalog (BDC). The...

Date: 01/31/2007

Here are a few books being worked on about Excel Services:...

Date: 01/11/2007

New Excel Services MSDN Forum!

MSDN has created a forum for Excel Services related discussion, you can find it at:...

Date: 01/09/2007

v1 Feedback & Requests for v2 of Excel Services!

<UPDATE: Reworded the post to stay away from any legal issues :o) > We are currently working...

Date: 01/09/2007

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

As you have noticed, many of my samples below use an Array Formula in Excel to retrieve an array of...

Date: 01/09/2007

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

As you may or may not know by now, one of the limitations in this version of Excel Services is the...

Date: 12/11/2006

Refreshing EWA Automatically when Sharepoint Filters are Changed

If you played around with the post on using UDFs to write to SQL databases, you probably ended up...

Date: 11/09/2006

Using UDFs to Write to SQL Databases from Excel Services

There are many reasons why writing straight to a SQL database is a desirable feature on a server....

Date: 11/09/2006

Microsoft Office 2007 Ship Party!

Last Friday was the ship party for a Office 2007. Since this was such a monumental release of...

Date: 11/06/2006

Reloading an EWA Workbook Programmatically.

This will be a quickie. I mentioned the EwaGetSessionId(id) function on my earlier post and didn't...

Date: 10/27/2006

Harvesting and Using the Session ID from EWA.

Every time you open a workbook in Excel Services you are actually creating your own instance of that...

Date: 10/27/2006

Sorry for the post hiatus.

We're getting pretty darn close to shipping and I haven't gotten much of a chance to write up some...

Date: 10/19/2006

Customizing EWA in the XLViewer.aspx Page

As you may have noticed if you have started to play around with Excel Services, the XLViewer.aspx...

Date: 10/19/2006

Consuming Sharepoint Lists in Excel Services

<UPDATE: New CS file attached with a minor bug fix and some major code reduction since I found...

Date: 09/29/2006

Impersonating EWA users in your UDFs

Excel Services UDFs are generally run under the credentials of the service account used by the...

Date: 09/29/2006

Pre-requisites

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good. One...

Date: 09/29/2006

Purpose of this Blog.

I was never big on the whole blogging thing, but I finally convinced myself once I started seeing...

Date: 09/29/2006