Forum Discussion
How do I include the Excel sheet name for a given table when importing from a folder?
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?
4 Replies
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.
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).
