导出excel时因字段过长导致的hresult:0x800a03ec错误解决办法

          <pre name="code" class="csharp">               range = xlSheet.get_Range(app.Cells[1, 1], app.Cells[RowCount + 2, colCount]);
               
               objData[RowCount + 1, 0] = "合计：" + gridView.Rows.Count.ToString();

                range.Value2 = objData;//我是这句出的错

                app.Visible = true;

            

                               解决办法：

                             把

               range.Value2 = objData;

</pre>                              改成<pre name="code" class="csharp"> <pre name="code" class="csharp">                 for (int r = 1; r <= RowCount + 2; r++)
                {
                    for (int c = 1; c <= colCount; c++)
                    {

                        xlSheet.get_Range(app.Cells[r, c], app.Cells[r, c]).Value2 = objData[r - 1, c - 1];
                    }
                }