Open excel with EPPlus without saving to file

Question

Rright now I'm opening excel using System.Diagnostics.Process.Start(fileInfo);

to open my package after saving it to a file.

Is it possible to open excel without having to save the file to a location? I would like the user to decide whether or not to save the file.

Answer 1

If you're generating the file yourself using EPPlus (or any other libraries that generate the file directly), you'll need to save it before you can open it in Excel. I'd recommend just saving it in the temp directory, then showing it to the user and letting them choose what to do with it.

If you generate the file using Office Automation, you can display it to the user before saving it.