ActiveReports 14
GrapeCity.ActiveReports.Export.Excel Assembly / GrapeCity.ActiveReports.Export.Excel.Section Namespace / XlsExport Class / FileFormat Property
Example

In This Topic
    FileFormat Property (XlsExport)
    In This Topic
    Sets or returns a value indicating which file format version the exported file should support.
    Syntax
    'Declaration
     
    Public Property FileFormat As FileFormat
    public FileFormat FileFormat {get; set;}

    Property Value

    FileFormat enumeration.  The default value is Xls97Plus.
    Example
    Dim docexp As New GrapeCity.ActiveReports.Export.Excel.Section.XlsExport()
    docexp.AutoRowHeight=True
    docexp.DisplayGridLines=True
    docexp.FileFormat=GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xls95 'Or Xls97Plus
    docexp.MinColumnWidth=3
    docexp.MinRowHeight=1
    docexp.MultiSheet=True
    docexp.RemoveVerticalSpace=True
    docexp.UseCellMerging=False
    docexp.Export(Me.viewer1.Document, Application.StartupPath + "\x.xls")
    GrapeCity.ActiveReports.Export.Excel.Section.XlsExport docexp = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
    docexp.AutoRowHeight = true;
    docexp.DisplayGridLines = true;
    docexp.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xls95; //or Xls97Plus or Xlsx
    docexp.MinColumnWidth = 3;
    docexp.MinRowHeight = 1;
    docexp.MultiSheet = true;
    docexp.RemoveVerticalSpace = true;
    docexp.UseCellMerging = false;
    docexp.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls");
    See Also