SetExcelCellFormatSettings メソッド

'ExcelCellFormatSettings' 添付プロパティの値を設定します。

シンタックス

Visual Basic

'宣言
 
Public Shared Sub SetExcelCellFormatSettings( _
   ByVal d As DependencyObject, _
   ByVal value As FormatSettings _
) 

C#

public static void SetExcelCellFormatSettings( 
   DependencyObject d,
   FormatSettings value
)

パラメータ

d

value

使用例

Visual Basic

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

DataPresenterExcelExporter.SetExcelCellFormatSettings(Me.Grid.FieldSettings, cellFormatSettings)

C#

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

DataPresenterExcelExporter.SetExcelCellFormatSettings(this.Grid.FieldSettings, cellFormatSettings);

XAML

<igDP:XamDataGrid.FieldSettings>
    <igDP:FieldSettings>
        <igExcelExporter:DataPresenterExcelExporter.ExcelCellFormatSettings>
            <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.ExcelCellFormatSettings>
    </igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>