Ladevorgang in GridDesktop

Ladevorgang für GridDesktop

Der folgende Beispielcode veranschaulicht, wie man verschiedene Ladevorgänge für GridDesktop verwendet, während man eine Datei importiert. Bitte überprüfen Sie die Beispiel-Excel-Datei .

Die Datei ist passwortgeschützt. Zuerst versuchen wir, sie mit einem falschen Passwort zu öffnen, und schließlich verwenden wir im FailLoadFile-Ereignis ein korrektes Passwort, um sie zu öffnen.

Beispielcode

 public partial class loadingevent : basicForm
    {  
  public loadingevent()
        {
            InitializeComponent();
            gridDesktop1.Width = 800;
            gridDesktop1.Height = 800;
            gridDesktop1.ShowImportMessage = false;
            this.gridDesktop1.FailLoadFile += GridDesktop1_FailLoadFile;
            this.gridDesktop1.FinishLoadFile += GridDesktop1_FinishLoadFile;
            this.gridDesktop1.FinishCalculate += GridDesktop1_FinishCalculate;
            this.gridDesktop1.BeforeLoadFile += GridDesktop1_BeforeLoadFile;
            this.gridDesktop1.BeforeCalculate += GridDesktop1_BeforeCalculate;
            gridDesktop1.ImportExcelFile(LoadingHelper.getTestFile("loading-event.xlsx"), "wrongpassword", null, true, true);
            this.Text = " load event test";
        }

        private void GridDesktop1_BeforeCalculate(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args)
        {
            string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue;
            this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> before calculate, \n");
        }

        private void GridDesktop1_BeforeLoadFile(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args)
        {
            string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue;
            this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> before loadfile, \n");
        }

        private void GridDesktop1_FinishCalculate(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args)
        {
            string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue;
            this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> finish calculate, \n");
        }

        private void GridDesktop1_FinishLoadFile(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args)
        {
            string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue;
            this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> finish loadfile, \n");
        }

        private void GridDesktop1_FailLoadFile(object sender, String s)
        {//try correct password
            MessageBox.Show("fail load the file "+s+",now we try another password");
            gridDesktop1.ImportExcelFile(LoadingHelper.getTestFile("loading-event.xlsx"), "pwd456", null, false, true);
        }
	}
}