excel package view it in the Excel application without saving

[kadir133]

excel package view it in the Excel application without saving

[OssianEPPlus]

That's not possible.

Excel uses .xlsx files to read in data. Epplus reads the data from this file in and stores it in memory accessible via programming through its variables for example in a variable of ExcelWorksheet type. There is no file with the edited data until you save. So Excel cannot open it without saving.

[kadir133]

Thank you for your interest. Then I found a solution like this. I save it to the temp folder. I'm viewing it from there. The temp file is automatically deleted when the application is closed.

            // Create a temporary file collection and add a temporary file with ".xlsx" extension.
            string filePath = new TempFileCollection().AddExtension("xlsx");

            package.SaveAs(filePath);

            // Create a new Process object to start an external process (Excel application).
            using (var excelProcess = new Process())
            {
                // Specify the file to be executed (Excel.exe).
                excelProcess.StartInfo.FileName = "Excel.exe";
                excelProcess.StartInfo.UseShellExecute = true;

                // Specify the file information to be opened in Excel. The "/n" parameter ensures that Excel is opened in a new window.
                excelProcess.StartInfo.Arguments = "/n " + filePath;
                // Start the Excel application.
                excelProcess.Start();
            }