Esempio n. 1
0
        protected override bool WriteInternal(IAsyncProgress2 o, object[,] values, ExternalExcelRangeInfo rangeInfo)
        {
            var writeRange = this.GetRange(rangeInfo);

            writeRange.Value2 = values;
            return(true);
        }
Esempio n. 2
0
        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();
            }
        }
Esempio n. 5
0
        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();
            }
            
        }
        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 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);
            }
        }
        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);
            }
        }
        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);
            }
        }