protected override bool WriteInternal(IAsyncProgress2 o, object[,] values, ExternalExcelRangeInfo rangeInfo) { var writeRange = this.GetRange(rangeInfo); writeRange.Value2 = values; return(true); }
private XLRange GetRange(ExternalExcelRangeInfo rangeInfo) { if (!rangeInfo.IsValidRange) { return(null); } CloseXMLExcelCell startCell = this.Cell(rangeInfo.StartRow, rangeInfo.StartColumn) as CloseXMLExcelCell; CloseXMLExcelCell endCell = this.Cell(rangeInfo.EndRow, rangeInfo.EndColumn) as CloseXMLExcelCell; return(_obj.Range(startCell.Cell, endCell.Cell)); }
public override void AutoResizeColumns(ExternalExcelRangeInfo rangeInfo) { ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Method"); try { if (rangeInfo.IsEmpty) { _obj.Columns.AutoFit(); } else { var range = this.GetRange(rangeInfo); range.Columns.AutoFit(); } } catch (Exception ex) { Log.Exception(PROC, ex); } }
private Range GetRange(ExternalExcelRangeInfo rangeInfo) { if (!rangeInfo.IsValidRange) { return(null); } MsOfficeExcelCell startCell = null; MsOfficeExcelCell endCell = null; try { startCell = this.CellInternal(rangeInfo.StartRow, rangeInfo.StartColumn) as MsOfficeExcelCell; endCell = this.CellInternal(rangeInfo.EndRow, rangeInfo.EndColumn) as MsOfficeExcelCell; return(_obj.Range[startCell.CellRange, endCell.CellRange]); } finally { startCell.Dispose(); endCell.Dispose(); } }
public override void AutoResizeColumns(ExternalExcelRangeInfo rangeInfo) { ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Method"); try { if (rangeInfo.IsEmpty) { _obj.Columns().AdjustToContents(); } else { var range = this.GetRange(rangeInfo); //range.AsRange().AddConditionalFormat } } catch (Exception ex) { Log.Exception(PROC, ex); } }
protected override object[,] ReadInternal(IAsyncProgress2 o, ExternalExcelRangeInfo rangeInfo) { var readRange = this.GetRange(rangeInfo); return readRange.Value2 as object[,]; }
private Range GetRange(ExternalExcelRangeInfo rangeInfo) { if (!rangeInfo.IsValidRange) return null; MsOfficeExcelCell startCell = null; MsOfficeExcelCell endCell = null; try { startCell = this.CellInternal(rangeInfo.StartRow, rangeInfo.StartColumn) as MsOfficeExcelCell; endCell = this.CellInternal(rangeInfo.EndRow, rangeInfo.EndColumn) as MsOfficeExcelCell; return _obj.Range[startCell.CellRange, endCell.CellRange]; } finally { startCell.Dispose(); endCell.Dispose(); } }
protected override bool WriteInternal(IAsyncProgress2 o, object[,] values, ExternalExcelRangeInfo rangeInfo) { var writeRange = this.GetRange(rangeInfo); writeRange.Value2 = values; return true; }
private XLRange GetRange(ExternalExcelRangeInfo rangeInfo) { if (!rangeInfo.IsValidRange) return null; CloseXMLExcelCell startCell = this.Cell(rangeInfo.StartRow, rangeInfo.StartColumn) as CloseXMLExcelCell; CloseXMLExcelCell endCell = this.Cell(rangeInfo.EndRow, rangeInfo.EndColumn) as CloseXMLExcelCell; return _obj.Range(startCell.Cell, endCell.Cell); }
protected override object[,] ReadInternal(IAsyncProgress2 o, ExternalExcelRangeInfo rangeInfo) { var readRange = this.GetRange(rangeInfo); return(readRange.Value2 as object[, ]); }
public override void AutoResizeColumns(ExternalExcelRangeInfo rangeInfo) { }
protected override bool WriteInternal(IAsyncProgress2 o, object[,] values, ExternalExcelRangeInfo rangeInfo) { return this._WriteInternal(o, values, rangeInfo); }
protected override object[,] ReadInternal(IAsyncProgress2 o, ExternalExcelRangeInfo rangeInfo) { return this._ReadInternal(o, rangeInfo); }
protected override bool WriteInternal(CoreLib.Win32.IAsyncProgress2 o, object[,] values, ExternalExcelRangeInfo rangeInfo) { Range writeRange = null; try { writeRange = this.GetRange(rangeInfo); writeRange.Value2 = values; return true; } finally { Extensions.DisposeComObject(writeRange); } }
protected override bool WriteInternal(CoreLib.Win32.IAsyncProgress2 o, object[,] values, ExternalExcelRangeInfo rangeInfo) { Range writeRange = null; try { writeRange = this.GetRange(rangeInfo); writeRange.Value2 = values; return(true); } finally { Extensions.DisposeComObject(writeRange); } }