C#

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; 
    }

<script type="text/javascript">
    function GetPrice(_this) {

        var x = document.getElementById("productID"), selectedValue = x.value;
        alert("_this" + _this.SelectedValue);
        var pid = selectedValue;
        alert(pid);
        var url = '@Url.Action("GetPrice","Sales")';
        alert(url);
              $.ajax({
                type:"POST",
                url: 'Sales/GetPrice',
                contentType: "application/json; charset=utf-8",
                data:  {ProductId: pid },
                cache:false,
                dataType: json,
                async: true,
                processData:false,
                success: function (data)
                {
                    alert("yay1");
                },
                failure: function (response) {
                    alert("Fail");
                }

        });

    };
</script>

@using (Html.BeginForm())
{
    @Html.ValidationSummary(true)
   <fieldset>
  <div class="editor-field">
<div class="editor-label">
            @Html.LabelFor(model => model.ProductId)
        </div>
  @Html.DropDownListFor(model => model.ProductId, new SelectList(ViewBag.ProductList, "ProductId", "ProductName" ), "Select Product", new { id = "productID", onchange="GetPrice(this);"})                       
            @Html.ValidationMessageFor(model => model.ProductId, "", new { @class = "text-danger" })
            <span class="glyphicon glyphicon-asterisk"></span>
        </div>


   <div class="editor-label">
            @Html.LabelFor(model => model.Rate)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.Rate, new { id = "idRate"})
            @Html.ValidationMessageFor(model => model.Rate)
        </div>\
   </fieldset>
}

[HttpPost]
      public JsonResult GetPrice(int ProductId)
      {
          return Json("");
      }

<pre>Mat eulerAnglesToRotationMatrix(Vec3f &theta)
{
    // Calculate rotation about x axis
    Mat R_x = (Mat_<double>(3,3) <<
               1,       0,              0,
               0,       cos(theta[0]),   -sin(theta[0]),
               0,       sin(theta[0]),   cos(theta[0])
               );
    
    // Calculate rotation about y axis
    Mat R_y = (Mat_<double>(3,3) <<
               cos(theta[1]),    0,      sin(theta[1]),
               0,               1,      0,
               -sin(theta[1]),   0,      cos(theta[1])
               );
    
    // Calculate rotation about z axis
    Mat R_z = (Mat_<double>(3,3) <<
               cos(theta[2]),    -sin(theta[2]),      0,
               sin(theta[2]),    cos(theta[2]),       0,
               0,               0,                  1);
    
    
    // Combined rotation matrix
    Mat R = R_z * R_y * R_x;
    
    return R;

}