作成日: 2018/05/18 最終更新日: 2018/06/25
文書種別
使用方法
詳細
日付時刻型セル、GcDateTime型セルで日付を和暦表示にするには、それぞれ以下のように設定します。
【日付時刻型セルの和暦表示方法】
DateTimeCellTypeのCalendarプロパティにJapaneseCalendarを設定し、UserDefinedFormatプロパティに和暦のフォーマットを設定します。
◎サンプルコード(VB)
◎サンプルコード(C#)
【GcDateTime型セルの和暦表示方法】
GcDateTimeCellTypeのFiledsプロパティに対してAddRangeメソッドを使用して和暦のフォーマットを設定します。
◎サンプルコード(VB)
◎サンプルコード(C#)
【日付時刻型セルの和暦表示方法】
DateTimeCellTypeのCalendarプロパティにJapaneseCalendarを設定し、UserDefinedFormatプロパティに和暦のフォーマットを設定します。
◎サンプルコード(VB)
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' "平成"表示（平成XX年XX月XX日）
Dim dateCell1 As New FarPoint.Win.Spread.CellType.DateTimeCellType()
dateCell1.Calendar = New System.Globalization.JapaneseCalendar()
dateCell1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined
dateCell1.UserDefinedFormat = "ggyy年MM月dd日"
FpSpread1.ActiveSheet.Columns(0).CellType = dateCell1
FpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today)
' "平"表示（平XX年XX月XX日）
Dim dateCell2 As New FarPoint.Win.Spread.CellType.DateTimeCellType()
dateCell2.Calendar = New System.Globalization.JapaneseCalendar()
dateCell2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined
dateCell2.UserDefinedFormat = "gyy年MM月dd日"
FpSpread1.ActiveSheet.Columns(1).CellType = dateCell2
FpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today)
End Sub
' "平成"表示（平成XX年XX月XX日）
Dim dateCell1 As New FarPoint.Win.Spread.CellType.DateTimeCellType()
dateCell1.Calendar = New System.Globalization.JapaneseCalendar()
dateCell1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined
dateCell1.UserDefinedFormat = "ggyy年MM月dd日"
FpSpread1.ActiveSheet.Columns(0).CellType = dateCell1
FpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today)
' "平"表示（平XX年XX月XX日）
Dim dateCell2 As New FarPoint.Win.Spread.CellType.DateTimeCellType()
dateCell2.Calendar = New System.Globalization.JapaneseCalendar()
dateCell2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined
dateCell2.UserDefinedFormat = "gyy年MM月dd日"
FpSpread1.ActiveSheet.Columns(1).CellType = dateCell2
FpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today)
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// "平成"表示（平成XX年XX月XX日）
FarPoint.Win.Spread.CellType.DateTimeCellType dateCell1 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
dateCell1.Calendar = new System.Globalization.JapaneseCalendar();
dateCell1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
dateCell1.UserDefinedFormat = "ggyy年MM月dd日";
fpSpread1.ActiveSheet.Columns[0].CellType = dateCell1;
fpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today);
// "平"表示（平XX年XX月XX日）
FarPoint.Win.Spread.CellType.DateTimeCellType dateCell2 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
dateCell2.Calendar = new System.Globalization.JapaneseCalendar();
dateCell2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
dateCell2.UserDefinedFormat = "g.yy.MM.dd";
fpSpread1.ActiveSheet.Columns[1].CellType = dateCell2;
fpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today);
}
{
// "平成"表示（平成XX年XX月XX日）
FarPoint.Win.Spread.CellType.DateTimeCellType dateCell1 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
dateCell1.Calendar = new System.Globalization.JapaneseCalendar();
dateCell1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
dateCell1.UserDefinedFormat = "ggyy年MM月dd日";
fpSpread1.ActiveSheet.Columns[0].CellType = dateCell1;
fpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today);
// "平"表示（平XX年XX月XX日）
FarPoint.Win.Spread.CellType.DateTimeCellType dateCell2 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
dateCell2.Calendar = new System.Globalization.JapaneseCalendar();
dateCell2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
dateCell2.UserDefinedFormat = "g.yy.MM.dd";
fpSpread1.ActiveSheet.Columns[1].CellType = dateCell2;
fpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today);
}
【GcDateTime型セルの和暦表示方法】
GcDateTimeCellTypeのFiledsプロパティに対してAddRangeメソッドを使用して和暦のフォーマットを設定します。
◎サンプルコード(VB)
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' "平成"表示（平成XX年XX月XX日）
Dim gcdateCell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
gcdateCell1.Fields.Clear()
gcdateCell1.Fields.AddRange("gggee年MM月dd日") '平成
FpSpread1.ActiveSheet.Columns(0).CellType = gcdateCell1
FpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today)
' "平"表示（平XX年XX月XX日）
Dim gcdateCell2 As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
gcdateCell2.Fields.Clear()
gcdateCell2.Fields.AddRange("ggee年MM月dd") '平
FpSpread1.ActiveSheet.Columns(1).CellType = gcdateCell2
FpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today)
' "H"表示（HXX.XX.XX）
Dim gcdateCell3 As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
gcdateCell3.Fields.Clear()
gcdateCell3.Fields.AddRange("gee.MM.dd") 'H
FpSpread1.ActiveSheet.Columns(2).CellType = gcdateCell3
FpSpread1.ActiveSheet.SetValue(0, 2, DateTime.Today)
End Sub
' "平成"表示（平成XX年XX月XX日）
Dim gcdateCell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
gcdateCell1.Fields.Clear()
gcdateCell1.Fields.AddRange("gggee年MM月dd日") '平成
FpSpread1.ActiveSheet.Columns(0).CellType = gcdateCell1
FpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today)
' "平"表示（平XX年XX月XX日）
Dim gcdateCell2 As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
gcdateCell2.Fields.Clear()
gcdateCell2.Fields.AddRange("ggee年MM月dd") '平
FpSpread1.ActiveSheet.Columns(1).CellType = gcdateCell2
FpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today)
' "H"表示（HXX.XX.XX）
Dim gcdateCell3 As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
gcdateCell3.Fields.Clear()
gcdateCell3.Fields.AddRange("gee.MM.dd") 'H
FpSpread1.ActiveSheet.Columns(2).CellType = gcdateCell3
FpSpread1.ActiveSheet.SetValue(0, 2, DateTime.Today)
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// "平成"表示（平成XX年XX月XX日）
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType gcdateCell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
gcdateCell1.Fields.Clear();
gcdateCell1.Fields.AddRange("gggee年MM月dd日");
fpSpread1.ActiveSheet.Columns[0].CellType = gcdateCell1;
fpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today);
// "平"表示（平XX年XX月XX日）
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType gcdateCell2 = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
gcdateCell2.Fields.Clear();
gcdateCell2.Fields.AddRange("ggee年MM月dd日");
fpSpread1.ActiveSheet.Columns[1].CellType = gcdateCell2;
fpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today);
// "H"表示（HXX.XX.XX）
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType gcdateCell3 = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
gcdateCell3.Fields.Clear();
gcdateCell3.Fields.AddRange("gee.MM.dd");
fpSpread1.ActiveSheet.Columns[2].CellType = gcdateCell3;
fpSpread1.ActiveSheet.SetValue(0, 2, DateTime.Today);
}
{
// "平成"表示（平成XX年XX月XX日）
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType gcdateCell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
gcdateCell1.Fields.Clear();
gcdateCell1.Fields.AddRange("gggee年MM月dd日");
fpSpread1.ActiveSheet.Columns[0].CellType = gcdateCell1;
fpSpread1.ActiveSheet.SetValue(0, 0, DateTime.Today);
// "平"表示（平XX年XX月XX日）
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType gcdateCell2 = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
gcdateCell2.Fields.Clear();
gcdateCell2.Fields.AddRange("ggee年MM月dd日");
fpSpread1.ActiveSheet.Columns[1].CellType = gcdateCell2;
fpSpread1.ActiveSheet.SetValue(0, 1, DateTime.Today);
// "H"表示（HXX.XX.XX）
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType gcdateCell3 = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
gcdateCell3.Fields.Clear();
gcdateCell3.Fields.AddRange("gee.MM.dd");
fpSpread1.ActiveSheet.Columns[2].CellType = gcdateCell3;
fpSpread1.ActiveSheet.SetValue(0, 2, DateTime.Today);
}
関連情報
旧文書番号
82704