Search code examples
c#epplus

Epplus auto select all sheet clone?

In Epplus,i'm using copy worksheet

ExcelPackage package = (ExcelPackage)_workbook;
ExcelWorksheet worksheet = package.Workbook.Worksheets.Copy(existingWorksheetName, newWorksheetName);
_workbook = package;

after exporting the file and open on Excel then all status sheet name is select Img all sheet status is select Anyone know how to fix this? Thanks!!!

Solution

  • i using select in worksheet.That's working

            ExcelPackage package = (ExcelPackage)_workbook;
        if (package.Workbook.Worksheets.Count > 0)
            package.Workbook.Worksheets[1].Select();

        package.SaveAs(new FileInfo(path));