void openBackStageButton_Click(object sender, EventArgs e)
{
Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Files(*.xlsx)|*.xlsx";
openFileDialog.DefaultExt = ".xlsx";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
gecc.ExcelToGrid(openFileDialog.FileName, this.workBook._grid.Model);
}
this.workBook._grid.Refresh();
this.backStageView1.BackStage.Visible = false;
}
void saveBtn_Click(object sender, EventArgs e)
{
Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Files(*.xlsx)|*.xlsx|Files(*.xls)|*.xls";
saveFileDialog.DefaultExt = ".xlsx";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
gecc.GridToExcel(this.workBook._grid.Model, saveFileDialog.FileName);
if (MessageBox.Show("Do you wish to open the xls file now?", "Export to Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Process proc = new Process();
proc.StartInfo.FileName = saveFileDialog.FileName;
proc.Start();
}
}
}
