public static void ExcelExportWriteByRadGridView(RadTreeListView radGridView)
{
try
{
string extension = "xls";
SaveFileDialog dialog = new SaveFileDialog()
{
DefaultExt = extension,
Filter =
String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*",
extension,
"Excel"),
FilterIndex = 1
};
if (dialog.ShowDialog() == true)
{
using (Stream stream = dialog.OpenFile())
{
// if (File.Exists(stream)) File.Delete(stream);
radGridView.Export(stream,
new GridViewExportOptions()
{
Format = ExportFormat.Html,
ShowColumnHeaders = true,
ShowColumnFooters = true,
ShowGroupFooters = false,
Culture = CultureInfo.CurrentUICulture,
Encoding = Encoding.Unicode
});
}
}
}
catch (Exception ex)
{
Wlst.Cr.Core.UtilityFunction.WriteLog.WriteLogError("导出报表出错，异常为:" + ex);
}
}
