Syncfusion SfDataGrid 导出Excel

var options = new ExcelExportingOptions
            {
                ExcelVersion = ExcelVersion.Excel2013,
            };
//不需要导出的字段 options.ExcludeColumns.Add(
"InspectionRecordId"); options.ExcludeColumns.Add("PartName"); options.ExportUnBoundRows = false; var excelEngine = dataGrid.ExportToExcel(dataGrid.View, options); //.ExportToExcel(dataGrid.View, options); var workBook = excelEngine.Excel.Workbooks[0]; Microsoft.Win32.SaveFileDialog saveFileDialog = new Microsoft.Win32.SaveFileDialog(); saveFileDialog.Filter = "Excel Office 2013|*.xlsx"; //设置默认文件名(可以不设置) saveFileDialog.FileName = $"巡检记录({DateTime.Now:yy-MM-dd})"; saveFileDialog.DefaultExt = "xlsx"; saveFileDialog.AddExtension = true; //保存对话框是否记忆上次打开的目录 bool? result = saveFileDialog.ShowDialog(); //点了保存按钮进入 if (result == true) { workBook.SaveAs(saveFileDialog.FileName); }

 

posted @ 2019-01-16 13:36  在 水 一 方  阅读(701)  评论(0编辑  收藏  举报