Consulting

Results 1 to 2 of 2

Thread: Sleeper: PowerQuery first sheet in workbook

  1. #1
    VBAX Regular
    Joined
    Jun 2008
    Posts
    72
    Location

    Sleeper: PowerQuery first sheet in workbook

    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?

  2. #2
    let Source = Excel.Workbook(File.Contents("c:\temp\a.xlsx")),
    Data = Source{[Item=Source{0}[Name],Kind="Sheet"]}[Data]
    in Data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •