SetExcelGroupFormatSettings メソッド

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

シンタックス

Visual Basic

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

C#

public static void SetExcelGroupFormatSettings( 
   DependencyObject d,
   FormatSettings value
)

パラメータ

d

value

使用例

Visual Basic

Dim groupFormatSettings As New FormatSettings() 
groupFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double
groupFormatSettings.BottomBorderColor = Colors.Red 
groupFormatSettings.FontStrikeout = Infragistics.Excel.ExcelDefaultableBoolean.True
groupFormatSettings.FontStyle = FontStyles.Italic 
groupFormatSettings.FontUnderlineStyle = Infragistics.Excel.FontUnderlineStyle.Double
groupFormatSettings.LeftBorderColor = Colors.Green 
groupFormatSettings.RightBorderColor = Colors.Blue 
groupFormatSettings.TopBorderColor = Colors.Purple 
groupFormatSettings.VerticalAlignment = Infragistics.Excel.VerticalCellAlignment.Center 

DataPresenterExcelExporter.SetExcelGroupFormatSettings(Me.Grid.FieldSettings, groupFormatSettings)

C#

FormatSettings groupFormatSettings = new FormatSettings();
groupFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double;
groupFormatSettings.BottomBorderColor = Colors.Red;
groupFormatSettings.FontStrikeout = Infragistics.Excel.ExcelDefaultableBoolean.True;
groupFormatSettings.FontStyle = FontStyles.Italic;
groupFormatSettings.FontUnderlineStyle = Infragistics.Excel.FontUnderlineStyle.Double;
groupFormatSettings.LeftBorderColor = Colors.Green;
groupFormatSettings.RightBorderColor = Colors.Blue;
groupFormatSettings.TopBorderColor = Colors.Purple;
groupFormatSettings.VerticalAlignment = Infragistics.Excel.VerticalCellAlignment.Center;

DataPresenterExcelExporter.SetExcelGroupFormatSettings(this.Grid.FieldSettings, groupFormatSettings);

XAML

<igDP:XamDataGrid.FieldSettings>
    <igDP:FieldSettings>
        <igExcelExporter:DataPresenterExcelExporter.ExcelGroupFormatSettings>
            <igExcelExporter:FormatSettings 
                BorderStyle="Double"
                BottomBorderColor="Red"
                FontStrikeout="True"
                FontStyle="Italic"
                FontUnderlineStyle="Double"
                LeftBorderColor="Green"
                RightBorderColor="Blue"
                TopBorderColor="Purple"
                VerticalAlignment="Center" />            
        </igExcelExporter:DataPresenterExcelExporter.ExcelGroupFormatSettings>
    </igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>