C# Exporting from database to excel returns a hexadecimal error

Viewed 86

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.

1 Answers
Related