ExcelFormatOptions Class

  • Article

Provides properties for retrieving and setting options when exporting to Excel.

Namespace CrystalDecisions.Shared Assembly CrystalDecisions.Shared (CrystalDecisions.Shared.dll)

Syntax

'Declaration
Public Class ExcelFormatOptions
    Inherits ExportFormatOptions
    Implements ICloneable

public class ExcelFormatOptions : ExportFormatOptions, ICloneable

Example

This example shows how to export the report document as a Microsoft Excel file.

'Declaration

    Private Sub ExportReportInExcel(ByVal reportDocument As ReportDocument, _
      ByVal fromPage As Integer, ByVal toPage As Integer)
      Dim myExportOpts As New ExportOptions
      myExportOpts.ExportFormatType = ExportFormatType.Excel
      Dim myExportFormatOptions As ExcelFormatOptions = _
      ExportOptions.CreateExcelFormatOptions()
      myExportFormatOptions.ConvertDateValuesToString = True
      myExportFormatOptions.ExcelAreaGroupNumber = 1
      myExportFormatOptions.ExcelAreaType = AreaSectionKind.Detail
      myExportFormatOptions.ExcelConstantColumnWidth = 9.5
      myExportFormatOptions.ExcelTabHasColumnHeadings = True
      myExportFormatOptions.ExcelUseConstantColumnWidth = True
      myExportFormatOptions.ExportPageBreaksForEachPage = True
      myExportFormatOptions.ExportPageHeadersAndFooters = ExportPageAreaKind.OnEachPage
      myExportFormatOptions.FirstPageNumber = fromPage
      myExportFormatOptions.LastPageNumber = toPage
      myExportFormatOptions.ShowGridLines = True
      myExportFormatOptions.UsePageRange = True
      myExportOpts.ExportFormatOptions = myExportFormatOptions
      reportDocument.Export(myExportOpts)
    End Sub

    private void ExportReportInExcel (ReportDocument reportDocument, int fromPage, int toPage)
    {
      ExportOptions exportOpts = new ExportOptions();
      exportOpts.ExportFormatType = ExportFormatType.Excel;
      ExcelFormatOptions exportFormatOptions = ExportOptions.CreateExcelFormatOptions();
      exportFormatOptions.ConvertDateValuesToString = true;
      exportFormatOptions.ExcelAreaGroupNumber = 1;
      exportFormatOptions.ExcelAreaType = AreaSectionKind.Detail;
      exportFormatOptions.ExcelConstantColumnWidth = 9.5;
      exportFormatOptions.ExcelTabHasColumnHeadings = true;
      exportFormatOptions.ExcelUseConstantColumnWidth = true;
      exportFormatOptions.ExportPageBreaksForEachPage = true;
      exportFormatOptions.ExportPageHeadersAndFooters = ExportPageAreaKind.OnEachPage;
      exportFormatOptions.FirstPageNumber = fromPage;
      exportFormatOptions.LastPageNumber = toPage;
      exportFormatOptions.UsePageRange = true;
      exportOpts.ExportFormatOptions = exportFormatOptions;
      reportDocument.Export(exportOpts);
    }

Inheritance Hierarchy

Object
   ExportFormatOptions
      ExcelFormatOptions

Version Information

Crystal Reports Basic for Visual Studio 2008

Supported since: Crystal Reports for Visual Studio .NET 2002

See Also

Reference

ExcelFormatOptions Members
CrystalDecisions.Shared Namespace