Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic arrays.

COM Add-ins present the developer with a way to extend the functionality of Office applications for custom tasks. COM Add-ins are typically used to automate Excel in response to a click of a CommandBar button, a form or dialog box, or some other event specific to Excel such as opening or closing workbooks or entering data on worksheets.

Symptoms. When you automate a Microsoft Office application from Microsoft Visual Basic .NET or Microsoft Visual C# .NET, the Office application does not exit when you call the Quit method. Cause. When Visual Studio .NET calls a COM object from managed code, it automatically creates a Runtime Callable Wrapper (RCW).

HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using Visual C# .NET - Microsoft Support. Excel. This article refers to the following Microsoft .NET Framework Class Library namespaces: System.Data.SqlClient. System.IO. System.Text. IN THIS TASK. SUMMARY. Build the Sample Code. Troubleshooting. Summary.

Power Query is available on three Excel applications, Excel for Windows, Excel for Mac and Excel for the Web. For a summary of all Power Query help topics, see Power Query for Excel Help. Note: Power Query in Excel for Windows uses the .NET framework, but it requires version 4.7.2 or later.

Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.

These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate Microsoft Business Intelligence features and capabilities in Excel, PivotTables, Power Pivot, and Power View.

If you automate Microsoft Excel with Microsoft Visual Basic .NET, Microsoft Visual C# .NET, or Microsoft Visual C++, you may receive the following error when calling certain methods: Error: 0x80028018 (-2147647512) Description: Old Format or Invalid Type Library. Cause.

A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain.

Learn about Excel for the web, how you can get started, and the roadmap for features that are coming.