.NET (Core and Framework)

Excel.Application oExcel = new Excel.Application();
                oExcel.Visible = true;
                Excel.Workbooks oWorkbooks = oExcel.Workbooks;
                string Pfad = "C:\test.xlsx";
                Excel.Workbook oWorkbook = oWorkbooks.Open(Pfad);

                Excel.Worksheet oSheet = oWorkbook.Sheets[1];
                
                oSheet.Cells[1, 1] = "Test";
                
                oSheet.SaveAs("C:\test.xlsx");

                GC.Collect();
                GC.WaitForPendingFinalizers();
                        
                Marshal.FinalReleaseComObject(oSheet);
                oWorkbook.Close();                
                Marshal.FinalReleaseComObject(oWorkbook);
                oExcel.Workbooks.Close();                
                Marshal.FinalReleaseComObject(oWorkbooks);
                oExcel.Application.Quit();                
                Marshal.FinalReleaseComObject(oExcel);
                oExcel = null;

Dim dt As New DataTable()
dt.Columns.Add("Name")
dt.Columns.Add("Count")
Dim manpower1 As Integer
Dim present1 As Integer
For Each row As DataGridViewRow In manpower.Rows
    dt.Rows.Add(row.Cells(1).Value)
Next
For Each row1 As DataGridViewRow In present.Rows
    present1 = (row1.Cells(1).Value)
    dt.Rows.Add(manpower1 - present1)
Next
For Each row2 As DataGridViewRow In manpower.Rows
    dt.Rows.Add(manpower1 - present1)
Next
absent.DataSource = dt

try
                {
                    using (MemoryStream ms = new MemoryStream(fileData))
                    {                        
                        List<string> dangerous_files = new List<string>();
                        string msgModel = "ZIP: {zip} - ({file})";
                        using (ZipArchive archive = new ZipArchive(ms))
                        {
                            foreach (var entity in archive.Entries)
                            {
                                if (denyExtensions.Contains(entity.FullName.Split('.').LastOrDefault().ToLower()))
                                {
                                    dangerous_files.Add(msgModel.Replace("{zip}", GetRidOfSlash(file.FileName)).Replace("{file}", entity.FullName));
                                }
                            }
                            if (dangerous_files.Count > 0)
                            {
                                Response.TrySkipIisCustomErrors = true; Response.StatusCode = 500;
                                return Json(new
                                {
                                    error = errMsg,
                                    code = "500.1",
                                    files = dangerous_files
                                });
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    LogHandler.LogError(4203, "Zip file creation failed Upload - Picture", ex);
                    throw ex;
                }

using (ZipArchive archive = new ZipArchive(ms))