C# 给Excel添加边框，获取有效行数，然后添加边框

 //添加对单元格边框
                    int Rowcount = workSheet.UsedRange.CurrentRegion.Rows.Count;
                    Range range = workSheet.get_Range(workSheet.Cells[1, 1], workSheet.Cells[Rowcount,11]);//11指的是列数
                    range.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;