Forum Discussion
undefined
Hello jacksonlam
yes, you can. Use the function Excel.Workbook(File.Contents(yourfilename),null, true) to create a table with your Excelobjects. Apply a filter if needed on this table. Apply a function to the table if you would like to transform the data or use Table.ExpandTableColumn to extract your data.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
How would you get those new tables to automatically expand to new queries though Jimmy801 - I would assume the tables would not be the same format, otherwise, they would just be additional rows in existing tables.
Hello edhans
for sure they have to have the same format, or at least following the same logic to extract the data. I had one time a case were they maintained assetts in one big excel-file, and whenever a assett was created from a template and by adding a new sheet, this new data needed to be integrated in a power-pivot database.
BR
Jimmy
