How do I include the Excel sheet name for a given table when importing from a folder?

[dehmos27]

I am importing the contents of a folder of Excel files using Excel.Workbook([Content[). When I expand this column, I get an Item column and a Name column, but they both list the name of the tables in question. I want to import using tables but associate the sheets with the tables as I import. Is this possible?

[v-xicai]

Hi @dehmos27 ,

>>I am importing the contents of a folder of Excel files using Excel.Workbook([Content[).

Does it mean geting data from the Folder connector like below? If so, when you click the "Load" option, it already has the Excel sheet name.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dehmos27]

@v-xicai,

Thank you for your response. The sheet name does show by default, but this does not work if attempting to combine multiple Excel workbooks with varying table structures into a single file. Where the issue crops up is after clicking "Edit" before performing the "Combine" step, you add a custom column that uses the code provided: =Excel.Workbook([Content]). When a user expands the new custom column, he or she can filter to either import tables or sheets, but the tables do not give the Worksheet name (sadly).

[v-xicai]

Hi @dehmos27 ,

Could you please show your issue page screenshot for further analysis?

Best Regards,

Amy

[dehmos27]

Here is a sample:

When I reference the workbook using the previously described Custom column, I get the following:

I want to know if it is possible to actually expose the name of the sheet on which the table belongs to preserve the metadata stored in the sheet title. So, for Table 1, 19AprUsedCAD might be the name of the sheet, and so on.