/// <summary>
/// 设置单元格集合值
/// </summary>
/// <param name="arr">_ExcelCellValue数组</param>
public void SetCellSetValue(_ExcelCellValue[] arr)
{
for (int iarr = 0; iarr < arr.Length; iarr++)
{
_ExcelCellValue excelCellValue = arr[iarr];
setCellValue(excelCellValue.RowNum, excelCellValue.ColNum, excelCellValue.StrValue);
}
}
/// <summary>
/// 设置单元格集合值
/// </summary>
/// <param name="arr">_ExcelCellValue对象</param>
/// <param name="startRowNum">起始行</param>
/// <param name="startColNum">起始列</param>
/// <param name="endRowNum">结束行</param>
/// <param name="endColNum">结束列</param>
public void SetCellSetValue(_ExcelCellValue[] arr, int startRowNum, int startColNum, int endRowNum, int endColNum)
{
object[,] objData = new object[endRowNum, endColNum];
for (int iCell = 0; iCell < arr.Length; iCell++)
{
_ExcelCellValue excelCellValue = arr[iCell];
objData[excelCellValue.RowNum - 1, excelCellValue.ColNum - 1] = excelCellValue.StrValue;
}
Range range = GetRange(startRowNum, startColNum, endRowNum, endColNum);
range.Value = objData; //给Exccel中的Range整体赋值
}
