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);
}
}
}
}
