About

excel

Tag Info

Info Newest 1 Bountied Frequent Score Active Unanswered

Only for questions on programming against Excel objects or files, or formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. Do NOT use with other spreadsheet software like [google-sheets].

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. It features calculation, graphing tools, sorting and filtering data, pivot tables and a macro programming language called Visual Basic for Applications (VBA).

Languages and environments for programming against Excel include:

Visual Basic for Application (VBA) - inside Excel
Worksheet Functions / Formulas - inside Excel
Visual Studio Tools for Office (VSTO) - Visual Studio
Office Interop - Visual Studio and Mono
SQL against Excel data, using DAO/ACE or ADO
Open XML and Open XML SDK - Any environment and .NET, respectively
Excel Services - SharePoint
Power Query [aka Get & Transform] (M) - inside Excel (from 2016 onwards, available as an AddIn for Excel 2010 & 2013)
Power Pivot (DAX) - inside Excel (from 2016 onwards, available as an AddIn for Excel 2010 and 2013)