How can we improve Excel for Windows (Desktop Application)?

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!

17 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Imke Feldmann shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base