PowerTools SPREAD for Windows Forms 10.0J
ExcelExportFormat プロパティ (GcDateTimeCellType)


Excel エクスポート書式を取得または設定します。
構文
'Declaration
 
Public Overrides Property ExcelExportFormat As String
'使用法
 
Dim instance As GcDateTimeCellType
Dim value As String
 
instance.ExcelExportFormat = value
 
value = instance.ExcelExportFormat
public override string ExcelExportFormat {get; set;}

プロパティ値

Excel エクスポート書式。
次のサンプルコードは、ExcelExportFormat プロパティを使用します。
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
datecell.FieldsEditMode = GrapeCity.Win.Spread.InputMan.CellType.FieldsEditMode.RightSide;
datecell.ExcelExportFormat = "MM/dd/yy";
fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell;

GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType textcell = new GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType();
textcell.AutoConvert = true;
textcell.FormatString = "A";
fpSpread1.Sheets[0].Cells[1, 1].CellType = textcell;
Dim datecell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
datecell.FieldsEditMode = GrapeCity.Win.Spread.InputMan.CellType.FieldsEditMode.RightSide
datecell.ExcelExportFormat = "MM/dd/yy"
FpSpread1.Sheets(0).Cells(0, 0).CellType = datecell

Dim textcell As New GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType()
textcell.AutoConvert = True
textcell.FormatString = "A"
FpSpread1.Sheets(0).Cells(1, 1).CellType = textcell
参照

GcDateTimeCellType クラス
GcDateTimeCellType メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.