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