Excel.CurrentWorkbook

Excel.CurrentWorkbook is a Power Query M function that retrieves the contents of the current Excel workbook, including tables, named ranges, and dynamic arrays. The function returns a table containing the workbook content.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Excel.CurrentWorkbook() as table

Description

Returns the contents of the current Excel workbook. It returns tables, named ranges, and dynamic arrays. Unlike Excel.Workbook, it does not return sheets.

Related functions

Other functions related to Excel.CurrentWorkbook are:

• Csv.Document
• Excel.ShapeTable
• Excel.Workbook
• Pdf.Tables
• Xml.Tables

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/excel-currentworkbook
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.