怎样用程序给excel表格中加边框

Question

int rowIndex=3;//行起始坐标
int colIndex=2;//列起始坐标 ApplicationClass myApp=null;
Workbook myBook=null;
Worksheet mySheet=null;//
//绘制边框
//
mySheet.get_Range(mySheet.Cells[4,colSum],mySheet.Cells[rowSum,colIndex]).Borders.LineStyle = 1;
//mySheet.get_Range(mySheet.Cells[4,colSum],mySheet.Cells[rowSum,2]).Borders[XlBordersIndex.xlEdgeLeft].Weight = XlBorderWeight.xlThick;//设置左边线加粗
//mySheet.get_Range(mySheet.Cells[4,colSum],mySheet.Cells[4,colIndex]).Borders[XlBordersIndex.xlEdgeTop].Weight = XlBorderWeight.xlThick;//设置上边线加粗
//mySheet.get_Range(mySheet.Cells[4,colIndex],mySheet.Cells[rowSum,colIndex]).Borders[XlBordersIndex.xlEdgeRight].Weight = XlBorderWeight.xlThick;//设置右边线加粗
//mySheet.get_Range(mySheet.Cells[rowSum,colSum],mySheet.Cells[rowSum,colIndex]).Borders[XlBordersIndex.xlEdgeBottom].Weight = XlBorderWeight.xlThick;//设置下边线加粗