Exemple #1
0
        private void LoadWorkbookView()
        {
            //workbook = SpreadsheetGear.Factory.GetWorkbook(this.tmpXlsName);
            workbook  = SpreadsheetGear.Factory.GetWorkbook();
            worksheet = workbook.ActiveWorksheet;

            wbView = new SpreadsheetGear.Windows.Forms.WorkbookView(workbook);
            wbView.GetLock();
            try
            {
                SpreadsheetGear.IWorkbookWindowInfo windowInfo = wbView.ActiveWorkbookWindowInfo;
                windowInfo.DisplayWorkbookTabs = false;
                worksheet.WindowInfo.Zoom      = 100;
                wbView.Parent = this;;
                wbView.BringToFront();
                wbView.Dock                   = DockStyle.Fill;
                wbView.CellBeginEdit         += new CellBeginEditEventHandler(wbView_CellBeginEdit);
                wbView.RangeChanged          += new RangeChangedEventHandler(wbView_RangeChanged);
                wbView.RangeSelectionChanged += wbView_RangeSelectionChanged;
            }
            finally
            {
                wbView.ReleaseLock();
            }
        }
        private void LoadWorkbookView()
        {
            //workbook = SpreadsheetGear.Factory.GetWorkbook(this.tmpXlsName);
            // workbook = SpreadsheetGear.Factory.GetWorkbook();
            worksheet = workbook.ActiveWorksheet;

            wbView = new SpreadsheetGear.Windows.Forms.WorkbookView(workbook);
            wbView.GetLock();
            try
            {
                //SpreadsheetGear.IWorkbookWindowInfo windowInfo = wbView.ActiveWorkbookWindowInfo;
                //windowInfo.DisplayWorkbookTabs = false;
                worksheet.WindowInfo.Zoom = 100;
                wbView.Parent             = this;;
                wbView.BringToFront();
                wbView.Dock = DockStyle.Fill;
            }
            finally
            {
                wbView.ReleaseLock();
            }
        }