使用的是DevExpress 15.1 的版本导出的是2007的xlsx格式的Excel
代码中使用的是CompositeLink类的ExportToXlsx()方法
你这么问我们怎么回答?最起码代码贴上
具体代码:
DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem()
DevExpress.XtraPrintingLinks.CompositeLink link = new DevExpress.XtraPrintingLinks.CompositeLink(ps);
ps.Links.add ( link );
link.Links.Add ( CreatePageForEachLink() );
link.Landscape= true;
DevExpress.XtraPrinting.XlsxExportOptions optio具体代码:
DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem()
DevExpress.XtraPrintingLinks.CompositeLink link = new DevExpress.XtraPrintingLinks.CompositeLink(ps);
ps.Links.add ( link );
link.Links.Add ( CreatePageForEachLink() );
link.Landscape= true;
DevExpress.XtraPrinting.XlsxExportOptions options = new DevExpress.XtraPrinting.XlsxExportOptions();
link.ExportToXlsx(FileName, options);
public PrintableComponentLink( IPrintable printable )
{
CharControl char printable as ChartaControl;
if ( chart !=null )
{
chart.OptionPrint.SizeMode = DevExpress.XtraCharts.Printing.PrintSizeMode.Stretch;
}
PrintableComponentLink printableLink = new PrintableComponentLink () { Component = printable };
return printableLink;
}ns = new DevExpress.XtraPrinting.XlsxExportOptions();
link.ExportToXlsx(FileName, options);
public PrintableComponentLink( IPrintable printable )
{
CharControl char printable as ChartaControl;
if ( chart !=null )
{
chart.OptionPrint.SizeMode = DevExpress.XtraCharts.Printing.PrintSizeMode.Stretch;
}
PrintableComponentLink printableLink = new PrintableComponentLink () { Component = printable };
return printableLink;
}