Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }
Exemple #3
0
        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);
        }
Exemple #4
0
        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);
        }
Exemple #5
0
        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);
        }
Exemple #6
0
        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);
        }