public static void ExportToExcel(DevExpress.XtraGrid.Views.Base.BaseView bv, string fileName)
{
//this.gridControl1.ExportToXlsx(fileName);
try
{
//去除文件后缀名
string fileNameWithoutSuffix = fileName.Substring(0, fileName.LastIndexOf("."));
//后缀名
string aLastName = fileName.Substring(fileName.LastIndexOf(".") + 1, (fileName.Length - fileName.LastIndexOf(".") - 1)); //扩展名
if ((aLastName == "xls") & (!string.IsNullOrEmpty(fileName)))
{
bv.ExportToXls(fileName);
//ExportTo(bv, new DevExpress.XtraExport.ExportXlsProvider(fileName));
}
if ((aLastName == "xlsx") & !string.IsNullOrEmpty(fileName))
{
bv.ExportToXlsx(fileName);
// ExportTo(bv, new DevExpress.XtraExport.ExportXlsProvider(fileName));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Exports to ex.
/// </summary>
/// <param name="filename">The filename.</param>
/// <param name="ext">The ext.</param>
/// <param name="exportView">The export view.</param>
private static void ExportToEx(String filename, string ext, DevExpress.XtraGrid.Views.Base.BaseView exportView)
{
Application.DoEvents();
try
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
//DevExpress.XtraPrinting.IPrintingSystem ps = DevExpress.XtraPrinting.PrintHelper.GetCurrentPS();
if (ext == "rtf")
{
exportView.ExportToRtf(filename);
}
if (ext == "pdf")
{
exportView.ExportToPdf(filename);
}
if (ext == "mht")
{
exportView.ExportToMht(filename);
}
if (ext == "htm")
{
exportView.ExportToHtml(filename);
}
if (ext == "txt")
{
exportView.ExportToText(filename);
}
if (ext == "xls")
{
exportView.ExportToXls(filename);
}
if (ext == "xlsx")
{
exportView.ExportToXlsx(filename);
}
Cursor.Current = currentCursor;
}
catch (Exception ex)
{
throw ex;
}
}