public void CopyDimensionsToLocation(IWorksheet targetWorksheet, int targetRow, bool copyContent) { AssertNotDisposed(); var targetRange = targetWorksheet.GetRows(targetRow, targetRow + EndRow - StartRow) as RowRange; if (targetRange == null) { throw new InvalidOperationException("Implementation of this method depends on another Office Interop wrapper."); } Excel.Range _range = _GetRange(); Excel.Range _targetRange = targetRange._GetRange(); lock (Synchronization.ClipboardSyncRoot) { _range.Copy(); _targetRange.PasteSpecial(Excel.XlPasteType.xlPasteColumnWidths); if (copyContent) { _targetRange.PasteSpecial(); } } Marshal.ReleaseComObject(_targetRange); Marshal.ReleaseComObject(_range); }
public void CopyToLocation(IWorksheet targetWorksheet, int targetRow) { AssertNotDisposed(); var targetRange = targetWorksheet.GetRows(targetRow, targetRow + EndRow - StartRow) as RowRange; if (targetRange == null) { throw new InvalidOperationException("Implementation of this method depends on another Office Interop wrapper."); } Excel.Range _range = _GetRange(); Excel.Range _targetRange = targetRange._GetRange(); _range.Copy(_targetRange); Marshal.ReleaseComObject(_targetRange); Marshal.ReleaseComObject(_range); }
public void InsertIntoLocation(IWorksheet targetWorksheet, int targetRow) { AssertNotDisposed(); var targetRange = targetWorksheet.GetRows(targetRow, targetRow + EndRow - StartRow) as RowRange; if (targetRange == null) { throw new InvalidOperationException("Implementation of this method depends on another Office Interop wrapper."); } Excel.Range _range = _GetRange(); Excel.Range _targetRange = targetRange._GetRange(); lock (Synchronization.ClipboardSyncRoot) { _targetRange.Insert(CopyOrigin: _range.Copy()); } Marshal.ReleaseComObject(_targetRange); Marshal.ReleaseComObject(_range); }