Classe ExcelFormatOptions
Fornisce le proprietà per il recupero e l'impostazione delle opzioni durante l'esportazione in Excel.
Per un elenco di tutti i membri di questo tipo, vedere Membri ExcelFormatOptions.
ExcelFormatOptions
[Visual Basic]
Public Class ExcelFormatOptions
[C#]
public class ExcelFormatOptions
[C++]
__gc public class ExcelFormatOptions
[VJ#]
public class ExcelFormatOptions
Esempio
Nel seguente esempio viene illustrato l'utilizzo della classe ExcelFormatOptions.
[Visual Basic]
Private Sub ExportToExcel(ByVal fileName As String, ByVal _
hasColumnHeaders As Boolean, ByVal columnWidth As Double)
Dim excelFormatOpts As New ExcelFormatOptions()
Dim diskOpts As New DiskFileDestinationOptions()
' Imposta le opzioni relative al formato Excel.
excelFormatOpts.ExcelTabHasColumnHeadings = True
excelFormatOpts.ExcelUseConstantColumnWidth = hasColumnHeaders
excelFormatOpts.ExcelConstantColumnWidth = columnWidth
Report.ExportOptions.ExportFormatType = ExportFormatType.Excel
Report.ExportOptions.FormatOptions = excelFormatOpts
' Imposta le opzioni e l'esportazione del file del disco.
Report.ExportOptions.ExportDestinationType = _
ExportDestinationType.DiskFile
diskOpts.DiskFileName = fileName
Report.ExportOptions.DestinationOptions = diskOpts
Report.Export()
End Sub
[C#]
private void ExportToExcel (string fileName, bool hasColumnHeaders, double columnWidth)
{
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions
();
DiskFileDestinationOptions diskOpts = new
DiskFileDestinationOptions();
// Imposta le opzioni relative al formato Excel.
excelFormatOpts.ExcelTabHasColumnHeadings = true;
excelFormatOpts.ExcelUseConstantColumnWidth =
hasColumnHeaders;
excelFormatOpts.ExcelConstantColumnWidth = columnWidth;
Report.ExportOptions.ExportFormatType =
ExportFormatType.Excel;
Report.ExportOptions.FormatOptions = excelFormatOpts;
// Imposta le opzioni e l'esportazione del file del disco.
Report.ExportOptions.ExportDestinationType =
ExportDestinationType.DiskFile;
diskOpts.DiskFileName = fileName;
Report.ExportOptions.DestinationOptions = diskOpts;
Report.Export ();
}
[C++]
static void ExportToExcel (String* fileName, bool hasColumnHeaders, double columnWidth)
{
ExcelFormatOptions* excelFormatOpts =
new ExcelFormatOptions ();
DiskFileDestinationOptions* diskOpts = new
DiskFileDestinationOptions();
// Imposta le opzioni relative al formato Excel.
excelFormatOpts->ExcelTabHasColumnHeadings = true;
excelFormatOpts->ExcelUseConstantColumnWidth =
hasColumnHeaders;
excelFormatOpts->ExcelConstantColumnWidth = columnWidth;
Report->ExportOptions->ExportFormatType =
ExportFormatType::Excel;
Report->ExportOptions->FormatOptions = excelFormatOpts;
// Imposta le opzioni e l'esportazione del file del disco.
Report->ExportOptions->ExportDestinationType =
ExportDestinationType::DiskFile;
diskOpts->DiskFileName = fileName;
Report->ExportOptions->DestinationOptions = diskOpts;
Report->Export ();
};
[VJ#]
private void ExportToExcel (String fileName, boolean hasColumnHeaders, double columnWidth)
{
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions
();
DiskFileDestinationOptions diskOpts = new
DiskFileDestinationOptions();
// Imposta le opzioni relative al formato Excel.
excelFormatOpts.set_ExcelTabHasColumnHeadings(true);
excelFormatOpts.set_ExcelUseConstantColumnWidth(
hasColumnHeaders);
excelFormatOpts.set_ExcelConstantColumnWidth(columnWidth);
Report.get_ExportOptions().set_ExportFormatType(
ExportFormatType.Excel);
Report.get_ExportOptions().set_FormatOptions( excelFormatOpts);
// Imposta le opzioni e l'esportazione del file del disco.
Report.get_ExportOptions().set_ExportDestinationType(
ExportDestinationType.DiskFile);
diskOpts.set_DiskFileName(fileName);
Report.get_ExportOptions().set_DestinationOptions( diskOpts);
Report.Export ();
}
Requisiti
Spazio dei nomi: CrystalDecisions.Shared
Piattaforme: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP
Assemblaggio: CrystalDecisions.Shared (in CrystalDecisions.Shared.dll)
Vedere anche
Membri ExcelFormatOptions | Spazio dei nomi CrystalDecisions.Shared