Excel developer roadmap

• Excel 2010 XLL SDK
• Office Fluent User Interface XML Schema
• 2007 Office System: How Do I Screencasts

• Excel Data Reader - Read Excel File in .NET
• ExcelPackage: Office Open XML Format File Creation
• ExtremeML
• Import Excel Data to SharePoint List
• NPOI
• OLAP PivotTable Extensions
• PHPExcel

• COM Access to Excel Web Services
• Excel Exporter
• Excel Financial Functions for .NET
• ExcelUtility
• Generating Excel Document Templates from Data
• Managed Excel Automation Add-in UDFs
• Microsoft Solver Foundation - Express Edition
• Office Development in Visual Studio 2010 Samples
• Open XML Converter Interface Sample Code
• Reading an Excel Spreadsheet Using ADO.NET
• Using Cell Text to Filter a PivotTable
• Using Microsoft Excel to Log and Analyze Serial Port Data

Developer Reference

• Excel 2010 Developer Reference
• Slicer Object
• Sparkline Object

Book Chapters

• Make a Macro Do Simple Tasks

Visual How Tos

• Using the Vlookup Function in Excel

MVP Content

• Editing Data in an Excel 2007 Open XML File with VBA
• Working with Lists and Tables in Excel: VBA Samples

• Getting Started with VBA in Excel 2010
• Compatibility Between the 32-bit and 64-bit Versions of Office 2010
• Working with the Compatibility Checker in Excel 2007 and Excel 2010
• Developers Guide to the Excel Application Object
• Excel 2010 Performance: Improving Calculation Performance
• Excel 2010 Performance: Performance and Limit Improvements
• Excel 2010 Performance: Tips for Optimizing Performance Obstructions

• Show the Developer Tab
• What is a Macro and Why You Should Care
• Create or Delete a Macro
• Working with Excel 4.0 Macros

Developer Reference

• Working with the Active Cell
• How to: Reference Cells and Ranges
• Looping Through a Range of Cells

Articles

• Developers Guide to the Excel Range Object

Book Chapters

• Explore Range Objects

MVP Content

• Filtering by the Active Cell's Value, Font Color, or Fill Color in Excel

Developer Reference

• How to: Create a Workbook
• How to: Refer to Sheets by Name
• Worksheet Object Events

Articles

• Creating VBA Macros to Manipulate Worksheets in Excel

MVP Content

• Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel
• Merging Data from Multiple Workbooks into a Summary Workbook in Excel
• Using Styles to Dress Up Your Worksheets in Excel
• Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook

• Excel Solutions
• Getting Started Programming Document-Level Customizations for Excel
• Using Windows Forms Controls on Excel Worksheets

• Programming with Slicers in Excel 2010
• Programming with Sparklines in Excel 2010
• Calling Code in an Application-Level Add-In from VBA
• Creating PivotTables In Excel
• Creating a Master-Detail View in Excel
• Creating Auto Filtered Tables

MVP Content

• Building Excel 2007 and Excel Services Dashboards by Consuming Two-Dimensional Data from Web Services

Channel 9 Videos

• Office 2010 Developer Roadmap: Office 2010 Development Tools

Articles

• Using Custom Data Parts in Excel 2010

» More Excel Solutions with Visual Studio

Developer Reference

• How to: Display a String in a Worksheet Cell
• How to: Refer to Worksheet Ranges in Code
• How to Search for Text in Worksheet Ranges
• How to: Run Excel Calculations Programmatically

Visual How Tos

• Setting Conditional Formatting in Excel
• How to: Add NamedRange Controls to Worksheets
• How Do I: Make Dynamic Validation Ranges in Excel?

» More Excel Solutions with Visual Studio

Developer Reference

• How to: Create New Workbooks
• How to: Add New Worksheets to Workbooks
• How to: Sort Data in Worksheets Programmatically
• Using Windows Forms Controls on Excel Worksheets
• How to: Add Chart Controls to Worksheets

Visual How Tos

• Publishing Excel Workbooks to SharePoint Server

» More Excel Solutions with Visual Studio

Developer References

• Programming with the C API in Excel 2010
• Excel Programming Concepts
• Creating XLLs
• Asynchronous User-Defined Functions
• C API Functions That Can Be Called Only from a DLL or XLL

Articles

• UDF Offloading to HPC 2008
• Real-Time Data: Frequently Asked Questions
• Building a Real-Time Data Server in Excel
• Building Excel Real-Time Data Components in Visual Basic

Downloads

• Excel 2010 XLL SDK

Visual How Tos

• Writing Asynchronous User-Defined Functions in Excel 2010

» More XLL Content

Developer Reference

