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...
Hi dehmos27 ,
Could you please show your issue page screenshot for further analysis?
Best Regards,
Amy
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.