ExcelLabelFormatSettingsProperty フィールド

ラベルのエクスポートに関連するさまざまな設定をこれらのキーを使用するために使用される ExcelLabelFormatSettings プロパティを識別します。

シンタックス

Visual Basic

'宣言
 
Public Shared ReadOnly ExcelLabelFormatSettingsProperty As DependencyProperty

C#

public static readonly DependencyProperty ExcelLabelFormatSettingsProperty

使用例

Visual Basic

Dim labelFormatSettings As New FormatSettings() 
labelFormatSettings.BorderColor = Colors.Blue 
labelFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double
labelFormatSettings.FillPattern = Infragistics.Excel.FillPatternStyle.DiagonalStripe
labelFormatSettings.FillPatternForegroundColor = Colors.White 
labelFormatSettings.FillPatternBackgroundColor = Colors.Black 
labelFormatSettings.FontColor = Colors.Red 
labelFormatSettings.FontFamily = New FontFamily("Times New Roman") 
labelFormatSettings.FontSize = New Infragistics.Windows.DeviceUnitLength(14, Infragistics.Windows.DeviceUnitType.Point) 
labelFormatSettings.FontWeight = FontWeights.Bold 
labelFormatSettings.HorizontalAlignment = Infragistics.Excel.HorizontalCellAlignment.Center 

DataPresenterExcelExporter.SetExcelLabelFormatSettings(Me.Grid.FieldSettings, labelFormatSettings)

C#

FormatSettings labelFormatSettings = new FormatSettings();
labelFormatSettings.BorderColor = Colors.Blue;
labelFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double;
labelFormatSettings.FillPattern = Infragistics.Excel.FillPatternStyle.DiagonalStripe;
labelFormatSettings.FillPatternForegroundColor = Colors.White;
labelFormatSettings.FillPatternBackgroundColor = Colors.Black;
labelFormatSettings.FontColor = Colors.Red;
labelFormatSettings.FontFamily = new FontFamily("Times New Roman");
labelFormatSettings.FontSize = new Infragistics.Windows.DeviceUnitLength(14, Infragistics.Windows.DeviceUnitType.Point);
labelFormatSettings.FontWeight = FontWeights.Bold;
labelFormatSettings.HorizontalAlignment = Infragistics.Excel.HorizontalCellAlignment.Center;

DataPresenterExcelExporter.SetExcelLabelFormatSettings(this.Grid.FieldSettings, labelFormatSettings);

XAML

<igDP:XamDataGrid.FieldSettings>
    <igDP:FieldSettings>
        <igExcelExporter:DataPresenterExcelExporter.ExcelLabelFormatSettings>
            <igExcelExporter:FormatSettings 
                BorderColor="Blue"
                BorderStyle="Double"
                FillPatternForegroundColor="White" 
                FillPatternBackgroundColor="Black"
                FillPattern="DiagonalStripe"
                FontColor="Red"
                FontFamily="Times New Roman"
                FontWeight="Bold"
                HorizontalAlignment="Center">
                <igExcelExporter:FormatSettings.FontSize>
                    <igWindows:DeviceUnitLength UnitType="Point" Value="14" />
                </igExcelExporter:FormatSettings.FontSize>
            </igExcelExporter:FormatSettings>
        </igExcelExporter:DataPresenterExcelExporter.ExcelLabelFormatSettings>
    </igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>