跳转到Syncfusion电子表格控件中的某个单元格

Question

我正在使用Winforms C#，我想添加Syncfusion电子表格控件。我想问一下，是否可以从另一个窗体跳到控件窗体中的某个单元格？

感谢

Answer 1

您可以通过使用表单加载的事件和电子表格来实现您的需求。WorkbookLoaded事件如下所示，

Form1.CS

button1.Click += Button1_Click;
private void Button1_Click(object sender, EventArgs e)
{
Form2 frm = new Form2();
frm.Show();
this.Hide();
}

Form2.CS

this.Load += Form2_Load;
private void Form2_Load(object sender, EventArgs e)
{
try
{
var fileStream = new FileStream(@"....DataFiltering.xlsx", FileMode.Open);
spreadsheet.Open(fileStream);          
}
catch
{

}
spreadsheet.WorkbookLoaded += Spreadsheet_WorkbookLoaded;
}

private void Spreadsheet_WorkbookLoaded(object sender, Syncfusion.Windows.Forms.Spreadsheet.Helpers.WorkbookLoadedEventArgs args)
{
//Moves current cell to the mentioned row and column index of the cell,
spreadsheet.ActiveGrid.CurrentCell.MoveCurrentCell(5, 5);

//For moving the current cell to a different sheet,
spreadsheet.SetActiveSheet("Sheet1");
spreadsheet.ActiveGrid.CurrentCell.MoveCurrentCell(6, 5);
}