Inläsningshändelse i GridDesktop

Laddningsevenemang för GridDesktop

Följande exempelkod illustrerar hur man använder typer av laddningsevenemang för GridDesktop vid import av en fil. Vänligen kontrollera provexcelfilen .

Filen är lösenordsskyddad, först försöker vi öppna den med ett fel lösenord, och slutligen i FailLoadFile-evenemanget använder vi ett korrekt lösenord för att öppna den.

resultatvy för laddningsevenemang

Exempelkod

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);
}
}
}
view raw LoadingEvent.cs hosted with ❤ by GitHub