I am reading a List from my database and I only need to export 1 column of this data into an excel sheet. However, the try catch method is catching the following Hex error "0x800AC472".
try
{
var path = @"C:\Users\Desktop\Data.xlsx";
var listOfUsers = _context.Users.ToList();
int row = 2;
Microsoft.Office.Interop.Excel.Application excel;
Microsoft.Office.Interop.Excel.Workbook excelworkBook;
Microsoft.Office.Interop.Excel.Worksheet excelSheet;
Microsoft.Office.Interop.Excel.Range excelCellrange;
excel = new Microsoft.Office.Interop.Excel.Application();
excel.Visible = false;
excel.Interactive = false;
excel.DisplayAlerts = false;
excelworkBook = excel.Workbooks.Add(Type.Missing);
excelSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelworkBook.ActiveSheet;
excelSheet.Name = "Test work sheet";
excelCellrange = excelSheet.Range[excelSheet.Cells[1, 1], excelSheet.Cells[listOfUsers.Count, 1]];
excelCellrange.EntireColumn.AutoFit();
excelSheet.Cells[1, 1] = "Phone Number";
foreach (var user in listOfUsers)
{
excelSheet.Cells[row, 1] = user.PhoneNumber;
row++;
}
excelSheet.SaveAs(path);
return Ok();
}
catch (Exception ex)
{
return BadRequest(ex.Message); ;
}
Update:
Turns out the issue was in MS Office license. It was expired. Once I fixed the license everything worked out.