Feedback by UserVoice

 

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

← 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!

65 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

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

7 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • david ashear commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

Excel for Windows (Desktop Application): Data Import

Categories

Feedback and Knowledge Base

(thinking…)