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!
Imke Feldmann
shared this idea
4 comments
-
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