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(); } } }