public RowInfo(GridView view, int rowHandle, ViewExportType exportType)
{
this.RowHandle = rowHandle;
this.View = view;
this.ExportType = exportType;
}
public void Export(ViewExportType exportType)
{
SaveFileDialog dialog1 = new SaveFileDialog();
if (exportType == ViewExportType.Excel2003)
dialog1.Filter = "Excel Workbook (*.xls)|*.xls";
else if (exportType == ViewExportType.Excel2007)
dialog1.Filter = "Excel Workbook (*.xslx)|*.xlsx";
else if (exportType == ViewExportType.CSV)
dialog1.Filter = "CSV (Comma Delimited) (*.csv)|*.csv";
dialog1.Title = "Save As";
dialog1.CheckPathExists = true;
dialog1.CheckFileExists = false;
if (dialog1.ShowDialog() == DialogResult.OK) {
if (dialog1.FileName != "") {
if (dialog1.FilterIndex == 1) {
gridView1.OptionsPrint.AutoWidth = false;
gridView1.BestFitColumns();
FileStream fs = (FileStream)dialog1.OpenFile();
if (exportType == ViewExportType.CSV) {
DevExpress.XtraPrinting.CsvExportOptions opts = new DevExpress.XtraPrinting.CsvExportOptions();
gridView1.Export(DevExpress.XtraPrinting.ExportTarget.Csv, fs, opts);
}
else if (exportType == ViewExportType.Excel2007) {
DevExpress.XtraPrinting.XlsxExportOptions opts = new DevExpress.XtraPrinting.XlsxExportOptions();
opts.ExportMode = DevExpress.XtraPrinting.XlsxExportMode.SingleFile;
opts.SheetName = "Sheet1";
gridControl1.ExportToXlsx(fs, opts);
}
else if (exportType == ViewExportType.Excel2003) {
DevExpress.XtraPrinting.XlsExportOptions opts = new DevExpress.XtraPrinting.XlsExportOptions();
opts.ExportMode = DevExpress.XtraPrinting.XlsExportMode.SingleFile;
opts.SheetName = "Sheet1";
gridControl1.ExportToXls(fs, opts);
}
fs.Close();
}
}
}
}
