C#

Exception de HRESULT : 0x800A03EC

public static void LoadViewData()
      {
          var target = (ExcelReference)XlCall.Excel(XlCall.xlfCaller);
          var sheetName = (string)XlCall.Excel(XlCall.xlSheetNm, target);
          var application = (Microsoft.Office.Interop.Excel.Application)ExcelDnaUtil.Application;
          var sheet = application.Sheets[Regex.Replace(sheetName, @"\[[^]]*\]", string.Empty)];
          object[,] result = LoadFromDbData();
          var startCell =sheet.Cells[target.RowFirst + 1, target.ColumnFirst];
          var endCell =sheet.Cells[target.RowFirst+ result.GetUpperBound(0) - result.GetLowerBound(0) + 1,
              target.ColumnFirst+ result.GetUpperBound(1) - result.GetLowerBound(1) + 1];
          var writeRange = sheet.Range[startCell, endCell];

          writeRange.Value2 = result;

      }

writeRange.Value2 = result;

Smallest window in a string containing all the characters of another string

I created an excel user defined function using excel dna Add-In, My function should return a two dimentional array but when i call it from a cell (=mainView(2018-04-10) ) it displays only the first column name (FundName), below is my code:

<pre> public static object[,] mainView(DateTime dt)
    {
        int rows = 0;
        int columns = 0;
        const int columnsArrayIndex = 0;
        DataTable dt = new DataTable();
        object[,] allRecords = new object[0,0];           
        try
        {
            SqlConnection cnx = new SqlConnection("data source=...;initial catalog=...;integrated security=True");
            cnx.Open();
            string query = @"select FundName,...";
            SqlCommand cmd = new SqlCommand(query, cnx);
            using (SqlDataAdapter a = new SqlDataAdapter(cmd))
            {
                a.Fill(dt);
                rows = dt.Rows.Count;
                columns = dt.Columns.Count;
                if (columns > 0 && rows > 0)
                {
                    allRecords = new object[rows + 1, columns];
                    for (int i = 0; i <= columns - 1; i++)
                    {
                        allRecords[columnsArrayIndex, i] = dt.Columns[i].ColumnName;
                    }
                    for (int j = 0; j <= rows - 1; j++)
                    {
                        var rowItem = dt.Rows[j].ItemArray;
                        for (int k = 0; k <= rowItem.Length - 1; k++)
                        {
                            allRecords[j + 1, k] = rowItem[k];
                        }
                    }
                }
            }
        }
        catch
        {

        }

        return allRecords; 
    }