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?
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?
let Source = Excel.Workbook(File.Contents("c:\temp\a.xlsx")), Data = Source{[Item=Source{0}[Name],Kind="Sheet"]}[Data] in Data