Duplicate/Copy a sheet into the same workbook?

[perfeliclemente]

Is there a way to duplicate a worksheet in a workbook? Thanks!

[reviewher]

It's POJO (plain old JS objects) down to the core, so you can duplicate the worksheet by roundtripping through JSON:

/* Assuming:
- `wb` is the original workbook
- `name` is the name of the sheet you want to duplicate
- `new_name` is the new name
*/
var ws = wb.Sheets[sname]; // get original worksheet
var new_ws = JSON.parse(JSON.stringify(ws)); // make a copy of the object
XLSX.utils.book_append_sheet(wb, new_ws, new_name); // append the worksheet

[perfeliclemente]

Thanks!
But how can I also copy the styles from the sheet? I see that only values are copied, but what about the style?

[atljoseph]

Nobody responded?