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?

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
-
Andrea De Gouveia commented
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,
-
atti commented
Would be very useful.