Copy worksheet values (no formulas or reference)

May 30, 2013 at 10:27 PM
Is it possible to copy a worksheet to another workbook values only?

Here's how im doing right now, but it comes the formulas which i dont want.
            var pck1= new ExcelPackage("book1.xlsx");
            var pck2= new ExcelPackage("book2.xlsx");

            var ws = pck1.Workbook.Worksheets["sheet1"];
            pck2.Workbook.Worksheets.Add ("shet1copied", ws);
At least is something like that, i've shortned the code to be simpler