/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem28_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
GridControl grid = null;
switch (xtraTabControl1.SelectedTabPageIndex)
{
case 0:
grid = gridControl1;
break;
case 1:
grid = gridControl2;
break;
case 2:
grid = gridControl3;
break;
}
SaveFileDialog fileDialog = new SaveFileDialog();
fileDialog.Title = "导出Excel";
fileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
DialogResult dialogResult = fileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsxExportOptions options = new DevExpress.XtraPrinting.XlsxExportOptions();
options.TextExportMode = TextExportMode.Text;//设置导出模式为文本
grid.ExportToXlsx(fileDialog.FileName, options);
XtraMessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
SaveFileDialog fileDialog = new SaveFileDialog();
fileDialog.Title = "导出Excel";
fileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
DialogResult dialogResult = fileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsxExportOptions options = new DevExpress.XtraPrinting.XlsxExportOptions();
options.TextExportMode = TextExportMode.Text; //设置导出模式为文本
if (tabPane1.SelectedPageIndex == 0)
{
gridControl1.ExportToXlsx(fileDialog.FileName, options);
}
else if (tabPane1.SelectedPageIndex == 1)
{
gridControl2.ExportToXlsx(fileDialog.FileName, options);
}
XtraMessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem28_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//string s_json = string.Empty;
//s_json = JsonConvert.SerializeObject(dt_managefee);
//textEdit1.Text = s_json;
Frm_FinStat_select frm_1 = new Frm_FinStat_select();
if (frm_1.ShowDialog() == DialogResult.OK)
{
int i_index = Convert.ToInt32(frm_1.swapdata["index"]);
GridControl grid = null;
if (i_index == 0)
{
grid = gridControl1;
}
else if (i_index == 1)
{
grid = gridControl2;
}
else if (i_index == 2)
{
grid = gridControl3;
}
SaveFileDialog fileDialog = new SaveFileDialog();
fileDialog.Title = "导出Excel";
fileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
DialogResult dialogResult = fileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsxExportOptions options = new DevExpress.XtraPrinting.XlsxExportOptions();
options.TextExportMode = TextExportMode.Text; //设置导出模式为文本
grid.ExportToXlsx(fileDialog.FileName, options);
XtraMessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
frm_1.Dispose();
}
/// <summary>
/// DevExpress控件通用导出Excel,支持多个控件同时导出在同一个Sheet表或者分不同工作薄
/// eg:ExportToXlsx("test",true,"控件",gridControl1,gridControl2);
/// 将gridControl1和gridControl2的数据一同导出到同一个文件不同的工作薄
/// eg:ExportToXlsx("test",false,"",gridControl1,gridControl2);
/// 将gridControl1和gridControl2的数据一同导出到同一个文件同一个的工作薄
/// <param name="FileName">Excel路径</param>
/// <param name="isPageForEachLink">多个打印控件是否分多个工作薄显示</param>
/// <param name="sheetName">工作薄名称</param>
/// <param name="printables">控件集 eg:GridControl,PivotGridControl,TreeList,ChartControl...</param>
public static void ExportToExcel(string FileName, bool isPageForEachLink, string sheetName,
params DevExpress.XtraPrinting.IPrintable[] printables)
{
// SaveFileDialog saveFileDialog = new SaveFileDialog()
// {
// FileName = title,
// Title = "导出Excel",
// Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls"
// };
// DialogResult dialogResult = saveFileDialog.ShowDialog();
// if (dialogResult == DialogResult.Cancel)
// return;
// string FileName = saveFileDialog.FileName;
DevExpress.XtraPrintingLinks.CompositeLink link =
new DevExpress.XtraPrintingLinks.CompositeLink(new DevExpress.XtraPrinting.PrintingSystem());
foreach (var item in printables)
{
var plink = new DevExpress.XtraPrinting.PrintableComponentLink()
{
Component = item
};
link.Links.Add(plink);
}
if (isPageForEachLink) //15.1 的Xls不支持这个功能，15.2未知
{
link.CreatePageForEachLink();
}
//默认工作薄名称
if (string.IsNullOrEmpty(sheetName))
{
sheetName = "Sheet";
}
try
{
int count = 1;
//在重复名称后加（序号）
while (System.IO.File.Exists(FileName))
{
if (FileName.Contains(")."))
{
int start = FileName.LastIndexOf("(");
int end = FileName.LastIndexOf(").") - FileName.LastIndexOf("(") + 2;
FileName = FileName.Replace(FileName.Substring(start, end), string.Format("({0}).", count));
}
else
{
FileName = FileName.Replace(".", string.Format("({0}).", count));
}
count++;
}
if (FileName.LastIndexOf(".xlsx") >= FileName.Length - 5)
{
DevExpress.XtraPrinting.XlsxExportOptions options =
new DevExpress.XtraPrinting.XlsxExportOptions(TextExportMode.Value, true, false, true)
{
SheetName = sheetName
};
if (isPageForEachLink)
{
options.ExportMode = DevExpress.XtraPrinting.XlsxExportMode.SingleFilePageByPage;
}
link.ExportToXlsx(FileName, options);
}
else
{
DevExpress.XtraPrinting.XlsExportOptions options =
new DevExpress.XtraPrinting.XlsExportOptions(TextExportMode.Value, true, false, true)
{
SheetName = sheetName
};
if (isPageForEachLink) //15.Xls没有这个属性，15.2未知
{
options.ExportMode = DevExpress.XtraPrinting.XlsExportMode.SingleFilePageByPage;
}
link.ExportToXls(FileName, options);
}
if (DevExpress.XtraEditors.XtraMessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo,
MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(FileName); //打开指定路径下的文件
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message);
}
}
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();
}
}
}
}