MESCIUS SPREAD for Windows Forms 17.0J
ExcelExportFormat プロパティ (GcDateTimeCellType)

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

プロパティ値

Excel エクスポート書式。
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 メンバ

 

 


© MESCIUS inc. All rights reserved.