Feedback by UserVoice

I suggest you ...

← Feature Requests and Feedback

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
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Renat Tlebaldiev shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
In Product  ·  AdminOffice Developer Team (Microsoft Office Extensibility, Microsoft) responded  · 

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!

Show previous admin responses (1)

2 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
  • 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,

Feature Requests and Feedback: Add-in: Excel

Categories

Feedback and Knowledge Base

(thinking…)