将Excel范围转换为C#数组 [英] Convert Excel Range to C# Array

问题描述

我想使用以下代码将Excel Range转换为C#数组:

I would like to convert an Excel Range to a C# Array with this code:

System.Array MyRange = (System.Array)range.cells.value;

for (int k = 0; k <= MyRange.Length; k++)
{
    List<service_name> _ml = new List<service_name>();
    for (int j = 1; j < dataitems.Count; j++)
    {
        // enter code here
    }
}

然后像上面的循环一样遍历它.

And then iterate over it like in the above loop.

但是此代码不起作用，并引发此异常:

But this code does not work, and throws this Exception:

无法将类型为"System.String"的对象转换为类型为"System.Array"."

"Unable to cast object of type 'System.String' to type 'System.Array'."

推荐答案

基于提供的帮助，我的Microsoft

Based on the help provided my Microsoft here, this is how I read and write an array in Excel.

var xlApp=new Microsoft.Office.Interop.Excel.Application();
var wb=xlApp.Workbooks.Open(fn, ReadOnly: false);
xlApp.Visible=true;
var ws=wb.Worksheets[1] as Worksheet;
var r=ws.Range["A2"].Resize[100, 1];
var array=r.Value;
// array is object[1..100,1..1]
for(int i=1; i<=100; i++)
{
    var text=array[i, 1] as string;
    Debug.Print(text);
}
// to create an [1..100,1..1] array use
var array2=Array.CreateInstance(
    typeof(object), 
    new int[] {100, 1}, 
    new int[] {1, 1}) as object[,];

// fill array2
for(int i=1; i<=100; i++)
{
    array2[i, 1] = string.Format("Text{0}",i);
}
r.Value2=array2;

wb.Close(SaveChanges: true);
xlApp.Quit();

这篇关于将Excel范围转换为C#数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！