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)
See Also

Reference

XlsExport Class
XlsExport Members

 

 


Copyright © 2016 GrapeCity, inc. All rights reserved

Support Forum