Feedback by UserVoice

I suggest you ...

Add a method to copy a sheet with all data and formatting because there are no back-up or undo options for add-ins.

Since there is no way to cancel the changes made by an add-in, we need to provide users with backup options.

The current version of JavaScript API for Excel doesn't have a method for copying a sheet with its data and formatting, there are no elegant and fast workarounds available.

Could you please let us know if it's possible to add this method to JavaScript API for Excel?

114 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Renat Tlebaldziyeu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    now we have this API please use it!
    here the details: https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/worksheet.md#copypositiontype-worksheetpositiontype-relativeto-worksheet

    worksheetObject.copy(positionType, relativeTo);

    Copy a worksheet and place it at the specified position. Return the copied worksheet.

    Enjoy!

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Andrea De Gouveia commented  ·   ·  Flag as inappropriate

        Dear Office Extensibility Team,

        Is there any updates about the method that Renat mentioned in the JavaScript for Excel? I have checked the GitHub, but I didn't find it.

        Thanks,

      Feedback and Knowledge Base