One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his blog on the new programmability features in the 2010 version of Excel Services. The first set of posts talk about REST and moving forward he will expand to the new JavaScript OM we added this release. Here are the links, if you care at all about building custom solutions for Excel and Excel Services they are a great read:
General posts about REST:
Welcome to the new Excel Services
So what does REST on Excel Services look like???
Discovery via the Excel Services REST APIs
Getting ranges via Excel Services REST as well as Charts and Discovery
Excel Services REST APIs – the basics
Advanced Excel Services REST API capabilities – passing parameters to a spreadsheet
How to seamlessly embed data from Excel Services spreadsheets into Word
The Excel Services Windows Gadget:
Introducing the Excel Services Windows 7 Gadget
Showing Excel ranges in the Excel Services Gadget
Bringing it all back home – using advanced REST functionality with the Excel Services Gadget
And the blog is starting to show how to actually code the gadget:
Coding the Excel Services Windows 7 Gadget – Part 1 - Settings
Question - I've done some research & I don't believe it is possible to do what I want to do, but I thought maybe you might know of some way that it can be done. I am wanting to import data from an Excel 2007 document that is copied (file, save as) each month into another Excel 2007 document where the distination cells change each month. The main data source (contains formulas) calculates how much is spent each month on elec, gas, elevator maintenance, etc. for different buildings & the final calculated numbers need to filter into the destination file/cells - this is why it changes each month, as bills are paid monthly. Is this possible?
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using RSS
