ActiveReports 9
OpenXmlStandard Property (XlsExport)
Example 

Gets or sets the level of Open XML document conformance on exporting with Xlsx file format.
Syntax
'Declaration
 
Public Property OpenXmlStandard As OpenXmlStandard
public OpenXmlStandard OpenXmlStandard {get; set;}
Remarks
The Open XML SDK saves the xlsx document in Strict standard. Use this property to convert the xlsx file to the Transitional standard for applications that cannot read the xlsx file.
Example
SectionReport1 rpt = new SectionReport1();
GrapeCity.ActiveReports.Document.SectionDocument doc = new GrapeCity.ActiveReports.Document.SectionDocument();
doc.Pages.Add(new GrapeCity.ActiveReports.Document.Section.Page());
XlsExport export = new XlsExport();
export.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx;
export.OpenXmlStandard = GrapeCity.ActiveReports.Export.Excel.Section.OpenXmlStandard.Transitional;
Stream stream = new MemoryStream();
export.Export(rpt.Document, stream);
Dim rpt As New SectionReport1()
Dim doc As New GrapeCity.ActiveReports.Document.SectionDocument()
doc.Pages.Add(New GrapeCity.ActiveReports.Document.Section.Page())
Dim export As New XlsExport()
export.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx
export.OpenXmlStandard = GrapeCity.ActiveReports.Export.Excel.Section.OpenXmlStandard.Transitional
Dim stream As Stream = New MemoryStream()
export.Export(rpt.Document, stream)
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

XlsExport Class
XlsExport Members

 

 


Copyright © 2014 GrapeCity, inc. All rights reserved

Support Forum