private void ExportRegister_Execute(object sender, SimpleActionExecuteEventArgs e)
{
GridListEditor listEditor = ((DevExpress.ExpressApp.ListView)View).Editor as GridListEditor;
Type TypeObject = View.ObjectTypeInfo.Type;
string strObj = "";
foreach (BaseObject obj in View.SelectedObjects)
{
strObj = (strObj == "" ? string.Format("Oid='{0}'", obj.Oid) : string.Format("{0} or Oid='{1}'", strObj, obj.Oid));
}
if (strObj != "")
{
if (listEditor != null)
{
GridView gv = (listEditor.Grid as GridControl).MainView as GridView;
using (SaveFileDialog sfd = new SaveFileDialog())
{
sfd.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
if (sfd.ShowDialog() == DialogResult.OK)
{
XlsExportOptions xlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions();
xlsExportOptions.SheetName = View.Caption.Replace(" ", "");
xlsExportOptions.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
xlsExportOptions.ShowGridLines = true;
gv.GridControl.DataSource = new XPCollection(View.ObjectSpace.Session, TypeObject,
CriteriaOperator.Parse(strObj));
gv.ExportToXls(sfd.FileName, xlsExportOptions);
}
}
}
}
}
/// <summary>
/// 导出Excel 2013-3-6 by tj
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_export_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
options.SheetName = "病历信息";
options.ShowGridLines = true;
string caption = gridControlMedicalRecord.MainView.ViewCaption;
gridControlMedicalRecord.MainView.ViewCaption = options.SheetName;
gridControlMedicalRecord.ExportToXls(saveFileDialog.FileName, options);
MessageBox.Show("导出成功");
gridControlMedicalRecord.MainView.ViewCaption = caption;
}
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
private void ExportRegister_Execute(object sender, SimpleActionExecuteEventArgs e)
{
GridListEditor listEditor = ((DevExpress.ExpressApp.ListView)View).Editor as GridListEditor;
Type TypeObject = View.ObjectTypeInfo.Type;
string strObj="";
foreach (BaseObject obj in View.SelectedObjects)
{
strObj = (strObj =="" ? string.Format("Oid='{0}'", obj.Oid) : string.Format("{0} or Oid='{1}'", strObj, obj.Oid));
}
if (strObj != "")
{
if (listEditor != null)
{
GridView gv = (listEditor.Grid as GridControl).MainView as GridView;
using (SaveFileDialog sfd = new SaveFileDialog())
{
sfd.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
if (sfd.ShowDialog() == DialogResult.OK)
{
XlsExportOptions xlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions();
xlsExportOptions.SheetName = View.Caption.Replace(" ", "");
xlsExportOptions.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
xlsExportOptions.ShowGridLines = true;
gv.GridControl.DataSource = new XPCollection(View.ObjectSpace.Session, TypeObject,
CriteriaOperator.Parse(strObj));
gv.ExportToXls(sfd.FileName, xlsExportOptions);
}
}
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
if (!HasFunction("User/Set/UserExport"))
{
MessageDxUtil.ShowError(Const.NoAuthMsg);
return;
}
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
try
{
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions(DevExpress.XtraPrinting.TextExportMode.Value);
options.TextExportMode = TextExportMode.Text;//设置导出模式为文本
winGridViewPager1.gridView1.OptionsPrint.AutoWidth = false;
winGridViewPager1.gridView1.ExportToXls(file, options);
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmUser));
MessageDxUtil.ShowError(ex.Message);
}
}
}
//EXCEL'E AKTARMA
private void btnExcel_Click(object sender, EventArgs e)
{
saveFileDialog1.FileName = isim + " alıcısına ait fatura (" + DateTime.Now.Day + "." + DateTime.Now.Month + "." + DateTime.Now.Year + ")";
saveFileDialog1.Filter = "XLS Dosyaları (*.xls)|*.xls";
saveFileDialog1.InitialDirectory = "c:";
//eğer saveFileDiaolog1 açıldığında Evet’e tıklanırsa
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptions _Options = new DevExpress.XtraPrinting.XlsExportOptions();
_Options.SheetName = isim + " alıcısına ait fatura (" + DateTime.Now.Day + "." + DateTime.Now.Month + "." + DateTime.Now.Year + ")";
gridFaturaDetay.ExportToXls(saveFileDialog1.FileName, _Options);
if (MessageBox.Show("Aktarılan dosyayı şimdi görmek ister misiniz?", "Excel dosyası", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//Kaydedilen Excel Dosyasını açar.
System.Diagnostics.Process.Start(saveFileDialog1.FileName);
}
}
}
/// <summary>
/// 数据导出到Excel
/// </summary>
/// <param name="paramGridView">要操作的GridView控件</param>
/// <param name="paramFilePath">导出文件路径</param>
private static void ExportToExcel(DevExpress.XtraGrid.Views.Grid.GridView paramGridView, string paramFilePath)
{
DevExpress.XtraPrinting.XlsExportOptions myXlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions();
myXlsExportOptions.ExportHyperlinks = true;
myXlsExportOptions.SheetName = "餐饮管理系统";
myXlsExportOptions.ShowGridLines = true;
myXlsExportOptions.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
paramGridView.ExportToXls(paramFilePath, myXlsExportOptions);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
SaveFileDialog fileDialog = new SaveFileDialog();
fileDialog.Title = "导出Excel";
fileDialog.Filter = "Excel文件t(*.xls)|*.xls";
DialogResult dialogResult = fileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
mainGrid.ExportToXls(fileDialog.FileName);
DevExpress.XtraEditors.XtraMessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void ExportToExcel(BaseView exportView, string sName)
{
//string fileName = this.ShowSaveFileDialog(sName);
string fileName = "c:/" + sName + ".xls";
if (!string.IsNullOrEmpty(fileName))
{
DevExpress.XtraPrinting.XlsExportOptions xlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions();
//xlsExportOptions.TextExportMode = TextExportMode.Text;
xlsExportOptions.TextExportMode = TextExportMode.Value;
System.Windows.Forms.Cursor currentCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
exportView.ExportToXls(fileName, xlsExportOptions);
System.Windows.Forms.Cursor.Current = currentCursor;
}
}
private void ExportDetail()
{
SaveFileDialog fileDialog = new SaveFileDialog();
fileDialog.Title = "导出Excel";
fileDialog.Filter = "Excel (*.xls)|*.xls";
DialogResult dialogResult = fileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
detailGrid.ExportToXls(fileDialog.FileName);
if (System.IO.File.Exists(fileDialog.FileName))
{
System.Diagnostics.Process.Start(fileDialog.FileName); //保存v
}
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
try
{
Log.Info(this.GetType() + "->" + ApplicationCommon.GetMethodName() + "---START");
var saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "电子表格文件 (*.xls)|*.xls";
saveFileDialog.FileName = "导出文件.xls";
var dialogResult = saveFileDialog.ShowDialog();
if (dialogResult == DialogResult.Cancel)
{
return;
}
string fileName = saveFileDialog.FileName;
if (!string.IsNullOrEmpty(fileName))
{
try
{
DevExpress.XtraPrinting.XlsExportOptions __options = new DevExpress.XtraPrinting.XlsExportOptions();
__options.TextExportMode = TextExportMode.Value;
__options.ExportMode = DevExpress.XtraPrinting.XlsExportMode.SingleFile;
__options.ShowGridLines = true;
gvList.OptionsPrint.UsePrintStyles = true;
gcList.ExportToXls(fileName, __options);
}
catch (Exception)
{
MessageBox.Show("文件正在使用！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
Log.Error(this.GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex);
throw ex;
}
}
public void Excel()
{
try
{
nPrint = true;
SaveFix();
SaveFileDialog fileDialog = new SaveFileDialog();
fileDialog.Title = "导出Excel";
fileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
fileDialog.FileName = this.Text;
DialogResult dialogResult = fileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
this.gridControl1.ExportToXlsx(fileDialog.FileName);
DevExpress.XtraEditors.XtraMessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
nPrint = false;;
}
finally
{
ClearFix();
}
}
private void ExportRegister_Execute(object sender, SimpleActionExecuteEventArgs e)
{
ASPxGridListEditor listEditor = ((ListView)View).Editor as ASPxGridListEditor;
Type TypeObject = View.ObjectTypeInfo.Type;
string strObj="";
int countobj = 0;
if (View.ObjectTypeInfo.Type == typeof(ReportData))
{
foreach (ReportData obj in View.SelectedObjects)
{
strObj = (strObj == "" ? string.Format("ReportName='{0}'", obj.ReportName) : string.Format("{0} or ReportName='{1}'", strObj, obj.ReportName));
countobj++;
}
}
else
{
foreach (BaseObject obj in View.SelectedObjects)
{
strObj = (strObj == "" ? string.Format("Oid='{0}'", obj.Oid) : string.Format("{0} or Oid='{1}'", strObj, obj.Oid));
countobj++;
}
}
if (countobj > 2000)
throw new UserFriendlyException(string.Format("Không thể export dữ liệu nhiều hơn 2000 dòng. Bạn đã chọn {0} dòng!!", countobj));
if (strObj != "")
{
if (listEditor != null)
{
ASPxGridView gv = listEditor.Grid;
using (ASPxGridViewExporter gridViewExporter = new ASPxGridViewExporter())
{
using (MemoryStream stream = new MemoryStream())
{
//gridViewExporter.WriteXlsToResponse();
gridViewExporter.GridViewID = gv.ID;
gridViewExporter.Page = gv.Page;
gv.Parent.Controls.Add(gridViewExporter);
gv.BeginUpdate();
gv.DataSource = new XPCollection(View.ObjectSpace.Session, TypeObject,
CriteriaOperator.Parse(strObj));
gv.DataBind();
gv.EndUpdate();
gridViewExporter.DataBind();
XlsExportOptions xlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions();
xlsExportOptions.SheetName = View.Caption.Replace(" ", "");
xlsExportOptions.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
xlsExportOptions.ShowGridLines = true;
gridViewExporter.WriteXls(stream, xlsExportOptions);
byte[] buffer = stream.GetBuffer();
string contentType = "application/ms-excel";
string contentDisposition = "attachment; filename=Export_Result.xls";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = false;
HttpContext.Current.Response.AppendHeader("Content-Type", contentType);
HttpContext.Current.Response.AppendHeader("Content-Transfer-Encoding", "binary");
HttpContext.Current.Response.AppendHeader("Content-Disposition", contentDisposition);
HttpContext.Current.Response.BinaryWrite(buffer);
HttpContext.Current.Response.End();
}
}
}
}
}
/// <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();
}
}
}
}
/// <summary>
/// 匯出Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override void ToExcelButton_Click(object sender, EventArgs e)
{
base.ToExcelButton_Click(sender, e);
if (tabControl1.SelectedIndex == 0)
{
if (gridView1.RowCount <= 0)
{
MessageBox.Show("無內容，請重新查詢", "取消儲存");
return;
}
}
else
{
if (gridView3.RowCount <= 0)
{
MessageBox.Show("無內容，請重新查詢", "取消儲存");
return;
}
}
SaveFileDialog OFD = new SaveFileDialog();
OFD.InitialDirectory = "D:\\";
OFD.RestoreDirectory = true;
OFD.Title = "儲存檔案";
OFD.DefaultExt = "xls";
OFD.Filter = "Microsoft Office Excel 活頁簿 (*.xls)|*.xls";
GridControl[] grids;
if (tabControl1.SelectedIndex == 0)
{
//合併兩個gridcontrol到同一個報表
grids = new GridControl[] { gridControl1 };
}
else
{
grids = new GridControl[] { gridControl3 };
}
OFD.FileName = FileName_OutPutExcel;
DialogResult chooseOutPut = OFD.ShowDialog();
if (chooseOutPut == DialogResult.Cancel)
{
return;
}
//gridview排版
gridView1.OptionsView.ColumnAutoWidth = false;
gridView1.OptionsPrint.AutoWidth = false;
gridView1.BestFitColumns();
gridView2.OptionsView.ColumnAutoWidth = false;
gridView2.OptionsPrint.AutoWidth = false;
gridView2.BestFitColumns();
gridView3.OptionsView.ColumnAutoWidth = false;
gridView3.OptionsPrint.AutoWidth = false;
gridView3.BestFitColumns();
gridView1.AppearancePrint.Row.Font = new Font("Arial Unicode MS", 12);
gridView1.AppearancePrint.Row.Options.UseFont = true;
gridView2.AppearancePrint.Row.Font = new Font("Arial Unicode MS", 12);
gridView2.AppearancePrint.Row.Options.UseFont = true;
gridView3.AppearancePrint.Row.Font = new Font("Arial Unicode MS", 12);
gridView3.AppearancePrint.Row.Options.UseFont = true;
PrintingSystem ps = new PrintingSystem();
CompositeLink compositeLink = new CompositeLink();
compositeLink.PrintingSystem = ps;
foreach (GridControl gc in grids)
{
PrintableComponentLink link = new PrintableComponentLink();
link.Component = gc;
compositeLink.Links.Add(link);
}
compositeLink.CreateDocument();
//準備輸出
DevExpress.XtraPrinting.XlsExportOptions XEO = new DevExpress.XtraPrinting.XlsExportOptions();
XEO.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text;
XEO.ExportMode = XlsExportMode.SingleFile;
XEO.SheetName = FileName_OutPutExcel;
DevExpress.XtraPrinting.PdfExportOptions PEO = new PdfExportOptions();
//PEO.PasswordSecurityOptions.OpenPassword = "******";
#region 檢查檔案是否能寫入
bool IsFileLocked = false;
if (File.Exists(OFD.FileName))
{
FileInfo filepath = new FileInfo(OFD.FileName);
FileStream steam = null;
try
{
steam = filepath.Open(FileMode.Open, FileAccess.ReadWrite, FileShare.None);
}
catch (IOException e1)
{
IsFileLocked = true;
}
finally
{
if (steam != null)
{
steam.Close();
}
}
}
#endregion
if (IsFileLocked)
{
MessageBox.Show("檔案被鎖定，請檢查是否有其他程式正在開啟", "匯出失敗");
return;
}
compositeLink.ExportToXls(OFD.FileName, XEO);
//gridView1.ExportToXls(OFD.FileName, XEO);
MessageBox.Show("檔案匯出至 " + OFD.FileName + " 完畢", "匯出成功");
//gridview排版
gridView1.OptionsView.ColumnAutoWidth = true;
gridView1.OptionsPrint.AutoWidth = true;
gridView1.BestFitColumns();
gridView2.OptionsView.ColumnAutoWidth = true;
gridView2.OptionsPrint.AutoWidth = true;
gridView2.BestFitColumns();
gridView3.OptionsView.ColumnAutoWidth = true;
gridView3.OptionsPrint.AutoWidth = true;
gridView3.BestFitColumns();
}
