GrapeCity.ActiveReports.Export.Excel.v9 アセンブリ > GrapeCity.SpreadBuilder.Cells 名前空間 > DDCell クラス : BorderDiagonalStyle プロパティ |
'宣言 Public Property BorderDiagonalStyle As BorderLineStyle
public BorderLineStyle BorderDiagonalStyle {get; set;}
デフォルトは、BorderLineStyle.None(罫線なし)になります。
sb.Sheets[0].Cell(0,0).Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right; sb.Sheets[0].Cell(0,0).BorderBottomColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderDiagonalColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both; sb.Sheets[0].Cell(0,0).BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair; sb.Sheets[0].Cell(0,0).BorderLeftColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderRightColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderTopColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).FillColor = System.Drawing.Color.Gray; sb.Sheets[0].Cell(0,0).FontBold = true; sb.Sheets[0].Cell(0,0).FontItalic = true; sb.Sheets[0].Cell(0,0).FontName = "Times New Roman"; sb.Sheets[0].Cell(0,0).FontSize = 14; sb.Sheets[0].Cell(0,0).FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single; sb.Sheets[0].Cell(0,0).ForeColor = System.Drawing.Color.Blue; sb.Sheets[0].Cell(0,0).Hyperlink = "www.GrapeCity.com"; sb.Sheets[0].Cell(0,0).NumberFormat = "[$¥-0]#,##0.00"; sb.Sheets[0].Cell(0,0).TextAngle = 255; sb.Sheets[0].Cell(0,0).VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top; sb.Sheets[0].Cell(0,0).WrapText = true;
With sb.Sheets(0).Cell(0, 0) .Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right .BorderBottomColor = System.Drawing.Color.Red .BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .BorderDiagonalColor = System.Drawing.Color.Red .BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both .BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair .BorderLeftColor = System.Drawing.Color.Red .BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .BorderRightColor = System.Drawing.Color.Red .BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .BorderTopColor = System.Drawing.Color.Red .BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .FillColor = System.Drawing.Color.Gray .FontBold = True .FontItalic = True .FontName = "Times New Roman" .FontSize = 14 .FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single .ForeColor = System.Drawing.Color.Blue .Hyperlink = "www.GrapeCity.com" .NumberFormat = "[$¥-0]#,##0.00" .TextAngle = 255 .VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top .WrapText = True End With