Opening Excel Document using EPPlus

Question

I am trying to open an Excel document using EPPlus reference/package. I can't get the Excel application to open. What code am I missing?

protected void BtnTest_Click(object sender, EventArgs e) {      FileInfo newFile = new FileInfo("C:\\Users\\Scott.Atkinson\\Desktop\\Book.xls");       ExcelPackage pck = new ExcelPackage(newFile);      //Add the Content sheet      var ws = pck.Workbook.Worksheets.Add("Content");      ws.View.ShowGridLines = false;       ws.Column(4).OutlineLevel = 1;      ws.Column(4).Collapsed = true;      ws.Column(5).OutlineLevel = 1;      ws.Column(5).Collapsed = true;      ws.OutLineSummaryRight = true;       //Headers      ws.Cells["B1"].Value = "Name";      ws.Cells["C1"].Value = "Size";      ws.Cells["D1"].Value = "Created";      ws.Cells["E1"].Value = "Last modified";      ws.Cells["B1:E1"].Style.Font.Bold = true; } 

I have tried pck.open(newFile);, but it doesn't allow it ...

Answer 1

Try this:

protected void BtnTest_Click(object sender, EventArgs e) {     FileInfo newFile = new FileInfo("C:\\Users\\Scott.Atkinson\\Desktop\\Book.xls");      ExcelPackage pck = new ExcelPackage(newFile);     //Add the Content sheet     var ws = pck.Workbook.Worksheets.Add("Content");     ws.View.ShowGridLines = false;      ws.Column(4).OutlineLevel = 1;     ws.Column(4).Collapsed = true;     ws.Column(5).OutlineLevel = 1;     ws.Column(5).Collapsed = true;     ws.OutLineSummaryRight = true;      //Headers     ws.Cells["B1"].Value = "Name";     ws.Cells["C1"].Value = "Size";     ws.Cells["D1"].Value = "Created";     ws.Cells["E1"].Value = "Last modified";     ws.Cells["B1:E1"].Style.Font.Bold = true;      pck.Save();     System.Diagnostics.Process.Start("C:\\Users\\Scott.Atkinson\\Desktop\\Book.xls"); } 

Hope this helps!

Answer 2

Try this in ASP NET Core to avoid win32 exception:

private void CreateWorkbook(string fileName) {     using (var p = new ExcelPackage())     {         p.Workbook.Properties.Author = "Barry Guvenkaya";         p.Workbook.Properties.Title = "MyTitle";         p.Workbook.Worksheets.Add("MySheet");         var bin = p.GetAsByteArray();         File.WriteAllBytes(fileName, bin);          // Below code opens the excel doc         var proc = new Process();         proc.StartInfo = new ProcessStartInfo(fileName)         {             UseShellExecute = true         };         proc.Start();     } }