private void buttonExport_Click(object sender, EventArgs e) { try { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Files(*.XLS)|*.XLS"; saveFileDialog.AddExtension = true; saveFileDialog.DefaultExt = ".XLS"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { if (saveFileDialog.FileName.ToString() != "") { // Code to write the stream goes here. GroupingGridExcelConverterControl converterControl = new GroupingGridExcelConverterControl(); converterControl.GroupingGridToExcel(this.gridMarketDataLog, saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.Default); } } } catch (Exception ex) { log.Error("Error in buttonExport_Click:{0}", ex); } }
private void btnExcel_Click(object sender, EventArgs e) { GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl(); converter.GroupingGridToExcel(gc1, "c:\\wipviewer\\grid.xls", Syncfusion.GridExcelConverter.ConverterOptions.Default); // converter.GroupingGridToExcel(gc1, "Grid.xls", Syncfusion.GridExcelConverter.ConverterOptions.Visible); // groupinggriexcel }
//used to handle file private void button2_Click(object sender, System.EventArgs e) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Files(*.XLS)|*.XLS"; saveFileDialog.AddExtension = true; saveFileDialog.DefaultExt = ".XLS"; if (saveFileDialog.ShowDialog() == DialogResult.OK && saveFileDialog.CheckPathExists) { GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl(); //Properties //ExportStyle if (checkBox1.Checked) { //by default ExportStyle is true converter.ExportBorders = this.checkBox4.Checked; } else { converter.ExportStyle = false; } if (colorPickerButton1.SelectedColor != Color.Empty) { converter.HeaderBackColor = this.colorPickerButton1.SelectedColor; } if (colorPickerButton2.SelectedColor != Color.Empty) { converter.CaptionBackColor = this.colorPickerButton2.SelectedColor; } //by default ExportPreviewRows is false converter.ExportPreviewRows = this.checkBox2.Checked; converter.ExportGroupPlusMinus = this.checkBox5.Checked; converter.ExportRecordPlusMinus = this.checkBox6.Checked; //Hook QueryExportPreviewRowInfo event for non display elements. if (this.checkBox3.Checked) { //must handle the QueryExportPreviewRowInfo event when the ConverterOptions is //not Visible converter.QueryExportPreviewRowInfo += new GroupingGridExcelConverterControl.GroupingGridExportPreviewRowQueryInfoEventHandler(converter_QueryExportPreviewRowInfo); } else { converter.QueryExportPreviewRowInfo -= new GroupingGridExcelConverterControl.GroupingGridExportPreviewRowQueryInfoEventHandler(converter_QueryExportPreviewRowInfo); } ConverterOptions options = (ConverterOptions)this.comboBox1.SelectedItem; converter.GroupingGridToExcel(this.gridGroupingControl1, saveFileDialog.FileName, options); converter.Dispose(); if (MessageBox.Show("Do you wish to open the xls file now?", "Export to Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { System.Diagnostics.Process proc = new System.Diagnostics.Process(); proc.StartInfo.FileName = saveFileDialog.FileName; proc.Start(); } } }
private void buttonRawValuationsExtract_Click(object sender, EventArgs e) { try { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Files(*.XLS)|*.XLS"; saveFileDialog.AddExtension = true; saveFileDialog.DefaultExt = ".XLS"; saveFileDialog.FileName = "MarkIt Raw Valuation Extract as of " + dtpMarketDate.Value.ToString("yyyy-MM-dd"); DataSet dsRawPrices = MarketDataLogReportData.GetMarkItRawData( Convert.ToDateTime(dtpMarketDate.Value.ToShortDateString()), null); GridGroupingControl gridMarketRawValTemp=new GridGroupingControl(); gridMarketRawValTemp.TableDescriptor.AllowNew = false; gridMarketRawValTemp.DataSource = dsRawPrices.Tables[0]; if (saveFileDialog.ShowDialog() == DialogResult.OK) { if (saveFileDialog.FileName.ToString() != "") { GroupingGridExcelConverterControl converterControl = new GroupingGridExcelConverterControl(); converterControl.GroupingGridToExcel(gridMarketRawValTemp, saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.Default); MessageBox.Show("Successfully extracted MarkIt valuations!"); } } } catch (Exception ex) { log.Error("Error in buttonRawValuationsExtract_Click:{0}", ex); MessageBox.Show("Error happened when processing Valuations Extract!\n"+ex,"",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void btnExportVisible_Click(object sender, EventArgs e) { GroupingGridExcelConverterControl convert_visible = new GroupingGridExcelConverterControl(); convert_visible.GroupingGridToExcel(gc1, "c:\\wipviewer\\gridVisible.xls", Syncfusion.GridExcelConverter.ConverterOptions.Visible); }