• Cluster Safe Functions
• Developing Excel 2010 Cluster Connectors
• Excel Cluster Connector Functions

Articles

• Offloading XLLs to a Cluster Connector

Developer Reference

• Windows HPC Server R2 Beta Technical Overview

» More XLL Content

• Office Fluent User Interface XML Schema
• Custom UI Editor Tool (Updated)

• Introduction to the Office 2010 Backstage View for Developers
• Ribbon Extensibility in Office 2010: Tab Activation and Auto-Scaling
• Deploying a Customized Ribbon and Quick Access Toolbar in Office 2010
• Customizing the Office 2010 Backstage View for Developers
• Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 1 of 2)
• Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 2 of 2)
• Creating Custom Ribbon Galleries in Excel 2007

Channel 9 Videos

• Office 2010 UI Customization: Office and Visual Studio 2010
• Office 2010 UI Customization: Office UI Customizations
• Office 2010 UI Customization: Custom Task Panes

Office.com

• Customize the Ribbon
• Customize the Quick Access Toolbar

» More Fluent UI Content

• Excel Services Overview
• Excel Services Best Practices

• Retrieving an Entire Workbook or a Snapshot of a Workbook in Excel Services
• How Do I: Publish a Dynamic Excel Workbook File to Excel Services?

Book Chapters

• An Introduction to Excel Services
• Building Custom Solutions

Articles

• Excel Services Technical Overview
• Ten Tips for Using SharePoint Server with Excel Services
• Extending the Excel Services Programmability Framework

TechNet

• Overview of Excel Services Architecture
• Excel Services Administration (SharePoint Server 2010)

Channel 9 Videos

• Developing BI Applications: What is Business Intelligence?

» More Excel Services Content

Developer Reference

• Accessing the SOAP API
• How to: Get Values from Ranges
• How to: Refresh Data
• Microsoft.Office.Excel.Server.WebServices Namespace

Articles

• Developing for SharePoint 2010 Excel Services Using Web Services or the Excel Services REST API
• Using Excel Web Services in a SharePoint Web Part

Visual How Tos

• Developing Custom Applications by Using Excel Web Services in SharePoint Server
• How Do I: Use the Excel Web Services?

MVP Content

• Interacting with the Excel Web Services API for SharePoint Server

» More Excel Services Content

Developer Reference

• Understanding Excel Services UDFs
• How to: Create a UDF that Calls a Web Service

Articles

• Developing User-Defined Functions for Excel and Excel Services
• Data-Type Handling with Excel Services User-Defined Functions

Visual How Tos

• Creating Managed-Code UDFs for Excel Services
• How Do I: Create Excel Services with User-Defined Functions?

Book Chapters

• Client Support For Server UDFs

» More Excel Services Content

Developer Reference

• How to: Programmatically Add an Excel Web Access Web Part to a Page

Visual How Tos

• Adding Excel Web Parts to Pages Programmatically in SharePoint Server

Book Chapters

• Excel Web Access

» More Excel Services Content

ECMAScript and REST

Developer Reference

• Excel Services ECMAScript Overview
• Walkthrough: Developing Using Content Editor Web Part
• Excel Services ECMAScript EWA Namespace

Microsoft Excel Blog

• Introducing the JavaScript Object Model for Excel Services in SharePoint 2010

Excel Services REST API

Developer References

• Excel Services REST API Overview
• Getting Ranges Using Atom Feed and HTML Fragment
• Resources URI for Excel Services REST API

Microsoft Excel Blog

• Excel Services in SharePoint 2010 REST API Syntax

Articles

• Using the Excel Services 2010 REST API

» More Excel Services Content

• About the Open XML SDK 2.0 for Microsoft Office
• How to: Insert a New Worksheet into a Spreadsheet Document
• How to: Insert Text into a Cell in a Spreadsheet Document
• DocumentFormat.OpenXml.Spreadsheet Namespace

• Displaying Open XML Spreadsheet Tables in a Browser by Using Silverlight
• Merging Simple Content from Excel Workbooks and Worksheets by Using the Open XML SDK 2.0
• Using LINQ to Query Tables in Excel

Articles

• Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0
• Retrieving the Values of Cells in Excel 2010 Workbooks by Using the Open XML SDK 2.0
• Inserting a Header or Footer into an Excel 2010 Workbook by Using the Open XML SDK 2.0
• Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

Channel 9 Videos

• Open XML: Introducing Open XML
• Open XML: Open XML Architecture
• Open XML: Open XML Tools and APIs

» More Open XML Content

• PowerPivot Overview
• PowerPivot Features
• PowerPivot for Excel
• Roadmap to Creating PowerPivot Workbooks in Excel

Overview and How To Videos

• PowerPoint Videos

Downloads

• PowerPivot Downloads