ExcelFormatStr プロパティ (InitializeColumnEventArgs)

Excel固有の書式文字列。

シンタックス

Visual Basic

'宣言
 
Public Property ExcelFormatStr As String

C#

public string ExcelFormatStr {get; set;}

使用例

Visual Basic

Private Sub MyGridExporter_InitializeColumn(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.InitializeColumnEventArgs) Handles MyGridExporter.InitializeColumn
    Select Case e.FrameworkFormatStr
        Case "##.##"
            e.ExcelFormatStr = "[<>0]##.##;[=0]\" \ ";"

        Case "hh:mm:ss"
            e.ExcelFormatStr = "m.d.yy h:mm;@"

        Case Else
            e.ExcelFormatStr = e.FrameworkFormatStr
    End Select
End Sub

C#

private void InitializeColumn_EH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.InitializeColumnEventArgs e)
{
	switch(e.FrameworkFormatStr)
	{
		case "##.##":
			e.ExcelFormatStr = "[<>0]##.##;[=0]\"\";";
			break;

		case "hh:mm:ss":
			e.ExcelFormatStr = "m.d.yy h:mm;@";
			break;

		default:
			e.ExcelFormatStr = e.FrameworkFormatStr;
			break;
	}
}