본문 바로가기

Web_Application/C#

[fpspread][c#] HeaderColumns, Columns Border 라인 넣기



private ComplexBorderSide borderStyle;                                  //Thin line
private ComplexBorder complexBorder;                                    //ComplexBorder

borderStyle = new ComplexBorderSide(Color.Black, 1, DashStyle.Solid);        //Thin line
complexBorder = new ComplexBorder(null, null, borderStyle, null);

//헤더에 라인 넣기
sprList_Sheet1.ColumnHeader.Cells[0, 1].Border = complexBorder;
sprList_Sheet1.ColumnHeader.Cells[1, 17].Border = complexBorder;
sprList_Sheet1.ColumnHeader.Cells[2, 20].Border = complexBorder;

sprList_Sheet1.ColumnHeader.Cells[0, 21].Border = complexBorder;
sprList_Sheet1.ColumnHeader.Cells[1, 37].Border = complexBorder;
sprList_Sheet1.ColumnHeader.Cells[2, 40].Border = complexBorder;

//컬럼에 라인 넣기
sprList_Sheet1.Columns[20].Border = complexBorder;
sprList_Sheet1.Columns[40].Border = complexBorder;private ComplexBorderSide borderStyle;                                  //Thin line