I would like to simply copy one sheet within my workbook and give it a different name.
var pointName1 = workbook.Worksheets["PointName1"] as Worksheet;
pointName1.Copy(); // How do I access this newly created sheet?
Ideally I would like be able to write a method like this
pointName1.CopyTo("New Sheet");
where 'New Sheet' is a renamed copy of 'PointName1'.
Sometimes PointName1 will be the only sheet in the workbook, other times there will be others.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With