我正在尝试将二维数组写入工作表,但出现以下错误:
指定的数组不是预期的类型。
这是我的代码:
string[][] allEvars = new string[evars.Count][];
for (var i = 0; i < evars.Count; i++) {
var evarsList = new List<string>();
evarsList.Add(evars[i].id.Value);
evarsList.Add(evars[i].name.Value);
if (evars[i].enabled != null)
evarsList.Add(evars[i].enabled.Value.ToString());
else
evarsList.Add("");
if (evars[i].description != null)
evarsList.Add(evars[i].description.Value);
else
evarsList.Add("");
string[] evarsArray = evarsList.ToArray();
//var range = (Excel.Range)wsEvars.Range[wsEvars.Cells[i + 5, 2], wsEvars.Cells[i + 5, evarsArray.Length]];
//range.Value = evarsArray;
allEvars[i] = evarsList.ToArray();
}
var range = (Excel.Range)wsEvars.Range[wsEvars.Cells[5, 2], wsEvars.Cells[allEvars.Length, 3]];
range.Value2 = allEvars; // This is the line with the exception
我的代码中的 2 行注释行将数组一一添加到工作表中,我试图一次添加它们以节省一些时间。
您可以将数组数组转换为二维数组。使用此答案中的Jon Skeet 方法
static T[,] CreateRectangularArray<T>(T[][] arrays)
{
// TODO: Validation and special-casing for arrays.Count == 0
int minorLength = arrays[0].Length;
T[,] ret = new T[arrays.Length, minorLength];
for (int i = 0; i < arrays.Length; i++)
{
var array = arrays[i];
if (array.Length != minorLength)
{
throw new ArgumentException
("All arrays must be the same length");
}
for (int j = 0; j < minorLength; j++)
{
ret[i, j] = array[j];
}
}
return ret;
}
在您的代码中:
string[][] allEvars = new string[evars.Count][];
for (var i = 0; i < evars.Count; i++) {
var evarsList = new List<string>();
evarsList.Add(evars[i].id.Value);
evarsList.Add(evars[i].name.Value);
if (evars[i].enabled != null)
evarsList.Add(evars[i].enabled.Value.ToString());
else
evarsList.Add("");
if (evars[i].description != null)
evarsList.Add(evars[i].description.Value);
else
evarsList.Add("");
string[] evarsArray = evarsList.ToArray();
//var range = (Excel.Range)wsEvars.Range[wsEvars.Cells[i + 5, 2], wsEvars.Cells[i + 5, evarsArray.Length]];
//range.Value = evarsArray;
allEvars[i] = evarsList.ToArray();
}
var range = (Excel.Range)wsEvars.Range[wsEvars.Cells[5, 2], wsEvars.Cells[allEvars.Length, 3]];
string[,] newallEvars = CreateRectangularArray<string>(allEvars); //added row
range.Value2 = newallEvars; // changed row
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句