Hello. Is there a way I can tell PowerQuery to open a workbook and use the first sheet as the source?
In VBA, we would say wb.worksheets(1)
Is there an equivalent in PQ?
Printable View
Hello. Is there a way I can tell PowerQuery to open a workbook and use the first sheet as the source?
In VBA, we would say wb.worksheets(1)
Is there an equivalent in PQ?
Code:let Source = Excel.Workbook(File.Contents("c:\temp\a.xlsx")),
Data = Source{[Item=Source{0}[Name],Kind="Sheet"]}[Data]
in Data