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?
Renat Tlebaldziyeu
shared this idea
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.