public ActionResult ExportTo() { var ps = new PrintingSystemBase(); var headerImageLink = new LinkBase(ps); headerImageLink.CreateDetailArea += headerImageLink_CreateDetailArea; var link1 = new PrintableComponentLinkBase(ps); GridViewSettings categoriesGridSettings = new GridViewSettings(); categoriesGridSettings.Name = "gvCategories"; categoriesGridSettings.KeyFieldName = "CategoryID"; categoriesGridSettings.Columns.Add("CategoryID"); categoriesGridSettings.Columns.Add("CategoryName"); categoriesGridSettings.Columns.Add("Description"); link1.Component = GridViewExtension.CreatePrintableObject(categoriesGridSettings, MyModel.GetCategories()); var compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { headerImageLink, link1 }); compositeLink.CreateDocument(); FileStreamResult result = CreateExcelExportResult(compositeLink); ps.Dispose(); return(result); }
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); } }
protected void Button1_Click(object sender, EventArgs e) { PrintingSystemBase ps = new PrintingSystemBase(); ps.ExportOptions.Pdf.DocumentOptions.Author = "Test"; PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps); link1.Component = ASPxPivotGridExporter1; PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps); WebChartControl1.DataBind(); link2.Component = ((IChartContainer)WebChartControl1).Chart; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1, link2 }); using (MemoryStream stream = new MemoryStream()) { compositeLink.ExportToPdf(stream); Response.Clear(); Response.Buffer = false; Response.AppendHeader("Content-Type", "application/pdf"); Response.AppendHeader("Content-Transfer-Encoding", "binary"); Response.AppendHeader("Content-Disposition", "attachment; filename=test.pdf"); Response.BinaryWrite(stream.ToArray()); Response.End(); } ps.Dispose(); }
protected void ExportButton_Click(object sender, EventArgs e) { PrintingSystemBase ps = new PrintingSystemBase(); PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps); link1.Component = GridExporter; PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps); Chart.DataBind(); link2.Component = ((IChartContainer)Chart).Chart; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1, link2 }); compositeLink.CreateDocument(); using (MemoryStream stream = new MemoryStream()) { compositeLink.PrintingSystemBase.ExportToXls(stream); Response.Clear(); Response.Buffer = false; Response.AppendHeader("Content-Type", "application/xls"); Response.AppendHeader("Content-Transfer-Encoding", "binary"); Response.AppendHeader("Content-Disposition", "attachment; filename=test.xls"); Response.BinaryWrite(stream.ToArray()); Response.End(); } ps.Dispose(); }
protected FileStreamResult CreateExcelExportResult(CompositeLinkBase link) { MemoryStream stream = new MemoryStream(); link.PrintingSystemBase.ExportToXls(stream); stream.Position = 0; FileStreamResult result = new FileStreamResult(stream, "application/xls"); result.FileDownloadName = "MyData.xls"; return(result); }
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); }
private static bool CanDefineTable(CompositeLinkBase compositeLink, int worksheetNumber) { if (compositeLink.Links.Count < worksheetNumber) { return(false); } var link = compositeLink.Links[worksheetNumber - 1] as PrintableComponentLink; if (link != null && link.Component is GridControl) { var gridControl = link.Component as GridControl; // the table definition only works for Gridviews, which are not banded. return(gridControl.FocusedView is GridView && !(gridControl.FocusedView is BandedGridView)); } return(false); }
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 }); } } }
private void ConfigureExport(ASPxGridView grid) { PrintingSystemBase ps = new PrintingSystemBase(); ps.ExportOptions.Xlsx.SheetName = "Tipos de Documentos"; ps.XlSheetCreated += ps_XlSheetCreated; PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps); link1.PaperName = "DatosGenerales"; link1.Component = Exporter; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1 }); compositeLink.CreatePageForEachLink(); ps.Dispose(); grid.Settings.ShowColumnHeaders = true; }
void Export(string format) { PrintingSystemBase ps = new PrintingSystemBase(); using (headerImage = Image.FromFile(Server.MapPath("~/Images/DevExpress-Logo-Large-Color.png"))) { LinkBase header = new LinkBase(); header.CreateDetailHeaderArea += Header_CreateDetailHeaderArea; PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(); link1.Component = this.ASPxGridViewExporter1; link1.CreateReportFooterArea += Link1_CreateReportFooterArea; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { header, link1 }); compositeLink.CreateDocument(); using (MemoryStream stream = new MemoryStream()) { switch (format) { case "xls": compositeLink.ExportToXls(stream); WriteToResponse("filename", true, format, stream); break; case "pdf": compositeLink.ExportToPdf(stream); WriteToResponse("filename", true, format, stream); break; case "rtf": compositeLink.ExportToRtf(stream); WriteToResponse("filename", true, format, stream); break; default: break; } } ps.Dispose(); } }
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); } }
protected void ExportButton_Click(object sender, EventArgs e) { PrintingSystemBase ps = new PrintingSystemBase(); PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps); link1.Component = GridExporter1; PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps); link2.Component = GridExporter2; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1, link2 }); compositeLink.CreateDocument(); using (MemoryStream stream = new MemoryStream()) { compositeLink.ExportToXls(stream); WriteToResponse("filename", true, "xls", stream); } ps.Dispose(); }
protected void bnExport_Click(object sender, EventArgs e) { ASPxButton btn = sender as ASPxButton; PrintingSystemBase ps = new PrintingSystemBase(); PrintableComponentLinkBase lnk = new PrintableComponentLinkBase(ps); lnk.Component = gridExporter; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { lnk }); compositeLink.CreateDocument(); MemoryStream stream = new MemoryStream(); string type = string.Empty; switch (btn.ID) { case "bnExportPDF": compositeLink.PrintingSystemBase.ExportToPdf(stream); type = "pdf"; break; case "bnExportXLS": compositeLink.PrintingSystemBase.ExportToXls(stream); type = "xls"; break; case "bnExportRRF": compositeLink.PrintingSystemBase.ExportToRtf(stream); type = "rtf"; break; } Session["ExportStream"] = stream; Session["type"] = type; }
protected void ExportButton_Click(object sender, EventArgs e) { PrintingSystemBase ps = new PrintingSystemBase(); PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps); link1.Component = GridExporter; PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps); link2.Component = TreeListExporter; PrintableComponentLinkBase link3 = new PrintableComponentLinkBase(ps); Chart.DataBind(); link3.Component = ((IChartContainer)Chart).Chart; CompositeLinkBase compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1, link2, link3 }); compositeLink.CreatePageForEachLink(); using (MemoryStream stream = new MemoryStream()) { XlsxExportOptions options = new XlsxExportOptions(); options.ExportMode = XlsxExportMode.SingleFilePageByPage; compositeLink.PrintingSystemBase.ExportToXlsx(stream, options); Response.Clear(); Response.Buffer = false; Response.AppendHeader("Content-Type", "application/xlsx"); Response.AppendHeader("Content-Transfer-Encoding", "binary"); Response.AppendHeader("Content-Disposition", "attachment; filename=test.xlsx"); Response.BinaryWrite(stream.ToArray()); Response.End(); } ps.Dispose(); }
public ActionResult ExportTo(int MasterRowKey) { var ps = new PrintingSystemBase(); var link1 = new PrintableComponentLinkBase(ps); GridViewSettings categoriesGridSettings = new GridViewSettings(); categoriesGridSettings.Name = "gvCategories"; categoriesGridSettings.KeyFieldName = "CategoryID"; categoriesGridSettings.Columns.Add("CategoryID"); categoriesGridSettings.Columns.Add("CategoryName"); categoriesGridSettings.Columns.Add("Description"); link1.Component = GridViewExtension.CreatePrintableObject(categoriesGridSettings, MyModel.GetCategories()); var link2 = new PrintableComponentLinkBase(ps); GridViewSettings productsGridSettings = new GridViewSettings(); productsGridSettings.Name = "gvProducts"; productsGridSettings.KeyFieldName = "ProductID"; productsGridSettings.Columns.Add("ProductID"); productsGridSettings.Columns.Add("ProductName"); productsGridSettings.Columns.Add("CategoryID"); productsGridSettings.Columns.Add("UnitPrice"); link2.Component = GridViewExtension.CreatePrintableObject(productsGridSettings, MyModel.GetProducts(MasterRowKey)); var compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1, link2 }); compositeLink.CreateDocument(); FileStreamResult result = CreateExcelExportResult(compositeLink); ps.Dispose(); return(result); }
public void exportToExcel( ) { using (var saveDialog = new SaveFileDialog()) { DialogResult dialogResult = default(DialogResult); var _with1 = saveDialog; _with1.Filter = "Microsoft Excel|*.xls"; _with1.Title = "Save as Excel"; _with1.FileName = string.Format("{0}_{1}", this.Text, DateTime.Today.ToString("yyyyMMdd")); _with1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); if (_with1.ShowDialog() == DialogResult.OK) { try { var printingSystem = new PrintingSystemBase(); var compositeLink = new CompositeLinkBase(); compositeLink.PrintingSystemBase = printingSystem; var link1 = new PrintableComponentLinkBase(); link1.Component = gcTotal; //link1.PaperName = gcTotal.Tag.ToString(); var link2 = new PrintableComponentLinkBase(); link2.Component = gcDetail; //link2.PaperName = gcDetail.Tag.ToString(); var link3 = new PrintableComponentLinkBase(); link3.Component = gcCandidate; //link3.PaperName = gcCandidate.Tag.ToString(); compositeLink.Links.Add(link1); compositeLink.Links.Add(link2); compositeLink.Links.Add(link3); var options = new XlsxExportOptions(); options.ExportMode = XlsxExportMode.SingleFilePageByPage; compositeLink.CreatePageForEachLink(); compositeLink.ExportToXlsx(_with1.FileName, options); string strexcelversion = Functions.GetOfficeVersion(); if (int.Parse(strexcelversion) >= 2007) { Microsoft.Office.Interop.Excel.Application exc = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook workbook = exc.Workbooks.Open(_with1.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); Microsoft.Office.Interop.Excel.Sheets sheets = workbook.Worksheets; Microsoft.Office.Interop.Excel.Worksheet sheet1 = (Microsoft.Office.Interop.Excel.Worksheet)(sheets[1]); Microsoft.Office.Interop.Excel.Worksheet sheet2 = (Microsoft.Office.Interop.Excel.Worksheet)(sheets[2]); Microsoft.Office.Interop.Excel.Worksheet sheet3 = (Microsoft.Office.Interop.Excel.Worksheet)(sheets[3]); sheet1.Name = gcTotal.Tag.ToString(); sheet2.Name = gcDetail.Tag.ToString(); sheet3.Name = gcCandidate.Tag.ToString(); workbook.Close(true, Type.Missing, Type.Missing); exc.Quit(); } //System.Diagnostics.Process.Start(_with1.FileName); DialogResult = XtraMessageBox.Show("Do you want to open this file?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); if (DialogResult == DialogResult.Yes) { System.Diagnostics.Process.Start(_with1.FileName); } else { XtraMessageBox.Show("Export Succeeded!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { XtraMessageBox.Show("Could not export to excel file." + Environment.NewLine + ex.Message.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }