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.

Blog - About

Luis Bitencourt-Emilio & LuisBE on Services

About Me

My name is Luis Bitencourt-Emilio and I will be your host for this blog. I am currently an SDET in the Excel team where I've been since my internship in the Summer of 2005, and as an FTE since March of 2006.  Prior to that I worked at IBM while finishing up my Computer Engineering degree from the University of Maryland.

 I was born in Brazil but have lived in the USA since 1994 when my father moved here to get his PhD from Catholic University.  Most of that time was spent in MD, with a short stay in NC while I was on-site at IBM.

About My Blog

I have been doing a lot of exploratory work with Excel Services, focusing on it's extensibility through the programmability framework (UDFs, APIs, ASPX, and Javascript).  I would constantly get questions as to how to accomplish things that Excel Services does not support out of the box, or how to get this v1 product to do something it was never designed for (at least in this version). 

 This blog will primarily be a single point of contact between my solutions and the general public.

 As we gear up for the v2 of Excel Server in Office 14 this blog may also host some posts on what we are working on in v2, and what scenarios will be enabled due to our work in that version.

  • LuisBE on Services

    Excel Services Calculation Issue Update & Fix!

    • 1 Comments
    Please check out David's post for links to the fixes. http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx
  • LuisBE on Services

    Calculation Issue Post on Excel Blog

    • 1 Comments
    This same calculation issue affects Excel Services, and is being addressed concurrently. http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx
  • LuisBE on Services

    Sponsor me for JDRF's Beat the Bridge!

    • 1 Comments
    Dear Friends and Family, I recently accepted the challenge to raise funds to support the JDRF Northwest - Nordstrom Beat the Bridge in its efforts to find a cure for diabetes and it's deadly complications. Every day 35 more children are diagnosed with...
  • LuisBE on Services

    Excel Services Team Looking for Customer Connections!

    • 0 Comments
    The Excel services team is looking for companies that are using Excel services and are willing to share their feedback with the team. Feedback can be in the form of visits to the customer sites, conference calls or special events that will be organized...
  • LuisBE on Services

    New blog from an Excel Services Tester

    • 0 Comments
    Another one of our prolific Excel Services testers has started up a blog here: http://blogs.msdn.com/sherder/ Go check it out! I've been a little dark on the blog lately in order to focus 100% on planning for O14, but I'll be back soon!
  • LuisBE on Services

    Microsoft Office is Searching for Talented Devs!

    • 0 Comments
    Microsoft Office is looking for talented developers to work on cutting edge web-based technologies that integrate with Excel and Access. It’s a great opportunity to work on cool new features and build great products. You may have already heard about Excel...
  • LuisBE on Services

    Excel Services step-by-step guides

    • 3 Comments
    Technet now has some interesting tutorials for Excel Services. Check them out at http://technet2.microsoft.com/Office/en-us/library/eea3ace8-0863-429a-b1e8-041254ed2fc41033.mspx?mfr=true Enjoy!
  • LuisBE on Services

    New MSDN Article on Extending Excel Services Through UDFs

    • 1 Comments
    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...
  • LuisBE on Services

    Enable Paging in Your Array Formula UDFs

    • 0 Comments
    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...
  • LuisBE on Services

    Consuming Business Data Catalog Entities in Excel Services

    • 0 Comments
    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...
  • LuisBE on Services

    Excel Services Related Books in the Pipeline

    • 1 Comments
    Here are a few books being worked on about Excel Services: http://www.amazon.com/Beginning-Excel-Services-Liviu-Asnash/dp/0470104899/sr=8-1/qid=1168539718/ref=sr_1_1/105-2258527-0791610?ie=UTF8&s=books http://www.amazon.com/Professional-Excel...
  • LuisBE on Services

    New Excel Services MSDN Forum!

    • 0 Comments
    MSDN has created a forum for Excel Services related discussion, you can find it at: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1208&SiteID=1 We're working on a more readable shortcut, and it's empty as of right now but you can expect...
  • LuisBE on Services

    v1 Feedback & Requests for v2 of Excel Services!

    • 7 Comments
    <UPDATE: Reworded the post to stay away from any legal issues :o) > We are currently working on planning for the next version of Excel Services and I would greatly appreciate any v1 feedback as well as requests you would like to see implemented...
  • LuisBE on Services

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

    • 1 Comments
    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...
  • LuisBE on Services

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

    • 1 Comments
    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...
  • LuisBE on Services

    Refreshing EWA Automatically when Sharepoint Filters are Changed

    • 8 Comments
    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...
  • LuisBE on Services

    Using UDFs to Write to SQL Databases from Excel Services

    • 4 Comments
    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...
  • LuisBE on Services

    Microsoft Office 2007 Ship Party!

    • 1 Comments
    Last Friday was the ship party for a Office 2007. Since this was such a monumental release of Office, the ship party had to live up to the years of hard work this release required... and it did. First was the party itself, outdoors in the Microsoft...
  • LuisBE on Services

    Reloading an EWA Workbook Programmatically.

    • 0 Comments
    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...
  • LuisBE on Services

    Harvesting and Using the Session ID from EWA.

    • 1 Comments
    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...
  • LuisBE on Services

    Sorry for the post hiatus.

    • 0 Comments
    We're getting pretty darn close to shipping and I haven't gotten much of a chance to write up some of the posts I have been meaning to. Hopefully things will slow down soon enough so I can get to them. I'm planning on posting on the following solutions...
  • LuisBE on Services

    Customizing EWA in the XLViewer.aspx Page

    • 4 Comments
    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...
  • LuisBE on Services

    Consuming Sharepoint Lists in Excel Services

    • 32 Comments
    <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...
  • LuisBE on Services

    Impersonating EWA users in your UDFs

    • 1 Comments
    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...
  • LuisBE on Services

    Pre-requisites

    • 1 Comments
    Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good. One of our Devs in Excel Services has done a great job with posts on Excel Services User Defined Functions (UDFs) and programmability in general. I use...
Page 1 of 2 (26 items) 12