private void btnExportToExel_Click(object sender, EventArgs e)
{
var saveFileDialog1 = new SaveFileDialog
{
Filter = @"Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*",
Title = @"Save exel file",
OverwritePrompt = true,
FileName = $"Reports-KillsMap{DateTime.Now.ToString("dd-MM-yyyy")}"
};
var show = saveFileDialog1.ShowDialog();
if (show == DialogResult.Cancel)
{
saveFileDialog1.Dispose();
}
if (show == DialogResult.OK)
{
if (saveFileDialog1.FileName != "")
{
XlsxExportOptions opt = new XlsxExportOptions()
{
TextExportMode = TextExportMode.Text,
};
gridControl1.ExportToXlsx(saveFileDialog1.FileName, opt);
}
Process.Start(saveFileDialog1.FileName);
}
}
private void xuatExcel()
{
string ten_cautruyvan = "";
if (this.lookUpEditCauTruyVan.EditValue.ToString() != "Tên Câu Truy Vấn")
{
ten_cautruyvan = this.lookUpEditCauTruyVan.Text.ToString();
}
SaveFileDialog f = new SaveFileDialog();
f.Filter = "Excel file (*.xlsx)|*.xlsx";
f.FileName = tenCSKCB + "_DichVuKyThuat_" + ten_cautruyvan + "_" + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString();
if (f.ShowDialog() == DialogResult.OK)
{
CompositeLink complink = new CompositeLink(new PrintingSystem());
PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
link.Component = this.gridControlKetQua;
link.CreateMarginalHeaderArea += new CreateAreaEventHandler(Link_CreateMarginalHeaderArea_1);
complink.Links.Add(link);
//Rename Sheet
complink.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated_1;
complink.CreatePageForEachLink();
XlsxExportOptions options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
complink.ExportToXlsx(f.FileName, options);
MessageBox.Show("Xuất Excel Thành Công!");
}
}
private void ExportToExcel(object sender, EventArgs e)
{
var sfd = new SaveFileDialog
{
Title = @"Enregistrer",
DefaultExt = "xlsx",
Filter = @"Excel document (*.xlsx)|*.xlsx"
};
if (sfd.ShowDialog() != DialogResult.OK)
{
return;
}
if (string.IsNullOrEmpty(sfd.FileName))
{
return;
}
// les options d'exportation Excel
var option = new XlsxExportOptions
{
RawDataMode = true,
TextExportMode = TextExportMode.Value,
ShowGridLines = true,
ExportMode = XlsxExportMode.SingleFile,
ExportHyperlinks = false,
};
// export grid view to Excel
viewLigne.ExportToXlsx(sfd.FileName, option);
OpenExportedFile(sfd.FileName);
}
private void sbExport_Click(object sender, EventArgs e)
{
var sfd = new SaveFileDialog();
sfd.Filter = "Excel File (*.xlsx)|*.xlsx";
if (sfd.ShowDialog(this) == DialogResult.OK)
{
var printingSystem = new PrintingSystemBase();
var compositeLink = new CompositeLinkBase();
compositeLink.PrintingSystemBase = printingSystem;
var link = new PrintableComponentLinkBase();
link.Component = gcRawData;
compositeLink.Links.Add(link);
link = new PrintableComponentLinkBase();
link.Component = gcSummary;
compositeLink.Links.Add(link);
var options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
compositeLink.CreatePageForEachLink();
compositeLink.ExportToXlsx(sfd.FileName, options);
System.Diagnostics.Process.Start(sfd.FileName);
}
}
private void xuatExcel()
{
SaveFileDialog f = new SaveFileDialog();
f.Filter = "Excel file (*.xlsx)|*.xlsx";
f.FileName = "DichVuKyThuat_" + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString();
if (f.ShowDialog() == DialogResult.OK)
{
/*
* CompositeLink complink = new CompositeLink(new PrintingSystem());
* PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
* link.Component = this.gridControlCSKCB;
* link.CreateMarginalHeaderArea += new CreateAreaEventHandler(Link_CreateMarginalHeaderArea);
* complink.Links.Add(link);
*/
//Rename Sheet
complinkMain.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated;
complinkMain.CreatePageForEachLink();
XlsxExportOptions options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
complinkMain.ExportToXlsx(f.FileName, options);
flag_i = 0;
MessageBox.Show("Xuất Excel Thành Công!");
}
}
private void barButtonItem4_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
CompositeLink complink = new CompositeLink(new PrintingSystem());
PrintableComponentLink linkTable1 = new PrintableComponentLink();
PrintableComponentLink linkTable2 = new PrintableComponentLink();
PrintableComponentLink linkDiff = new PrintableComponentLink();
linkTable1.Component = gcWeight;
complink.Links.Add(linkTable1);
linkTable2.Component = gcFuel;
complink.Links.Add(linkTable2);
linkDiff.Component = gcType;
complink.Links.Add(linkDiff);
complink.CreatePageForEachLink();
if (this.saveFileDialog.ShowDialog() == DialogResult.OK)
{
XlsxExportOptions option = new XlsxExportOptions()
{
ExportMode = XlsxExportMode.SingleFilePageByPage
};
complink.ExportToXlsx(saveFileDialog.FileName, option);
if (MessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnExportList_Click(object sender, EventArgs e)
{
try
{
if (gvListProject.RowCount > 0)
{
var dialog = new SaveFileDialog();
dialog.Title = @"Export file excel";
dialog.FileName = "";
dialog.Filter = @"Micrsoft Excel|*.xlsx";
if (dialog.ShowDialog() == DialogResult.OK)
{
gvListProject.ColumnPanelRowHeight = 40;
gvListProject.OptionsPrint.AutoWidth = AutoSize;
gvListProject.OptionsPrint.ShowPrintExportProgress = true;
gvListProject.OptionsPrint.AllowCancelPrintExport = true;
XlsxExportOptions options = new XlsxExportOptions();
options.TextExportMode = TextExportMode.Text;
options.ExportMode = XlsxExportMode.SingleFile;
options.SheetName = "Sheet1";
ExportSettings.DefaultExportType = ExportType.Default;
gvListProject.ExportToXlsx(dialog.FileName, options);
}
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show("Error" + ex, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// DevExpress通用导出Excel,支持多个控件同时导出在同一个Sheet表
/// eg:ExportToXlsx("",gridControl1,gridControl2);
/// 将gridControl1和gridControl2的数据一同导出到同一张工作表
/// </summary>
/// <param name="title">文件名</param>
/// <param name="panels">控件集</param>
public static void ExportToExcel(string title, GridControl panels)
{
var saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = title;
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog();
if (dialogResult == DialogResult.Cancel)
{
return;
}
string FileName = saveFileDialog.FileName;
var ps = new PrintingSystem();
CompositeLink link = new CompositeLink(ps);
ps.Links.Add(link);
link.Links.Add(CreatePrintableLink(panels));
link.Landscape = true;//横向
//判断是否有标题，有则设置
//link.CreateDocument(); //建立文档
try
{
int count = 1;
//在重复名称后加（序号）
while (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)
{
XlsxExportOptions options = new XlsxExportOptions();
link.ExportToXlsx(FileName, options);
}
else
{
XlsExportOptions options = new XlsExportOptions();
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 static bool ExportExcelByPath(XtraReport report, string filePath, string sheetName, bool hasOpened = true)
{
try
{
if (report == null)
{
return(false);
}
XlsxExportOptions xlsxExportOptions = new XlsxExportOptions
{
SheetName = sheetName
};
if (report.Parameters[ExcelParam] != null)
{
report.Parameters[ExcelParam].Value = true;
}
report.ExportToXlsx(filePath, xlsxExportOptions);
if (hasOpened)
{
System.Diagnostics.Process.Start(filePath);
}
return(true);
}
catch (Exception ex)
{
BSLog.Logger.Warn(ex.Message);
MessageBoxHelper.ShowErrorMessage($"Xuất excel thất bại!\r\n{ex.Message}");
return(false);
}
}
private void btnSendToExcel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
checkDirectory();
if (tcMain.SelectedTab.Name == "tpProd")
{
fileName = "-Production";
checkExcel();
XlsxExportOptions options = new XlsxExportOptions();
options.SheetName = "Production";
gvProd.ExportToXlsx(excelName, options);
}
if (tcMain.SelectedTab.Name == "tpTramming")
{
fileName = "-Tramming";
checkExcel();
XlsxExportOptions options = new XlsxExportOptions();
options.SheetName = "Production";
gvTramming.ExportToXlsx(excelName, options);
}
if (tcMain.SelectedTab.Name == "tpSB")
{
fileName = "-ShiftBoss";
checkExcel();
XlsxExportOptions options = new XlsxExportOptions();
options.SheetName = "Production";
gvSB.ExportToXlsx(excelName, options);
}
acControl.Show(frmMain.ActiveForm, "Export Complete", "Click on folder to open");
}
private void btnExportToExcel_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog save = new SaveFileDialog();
save.Filter = "Excel 2007-2010 (*.xlsx)|*.xlsx|All file (*.*)|*.*";
if (save.ShowDialog() == DialogResult.OK)
{
XlsxExportOptions tuyChinh = new XlsxExportOptions()
{
SheetName = tenBang,
ShowGridLines = true,
ExportMode = XlsxExportMode.SingleFile,
TextExportMode = TextExportMode.Value
};
gridControl1.ExportToXlsx(save.FileName, tuyChinh);
StaticClass.Log.GhiFile("Xuất dữ liệu bảng " + tenBang + " ra file Excel: " + save.FileName);
}
}
catch (Exception ex)
{
ExceptionUtil.ThrowMsgBox(ex.Message);
}
}
private bool ExportExcel(string filename)
{
try
{
if (gridView1.FocusedRowHandle < 0)
{
}
else
{
SaveFileDialog.FileName = filename;
if (SaveFileDialog.ShowDialog() == DialogResult.OK)
{
gridView1.ColumnPanelRowHeight = 20;
gridView1.OptionsPrint.AutoWidth = AutoSize;
XlsxExportOptions options = new XlsxExportOptions();
options.TextExportMode = TextExportMode.Text;
options.ExportMode = XlsxExportMode.SingleFile;
options.SheetName = $"Hóa Đơn tháng {dtpDuLieuHoaDon.Value.Month.ToString()}-{dtpDuLieuHoaDon.Value.Year.ToString()}";
ExportSettings.DefaultExportType = ExportType.Default;
gridView1.ExportToXlsx(SaveFileDialog.FileName, options);
MessageBox.Show("Xuất thành công");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(false);
}
//Xuất excel
private void ExportExcel(string fileName)
{
try
{
if (advBandedGridView1.FocusedRowHandle < 0)
{
}
else
{
var dialog = new SaveFileDialog();
dialog.Title = @"Export file excel";
dialog.FileName = fileName;
dialog.Filter = @"Microsoft Excel|*.xlsx";
if (dialog.ShowDialog() == DialogResult.OK)
{
advBandedGridView1.ColumnPanelRowHeight = 40;
advBandedGridView1.OptionsPrint.AutoWidth = AutoSize;
advBandedGridView1.OptionsPrint.ShowPrintExportProgress = true;
advBandedGridView1.OptionsPrint.AllowCancelPrintExport = true;
XlsxExportOptions options = new XlsxExportOptions();
options.TextExportMode = TextExportMode.Text;
options.ExportMode = XlsxExportMode.SingleFile;
options.SheetName = @"List";
ExportSettings.DefaultExportType = ExportType.Default;
advBandedGridView1.ExportToXlsx(dialog.FileName, options);
MessageBox.Show("Xuất dũ liệu thành công!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception e)
{
MessageBox.Show("Lỗi" + e, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void ExportToExcel(string title, params IPrintable[] panels)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = title;
saveFileDialog.Title = string.Format("{0} Excel", UnitField.Export);
saveFileDialog.Filter = "Excel (*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
{
return;
}
string text = saveFileDialog.FileName;
PrintingSystem expr_43 = new PrintingSystem();
CompositeLink compositeLink = new CompositeLink(expr_43);
expr_43.Links.Add(compositeLink);
for (int i = 0; i < panels.Length; i++)
{
IPrintable printable = panels[i];
compositeLink.Links.Add(ExportToExcelHelper.CreatePrintableLink(printable));
}
compositeLink.Landscape = true;
try
{
int num = 1;
while (File.Exists(text))
{
if (text.Contains(")."))
{
int startIndex = text.LastIndexOf("(", StringComparison.Ordinal);
int length = text.LastIndexOf(").", StringComparison.Ordinal) - text.LastIndexOf("(", StringComparison.Ordinal) + 2;
text = text.Replace(text.Substring(startIndex, length), string.Format("({0}).", num));
}
else
{
text = text.Replace(".", string.Format("({0}).", num));
}
num++;
}
if (text.LastIndexOf(".xlsx", StringComparison.Ordinal) >= text.Length - 5)
{
XlsxExportOptions options = new XlsxExportOptions();
compositeLink.ExportToXlsx(text, options);
}
else
{
XlsExportOptions options2 = new XlsExportOptions();
compositeLink.ExportToXls(text, options2);
}
if (XtraMessageBox.Show(UnitField.ExportOK, UnitField.SystemMessage, MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
{
Process.Start(text);
}
}
catch (Exception arg_16F_0)
{
XtraMessageBox.Show(arg_16F_0.Message);
}
}
private void exportToExcelToolStripMenuItem_Click(object sender, EventArgs e)
{
XlsxExportOptions xeo = new XlsxExportOptions();
if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
accKlnDtyAllGridControl.ExportToXlsx(saveFileDialog.FileName);
}
}
public static void ExportExcel(string reportID,
object dataSource,
List <ReportParam> reportParams,
bool hasOpened = true,
bool isUseParramCommon = true,
string sheetName = null)
{
string templateName = ReportTemplate.GetTemplate(reportID);
SaveFileDialog openFileDialog = new SaveFileDialog
{
Filter = "Excel file(*.xlsx)|*.xlsx",
FileName = templateName
};
string path;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
path = openFileDialog.FileName;
}
else
{
return;
}
try
{
XlsxExportOptions xlsxExportOptions = new XlsxExportOptions
{
SheetName = string.IsNullOrWhiteSpace(sheetName) ? templateName : sheetName
};
reportParams.Add(new ReportParam(ExcelParam, true));
XtraReport report = GetReport(reportID, dataSource, reportParams, isUseParramCommon);
if (report == null)
{
return;
}
report.ExportToXlsx(path, xlsxExportOptions);
if (hasOpened)
{
System.Diagnostics.Process.Start(path);
}
}
catch (Exception ex)
{
BSLog.Logger.Warn(ex.Message);
MessageBoxHelper.ShowErrorMessage($"Xuất excel thất bại!\r\n{ex.Message}");
}
}
private void toExcel()
{
XlsxExportOptions opt = new XlsxExportOptions();
opt.ExportMode = XlsxExportMode.SingleFilePageByPage;
string FileName = "C:\\CORRECT\\XLS\\" + Reportenombre + ".xlsx";
opt.SheetName = "NEW";
//gridView1.ExportToXlsx(FileName);
gridView1.OptionsPrint.ExpandAllDetails = true;
gridView1.OptionsPrint.PrintDetails = true;
gridView1.OptionsPrint.ExpandAllGroups = true;
//gridView2.OptionsPrint.ExpandAllDetails = true;
//gridView2.OptionsPrint.PrintDetails = true;
gridView1.ZoomView();
//CompositeLink conp = new CompositeLink();
var printingSystem = new PrintingSystemBase();
var compositeLink = new CompositeLinkBase();
compositeLink.PrintingSystemBase = printingSystem;
var link1 = new PrintableComponentLinkBase();
link1.Component = gridControl1;
//var link2 = new PrintableComponentLinkBase();
//link2.Component = grid2;
compositeLink.Links.Add(link1);
// compositeLink.Links.Add(link2);
var options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
compositeLink.CreatePageForEachLink();
compositeLink.ExportToXlsx(FileName, options);
//conp.ExportToXlsx(FileName, opt);
//gridView1.ExportToXlsx(FileName,opt);
//gridControl1.DefaultView
Microsoft.Office.Interop.Excel.Application excell;
Microsoft.Office.Interop.Excel.Workbook workbook;
excell = new Excel.Application();
excell.Visible = true;
workbook = excell.Workbooks.Open(FileName);
}
protected override bool Export(CompositeLink link, string path, ExportOptions options)
{
var xlsxExportOptions = new XlsxExportOptions
{
TextExportMode = options.TextExportMode,
ShowGridLines = options.ShowGridLines,
ExportMode = (link.Links.Count == 1) ? XlsxExportMode.SingleFile : XlsxExportMode.SingleFilePageByPage
};
link.ExportToXlsx(path, xlsxExportOptions);
return(!options.CustomExcelExport || CustomPrinting(options, path, link));
}
public static void ExportExcel(XtraReport report, string reportID, bool hasOpened = true)
{
string templateName = ReportTemplate.GetTemplate(reportID);
SaveFileDialog openFileDialog = new SaveFileDialog
{
Filter = "Excel file(*.xlsx)|*.xlsx",
FileName = templateName
};
string path;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
path = openFileDialog.FileName;
}
else
{
return;
}
try
{
XlsxExportOptions xlsxExportOptions = new XlsxExportOptions
{
SheetName = templateName
};
if (report == null)
{
return;
}
if (report.Parameters[ExcelParam] != null)
{
report.Parameters[ExcelParam].Value = true;
}
report.ExportToXlsx(path, xlsxExportOptions);
if (hasOpened)
{
System.Diagnostics.Process.Start(path);
}
}
catch (Exception ex)
{
BSLog.Logger.Warn(ex.Message);
MessageBoxHelper.ShowErrorMessage($"Xuất excel thất bại!\r\n{ex.Message}");
}
}
private void ExportToEx(string filename, string ext)
{
try
{
this.VisibleColumnNoExport(false);
this.printSystem = new PrintingSystem();
this.printCompageLink = new PrintableComponentLink(this.printSystem)
{
Component = this._exportView.GridControl
};
//this.printCompageLink.RtfReportFooter = "1234";
this.printCompageLink.CreateDocument();
//if (this.waitDialog != null)
// this.waitDialog.SetCaption("Exporting Data ...");
switch (ext.ToUpper())
{
case "XLS":
var optXls = new XlsExportOptions()
{
SheetName = (string.IsNullOrEmpty(_sheetName) ? "Sheet1" : _sheetName)
};
this.printCompageLink.PrintingSystem.ExportToXls(filename, optXls);
break;
case "XLSX":
var optXlsx = new XlsxExportOptions()
{
SheetName = (string.IsNullOrEmpty(_sheetName) ? "Sheet1" : _sheetName)
};
this.printCompageLink.PrintingSystem.ExportToXlsx(filename, optXlsx);
break;
default:
break;
}
this.VisibleColumnNoExport(true);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
/// <summary>
/// 导出Excel(xlsx)
/// </summary>
/// <param name="gv"></param>
private static void ExportXlsx(GridView gv)
{
var saveFileDialog = new SaveFileDialog {
FileName = DateTime.Now.ToString(BaseSystemInfo.DateFormat) + "打印数据", Title = @"导出Excel", Filter = @"Excel文件(*.xlsx)|*.xlsx", OverwritePrompt = false
}; //已存在文件是否覆盖提示
var dialogResult = saveFileDialog.ShowDialog();
if (dialogResult != DialogResult.OK)
{
return;
}
while (System.IO.File.Exists(saveFileDialog.FileName) && XtraMessageBox.Show("该文件名已存在，是否覆盖？", AppMessage.MSG0000, MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
if (dialogResult != DialogResult.Yes)
{
return;
}
}
if (string.IsNullOrEmpty(saveFileDialog.FileName))
{
return;
}
try
{
var options = new XlsxExportOptions
{
//Excel 导出Sheet名称
SheetName = string.Format("{0}商家的打印数据-{1}", BaseSystemInfo.UserInfo.NickName, DateTime.Now.ToString(BaseSystemInfo.DateTimeFormat)),
TextExportMode = TextExportMode.Text,
ShowGridLines = true
};
if (gv.Columns.ColumnByFieldName("Check") != null)
{
gv.Columns["Check"].Visible = false;
}
gv.ExportToXlsx(saveFileDialog.FileName, options);
if (gv.Columns.ColumnByFieldName("Check") != null)
{
gv.Columns["Check"].Visible = true;
}
// ExcelHelper.SetAutoFilter(saveFileDialog.FileName);
OpenFile(saveFileDialog.FileName);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message.Contains("正由另一进程使用") ? "数据导出失败！文件正由另一个程序占用！" : ex.Message, AppMessage.MSG0000);
}
}
public bool ExportExcel(string filename)
{
try
{
if (grvPhieuNhap.FocusedRowHandle < 0)
{
MessageBox.Show("Danh sách hóa đơn hiện đang trống!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
var dialog = new SaveFileDialog();
dialog.Title = @"Xuất hóa đơn ra Excel";
dialog.FileName = filename;
dialog.Filter = "Excel Files|*.xlsx;*.xlsm";
if (dialog.ShowDialog() == DialogResult.OK)
{
grvPhieuNhap.ColumnPanelRowHeight = 40;
grvPhieuNhap.OptionsPrint.AutoWidth = AutoSize;
grvPhieuNhap.OptionsPrint.ShowPrintExportProgress = true;
grvPhieuNhap.OptionsPrint.AllowCancelPrintExport = true;
XlsxExportOptions options = new XlsxExportOptions();
options.TextExportMode = TextExportMode.Text;
options.ExportMode = XlsxExportMode.SingleFile;
options.SheetName = @"Hóa đơn";
ExportSettings.DefaultExportType = ExportType.WYSIWYG;
grvPhieuNhap.ExportToXlsx(dialog.FileName, options);
MessageBox.Show("Xuất file thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (File.Exists(dialog.FileName))
{
if (MessageBox.Show("Bạn có muốn mở file?", "Mở file", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
Process.Start(dialog.FileName);
}
}
}
}
}
catch (Exception)
{
MessageBox.Show("Xuất file thất bại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(false);
}
private void btnExportToExcel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel Files(2007)| *.xlsx";
saveFileDialog.FileName = "Export_Result_" + Guid.NewGuid().ToString();
var op = saveFileDialog.ShowDialog();
if (op == DialogResult.OK)
{
var path = saveFileDialog.FileName;
var t = new XlsxExportOptions();
t.SheetName = "QueryResult";
t.ShowGridLines = false;
gridControlResults.ExportToXlsx(path, t);
}
}
private void barButtonItem4_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
CompositeLink complink = new CompositeLink(new PrintingSystem());
PrintableComponentLink linkTable1 = new PrintableComponentLink();
PrintableComponentLink linkTable2 = new PrintableComponentLink();
PrintableComponentLink linkDiff = new PrintableComponentLink();
linkTable1.Component = gcTable1;
complink.Links.Add(linkTable1);
linkTable2.Component = gcTable2;
complink.Links.Add(linkTable2);
linkDiff.Component = gcTable3;
complink.Links.Add(linkDiff);
if (gcTable1.MainView.RowCount == 0 && gcTable2.MainView.RowCount == 0 && gcTable3.MainView.RowCount == 0)
{
return;
}
else
{
complink.CreatePageForEachLink();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
saveFileDialog.FileName = "通告比对结果";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsxExportOptions option = new XlsxExportOptions();
option.ExportMode = XlsxExportMode.SingleFilePageByPage;
complink.ExportToXlsx(saveFileDialog.FileName, option);
MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void ExcelDnData()
{
if (gridView1.RowCount == 0)
{
MessageBox.Show("저장할 데이터가 없습니다. 조회 후 다운로드 가능합니다.");
return;
}
else
{
string FileName = this.Text + "(" + DateTime.Now.ToString("yyyyMMdd") + ").xlsx";
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "Excel파일(*.xlsx)|*.xlsx";
saveFile.FileName = FileName;
saveFile.RestoreDirectory = true;
if (saveFile.ShowDialog() == DialogResult.OK)
{
PrintingSystemBase ps = new PrintingSystemBase(); // 프린트 형식에 각각 컨트롤을 링크로 만들어서 같은 엑셀 파일에 뿌리기
CompositeLinkBase cl = new CompositeLinkBase();
cl.PrintingSystemBase = ps;
PrintableComponentLinkBase pcl1 = new PrintableComponentLinkBase(); // 첫번째 그래프 들어갈 링크
pcl1.Component = chartControl_Pie;
PrintableComponentLinkBase pcl2 = new PrintableComponentLinkBase(); // 두번째 그래프 들어갈 링크
pcl2.Component = chartControl_Bar;
PrintableComponentLinkBase pcl3 = new PrintableComponentLinkBase(); // 세번째 그리드 들어갈 링크
pcl3.Component = gridControl1;
XlsxExportOptions options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.DifferentFiles;
cl.Links.Add(pcl1);
cl.Links.Add(pcl2);
cl.Links.Add(pcl3);
cl.CreateDocument(); // 각각의 링크를 합쳐서 한개의 문서로 만들어줌
cl.ExportToXlsx(saveFile.FileName, new XlsxExportOptionsEx {
ExportType = ExportType.WYSIWYG
}); // 데이터 있는 만큼만 그리드 그림
//gridView1.ExportToXlsx(saveFile.FileName, new XlsxExportOptionsEx { ExportType = ExportType.WYSIWYG });
}
}
}
public static void ExportExcel(
this GridControl gridControl,
string templateID,
bool hasOpened = true)
{
string sheetName = ExcelTemplate.GetTemplate(templateID);
SaveFileDialog openFileDialog = new SaveFileDialog
{
Filter = "Excel file(*.xlsx)|*.xlsx",
FileName = sheetName
};
string path;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
path = openFileDialog.FileName;
}
else
{
return;
}
try
{
XlsxExportOptions xlsxExportOptions = new XlsxExportOptions
{
SheetName = sheetName
};
gridControl.ExportToXlsx(path, xlsxExportOptions);
if (hasOpened)
{
System.Diagnostics.Process.Start(path);
}
}
catch (Exception ex)
{
BSLog.Logger.Warn(ex.Message);
// MessageBoxHelper.ShowErrorMessage($"Xuất excel thất bại!\r\n{ex.Message}");
}
}
private void xuatExcel_ToanBoCauLenh()
{
SaveFileDialog f = new SaveFileDialog();
f.Filter = "Excel file (*.xlsx)|*.xlsx";
f.FileName = tenCSKCB + "_DichVuKyThuat_" + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString();
if (f.ShowDialog() == DialogResult.OK)
{
//Rename Sheet
complinkMain.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated;
complinkMain.CreatePageForEachLink();
XlsxExportOptions options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
complinkMain.ExportToXlsx(f.FileName, options);
flag_i = 0;
MessageBox.Show("Xuất Excel Thành Công!");
}
}
private void ExportarAExcel(GridView vista, string vendedor)
{
var saveFileDialog1 = new SaveFileDialog
{
Filter = @"Excel Formato xls (*.xls)|*.xls|Excel Formato xlsx (*.xlsx)|*.xlsx",
Title = @"Exportar a Excel",
FileName = "Comisiones_" + string.Format("{0:ddMMyy}", DateTime.Now)
};
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFileDialog1.FileName != "")
{
var f = saveFileDialog1.FileName;
vista.BeginInit();
try
{
vista.BestFitColumns();
//vista.ExportToXls(f,opt);
var ext = Path.GetExtension(f);
if (f == ".xls")
{
XlsExportOptions opt = new XlsExportOptions();
opt.SheetName = vendedor;
vista.ExportToXls(f, opt);
}
else
{
XlsxExportOptions opt = new XlsxExportOptions();
opt.SheetName = vendedor;
vista.ExportToXlsx(f, opt);
}
}
finally
{
vista.EndInit();
}
var excelApp = new Microsoft.Office.Interop.Excel.Application();
excelApp.Visible = true;
excelApp.Workbooks.Open(f);
}
}
private void ExportExcel()
{
string path = string.Empty;
try
{
path = string.Format(@"{0}\{1}_{2}.xlsx", GetTempFolder(), Model.CurrentShop.ShopCode.Trim(), DateTime.Now.ToFileTime());
var xlsxOptions = new XlsxExportOptions
{
ShowGridLines = false,
TextExportMode = TextExportMode.Value,
ExportHyperlinks = true
};
grid.ExportToXlsx(path, xlsxOptions);
Process.Start(path);
}
catch (Exception e)
{
XtraMessageBox.Show(e.Message + " " + path, "Ошибка экспорта");
}
}
private void xuấtExcelToolStripMenuItem_Click(object sender, EventArgs e)
{
if (xuatExcelDialog.ShowDialog() == DialogResult.OK)
{
var compositeLink = new CompositeLinkBase();
compositeLink.PrintingSystemBase = ps;
var sheetTnBao = new PrintableComponentLinkBase();
sheetTnBao.Component = gridcontrol_tinbao;
var sheetXLK = new PrintableComponentLinkBase();
sheetXLK.Component = gridControl_xlk;
compositeLink.Links.Add(sheetTnBao);
compositeLink.Links.Add(sheetXLK);
var options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
compositeLink.CreatePageForEachLink();
compositeLink.ExportToXlsx(xuatExcelDialog.FileName, options);
}
}
public void HandleCommand(PrintingSystemCommand command, object[] args, IPrintControl printControl, ref bool handled)
{
if (!CanHandleCommand(command, printControl))
{
return;
}
XlsxExportOptions options = new XlsxExportOptions()
{
ExportMode = XlsxExportMode.DifferentFiles
};
DialogResult dr = ExportOptionsTool.EditExportOptions(options, printControl.PrintingSystem);
if (dr == System.Windows.Forms.DialogResult.OK)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.FileName = "XtraReport.xlsx";
sfd.Filter = "XLSX File|*.xlsx";
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
printControl.PrintingSystem.ExportToXlsx(sfd.FileName, options);
string fileName = Path.GetFileNameWithoutExtension(sfd.FileName);
string path = Path.GetDirectoryName(sfd.FileName);
List <string> fileNames = new List <string>();
for (int i = 1; i <= printControl.PrintingSystem.PageCount; i++)
{
string genFileName = string.Format("{0}\\{1}{2}", path, fileName, i);
System.IO.File.Move(genFileName + ".xlsx", String.Format("{0}{1}.xlsx", genFileName, FileName));
}
}
}
handled = true;
}
public void ExportData()
{
using (var dialog = new SaveFileDialog())
{
dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialog.FileName = string.Format("quickSITES & Emails({0}).xlsx", DateTime.Now.ToString("MMddyy-hmmtt"));
dialog.Filter = "Excel files|*.xlsx";
dialog.Title = "Export quickSites & Emails";
if (dialog.ShowDialog() != DialogResult.OK) return;
var options = new XlsxExportOptions();
options.SheetName = Path.GetFileNameWithoutExtension(dialog.FileName);
options.TextExportMode = TextExportMode.Text;
options.ExportHyperlinks = true;
options.ShowGridLines = true;
options.ExportMode = XlsxExportMode.SingleFile;
var parts = new Dictionary<string, string>();
using (var form = new FormProgress())
{
FormMain.Instance.ribbonControl.Enabled = false;
Enabled = false;
form.laProgress.Text = "Exporting data...";
form.TopMost = true;
form.Show();
Application.DoEvents();
var thread = new Thread(() =>
{
var tempFile = Path.Combine(Path.GetTempPath(), String.Format("{0}.xlsx", Guid.NewGuid()));
BeginInvoke(new Action(() =>
{
using (var printingSystem = new PrintingSystem())
{
var printLink = new PrintableComponentLink
{
Landscape = true,
PaperKind = PaperKind.A4,
Component = gridControlRecords
};
printLink.CreateReportHeaderArea += OnCreateReportHeaderArea;
printLink.CreateDocument(printingSystem);
printingSystem.ExportToXlsx(tempFile, options);
}
}));
parts.Add("quickSITES & Emails", tempFile);
ActivityExportHelper.ExportCommonData(dialog.FileName, parts);
});
thread.Start();
while (thread.IsAlive)
{
Thread.Sleep(100);
Application.DoEvents();
}
form.Close();
Enabled = true;
FormMain.Instance.ribbonControl.Enabled = true;
}
if (File.Exists(dialog.FileName))
Process.Start(dialog.FileName);
}
}
public void ExportFiles()
{
using (var dialog = new SaveFileDialog())
{
dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialog.FileName = string.Format("{0} Files ({1}).xlsx", ProfileName, DateTime.Now.ToString("MMddyy-hmmtt"));
dialog.Filter = "Excel files|*.xlsx";
dialog.Title = "Export Files";
if (dialog.ShowDialog() == DialogResult.OK)
{
var options = new XlsxExportOptions();
options.SheetName = Path.GetFileNameWithoutExtension(dialog.FileName);
options.TextExportMode = TextExportMode.Text;
options.ExportHyperlinks = true;
options.ShowGridLines = true;
options.ExportMode = XlsxExportMode.SingleFile;
printableComponentLink.CreateDocument();
printableComponentLink.PrintingSystem.ExportToXlsx(dialog.FileName, options);
if (File.Exists(dialog.FileName))
Process.Start(dialog.FileName);
}
}
}
private void xuat_excel()
{
XlsxExportOptions opt = new XlsxExportOptions();
opt.SheetName = "NHAP_HOP_DONG";
opt.TextExportMode = TextExportMode.Value;
string path = WinFormControls.saveFileDialog("HOP_DONG");
if (!String.IsNullOrEmpty(path))
{
m_grv_hop_dong.ExportToXlsx(path, opt);
var excel = new Microsoft.Office.Interop.Excel.Application();
excel.Visible = true;
Microsoft.Office.Interop.Excel.Workbooks books = excel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook openexcel = books.Open(path);
}
}
public void ExportData()
{
using (var dialog = new SaveFileDialog())
{
dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialog.FileName = string.Format("ActiveLibraries({0}).xlsx", DateTime.Now.ToString("MMddyy-hmmtt"));
dialog.Filter = "Excel files|*.xlsx";
dialog.Title = "Export Active Libraries";
if (dialog.ShowDialog() != DialogResult.OK) return;
var options = new XlsxExportOptions();
options.SheetName = Path.GetFileNameWithoutExtension(dialog.FileName);
options.TextExportMode = TextExportMode.Text;
options.ExportHyperlinks = true;
options.ShowGridLines = true;
options.ExportMode = XlsxExportMode.SingleFile;
var groupControls = xtraTabControlLibraries.TabPages.OfType<IGroupControl>().Reverse();
var parts = new Dictionary<string, string>();
using (var form = new FormProgress())
{
FormMain.Instance.ribbonControl.Enabled = false;
Enabled = false;
form.laProgress.Text = "Exporting data...";
form.TopMost = true;
form.Show();
Application.DoEvents();
var thread = new Thread(() =>
{
foreach (var groupControl in groupControls)
{
var tempFile = Path.Combine(Path.GetTempPath(), String.Format("{0}.xlsx", Guid.NewGuid()));
BeginInvoke(new Action(() =>
{
using (var printingSystem = new PrintingSystem())
{
groupControl.GetPrintLink().CreateDocument(printingSystem);
printingSystem.ExportToXlsx(tempFile, options);
}
}));
parts.Add(groupControl.GroupName, tempFile);
}
ActivityExportHelper.ExportCommonData(dialog.FileName, parts);
});
thread.Start();
while (thread.IsAlive)
{
Thread.Sleep(100);
Application.DoEvents();
}
form.Close();
Enabled = true;
FormMain.Instance.ribbonControl.Enabled = true;
}
if (File.Exists(dialog.FileName))
Process.Start(dialog.FileName);
}
}
