专注于互联网--专注于架构

 最新标签
网站地图
文章索引
Rss订阅

首页 »DotNet » excel边框:excel选中范围的边框线型设置 因为多数边框线为实线故作为例 »正文

excel边框:excel选中范围的边框线型设置 因为多数边框线为实线故作为例

来源: 发布时间:星期三, 2009年4月1日 浏览:10次 评论:0
="t18">private _Workbook _workBook = null;
private Worksheet _workSheet = null;
private Worksheet _workSheet2 = null;
private Excel.Application _excelApplicatin = null;
private Excel.Chart _excelChart = null;

_excelApplicatin = Excel.Application;
_excelApplicatin.Visible = true;
_excelApplicatin.DisplayAlerts = true;
_workBook = _excelApplicatin.Workbooks.Add(XlSheetType.xlWorksheet);
_workSheet = (Worksheet)_workBook.ActiveSheet;
_workSheet.Name = "多数边框线为实线";
Excel.Range excelRange = _workSheet.get_Range(_workSheet.Cells[2, 2], _workSheet.Cells[6, 6]);
ExcelBorderLineStlye(excelRange,"Up","Bottom"," Left" "Right");

//excelRange :excel选中范围边框线型设置 多数边框线为实线
//NO :表示边框没有; "Up Bottom Left Right":表示线型为粗线 ;" "" "表示线型细线

private void ExcelBorderLineStlye(Range excelRange, Up, Bottom, Left, Right)
{
List<> borderWeightDivision = List<>;
borderWeightDivision.Add(Up);
borderWeightDivision.Add(Bottom);
borderWeightDivision.Add(Left);
borderWeightDivision.Add(Right);

for ( i = 0; i < borderWeightDivision.Count; i)
{
(borderWeightDivision[i].Length > 0)
{
(!borderWeightDivision[i].Equals("NO"))
{
switch (i)
{
//Top
0:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeTop).Weight = XlBorderWeight.xlMedium;
;
//Bottom
1:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeBottom).Weight = XlBorderWeight.xlMedium;
;
//"Left"
2:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeLeft).Weight = XlBorderWeight.xlMedium;
;
//"Right"
3:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeRight).Weight = XlBorderWeight.xlMedium;
;
}
}

{
switch (i)
{
//Top
0:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlLineStyleNone;
;
//Bottom
1:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle = XlLineStyle.xlLineStyleNone;
;
//"Left"
2:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle = XlLineStyle.xlLineStyleNone;
;
//"Right"
3:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle .xlLineStyleNone;
;
}
}
}

{
switch (i)
{
//Top
0:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeTop).Weight = XlBorderWeight.xlThin;
;
//Bottom
1:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeBottom).Weight = XlBorderWeight.xlThin;
;
//"Left"
2:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeLeft).Weight = XlBorderWeight.xlThin;
;
//"Right"
3:
excelRange.Borders.get_Item(XlBordersIndex.xlEdgeRight).Weight = XlBorderWeight.xlThin;
;
}
}
}
}
标签：excel不显示边框 excel边框颜色 excel表格边框 excel边框
0
我顶

相关文章

读者评论

发表评论

  • 昵称：
  • 内容：

热门标签

精华推荐

最新标签

Dig排行

阅读排行

最新文章