/// <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整体赋值 }