title: Excel.Workbook in Power Query: order of sheets of files in a folder
body: <p>I am just trying to get a list of the names of all excel files in a given folder &amp; then pull the sheet names in each file plus the sheet index.</p>
  <p>I use Power Query to get data from a folder &amp; I add this column:</p>
  <pre><code>= Table.AddColumn(#&quot;Removed Other Columns&quot;, &quot;Custom &quot;, each Excel.Workbook(File.Contents([Folder Path] &amp; &quot;\&quot; &amp; [Name]), null, true))
  </code></pre>
  <p>When I expand the added column, I get 'Name', 'Data', 'Item', 'Kind' &amp; 'Hidden'. I would like to get the index of the sheet.</p>
  <p>Can I assume the names of the sheets are in increasing order? Or do I have to get the sheet index somehow? If I have to get the sheet index, what code can I use please?</p>
  <p>Thanks!</p>