CodeKicks.com
Focus on Microsoft Technologies - Tutorials, Articles, Code Samples.

Thursday, September 14, 2006

.NET code for Excel Border setting

Excel.Border topBdr=range.Borders[Excel.XlBordersIndex.xlEdgeTop];
Excel.Border bottomBdr=range.Borders[Excel.XlBordersIndex.xlEdgeBottom];
Excel.Border leftBdr=range.Borders[Excel.XlBordersIndex.xlEdgeLeft];
Excel.Border rightBdr=range.Borders[Excel.XlBordersIndex.xlEdgeRight];

topBdr=Excel.XlLineStyle.xlContinuous;
bottomBdr=Excel.XlLineStyle.xlContinuous;
leftBdr=Excel.XlLineStyle.xlContinuous;
rightBdr=Excel.XlLineStyle.xlContinuous;

Post a Comment

Mintu said...

Thanks Microsoft Team for this tip.