Ufdjrw

I have ASP.Net core project and class library associated. In class library I have my code to update Excel file. It works fine when used in unit test or called from native console app. But it neither throws exception nor modify/update excel file when called from web app.

public bool SaveOrder(Order order)

 excelApp = new Excel.Application();
 excelBook = excelApp.Workbooks.Open(_dbPath);
 orderMenuSheet = (Excel.Worksheet)excelBook.Worksheets.get_Item(2);
 try
 
 foreach (var menu in order.OrderItems)
 
 var rowNum = menu.MenuNumber + 2;
 orderMenuSheet.Cells[rowNum, 3] = menu.Menu;
 orderMenuSheet.Cells[rowNum, 7] = menu.Rating;
 orderMenuSheet.Cells[rowNum, 8] = menu.Review;
 
 excelBook.Save();
 
 catch (Exception)
 
 return false;
 
 finally
 
 DisposeExcelObject(); //dispose excel objects
 
 return true;

i change some code and its works for me.i Hope it will help

 System.Globalization.CultureInfo oldCI = System.Threading.Thread.CurrentThread.CurrentCulture;
 System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");

 // Creating Excel Application
 Microsoft.Office.Interop.Excel._Application excelApp = new Microsoft.Office.Interop.Excel.Application();
 System.Threading.Thread.CurrentThread.CurrentCulture = oldCI;

 var fileName = Path.Combine(_he.WebRootPath + "\ClientFile", "test.xlsx");
 var excelBook = excelApp.Workbooks.Open(fileName);
 var orderMenuSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelBook.Sheets["QUESTIONNAIRE PACK"];
 foreach (var menu in order.OrderItems)
 
 var rowNum = menu.MenuNumber + 2;
 orderMenuSheet.Cells[rowNum, 3] = menu.Menu;
 orderMenuSheet.Cells[rowNum, 7] = menu.Rating;
 orderMenuSheet.Cells[rowNum, 8] = menu.Review;
 
 excelBook.Save();