在C＃中创建excel文件 [英] Creating excel file in C#

问题描述

作为一个演示，我在excel文件中写了一行，它工作，但现在我试图插入DataTable的所有行，但它提供以下错误：

HRESULT：0x800A03EC

这是代码：

  for（int i = 0; i< table.Rows.Count; i ++ ）
 {
 xlWorkSheet.Cells [i，1] = table.Rows [i] [Ref]。ToString（）; 
 xlWorkSheet.Cells [i，2] = table.Rows [i] [Name]。ToString（）; 
} 
  

请告诉我如何解决？

解决方案

而不是DataTable，将所有的值都放在一个对象[，]

然后，您可以一键分配：

  using（var targetRangeHeader = _excelApp使用（var targetRange = targetRangeFirstDataCell.Resource.Resize [MyObjectArrayValues]）的值为.Length，1] .WithComCleanup（））
 {
 targetRange.Resource.Value2 = MyObjectArrayValues; 
  

使用 http://jake.ginnivan.net/vsto-com-interop

Its my first experience with excel file using C#.

As a demo, I wrote a single line in excel file and it worked but now I am trying to insert all the rows of DataTable but it gives the following error:

"HRESULT: 0x800A03EC"

Here is the code:

for (int i = 0; i < table.Rows.Count; i++)
{
    xlWorkSheet.Cells[i, 1] = table.Rows[i]["Ref"].ToString();
    xlWorkSheet.Cells[i, 2] = table.Rows[i]["Name"].ToString();
}

Please tell me how can I fix it?

解决方案

Instead of a DataTable, put all the values into a object[,]

Then you can assign them in one swoop:

using (var targetRangeHeader = _excelApp.Range[TargetRangeTopAddress].WithComCleanup())
 using (var targetRangeFirstDataCell = targetRangeHeader.Resource.Offset[1, 0].WithComCleanup())
  using (var targetRange = targetRangeFirstDataCell.Resource.Resize[MyObjectArrayValues.Length, 1].WithComCleanup())
{
 targetRange.Resource.Value2 = MyObjectArrayValues;

Using http://jake.ginnivan.net/vsto-com-interop

这篇关于在C＃中创建excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！