Harmonize Excel.CurrentWorkbook with Excel.Workbook
Please adjust the M-function "Excel.CurrentWorkbook" so that it returns the same items (in the same structure) than Excel.Workbook (in connection with File.Contents) does:
Returning a table view of all elements with helpful columns like "Kind".
But most importantly also returning content from sheets that isn't in a special format like Table or Defined Name but in a simple range.
There are multiple reasons for letting the source-data untouched but also performing transactions on them and I've come across this request very often. The workarounds are pretty painful (error-prone and need to save file before being able to access data).
Thanks a lot!

Thank you for posting and voting for this. Unfortunately, changing the implementation of Excel.CurrentWorkbook will break the existing solutions. With this in mind, we are currently not planning to do it.
Guy Hunkin
Principal PM
Excel Team
8 comments
Comments are closed-
Carrie Davidson commented
Yes - please do this.
-
Anonymous commented
I support the changes proposed here.
-
Lz. commented
Ho YES++ the [Kind] column is a MUST HAVE
-
david ashear commented
Please adjust the M-function "Excel.CurrentWorkbook" so that it returns the same items (in the same structure) than Excel.Workbook (in connection with File.Contents) does:
-
Sanjeev Soni commented
We need to check ay time and combine specific sheets in the current workbook; Please add the functionality to provide same list as Excel.Wookbook
-
Sanjeev Soni commented
There are many instants where need to Grab the Data of the current sheets; These may not be Tables. Therefore "Excel.CurrentWorkbook" shall return the same List that "Excel.Workbook" returns.
-
Anonymous commented
excel herstellen
-
Anonymous commented
In nederlands excel herstellen 2016