开发：单元格区域的操作（读取、赋值、边框和格式）

基于.NET的Excel开发：单元格区域的操作（读取、赋值、边框和格式）引用using Excel = Microsoft.Office.Interop.Excel;

定义1 Excel.applicationClass app;2 Excel.Workbooks books;3 Excel.Workbook book;4 Excel.Sheets sheets;5 Excel.Worksheet sheet;6 Excel.Range m_objRange;7 object missing = System.Reflection.Missing.Value;

读取有效单元格区域 1 foreach (Excel.Worksheet sheet in book.Sheets) 2 { 3 for (int i = 1; i <= sheet.UsedRange.Cells.Rows.Count; i++) 4 { 5 for (int j = 1; j <= sheet.UsedRange.Cells.Columns.Count; j++) 6 { 7 Excel.Range m_objRange = (Excel.Range)sheet.Cells[i, j]; 8 } 9 }10 }

单元格区域赋值1 m_objRange = sheet .get_Range("A1"，missing ); 2 m_objRange.set_Value(missing , "单元格的值");

单元格区域设置Excel公式1 m_objRange = sheet .get_Range("A1", missing ); 2 m_objRange.set_Value(missing , "=SUM(A2:A5)");

字体加粗1 m_objRange.Font.Bold = true;

设置数字格式1 //保留2位小数2 m_objRange.NumberFormat = "0.00";

设置边框1 m_objRange = sheet .get_Range("A1", "B2");2 //设置边框粗细3 m_objRange.Borders.Weight = 2;4 //设置边框样式5 m_objRange.Borders.get_Item(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlDouble;

XlLineStyle枚举xlContinuous ：实线。xlDash ：虚线。xlDashDot：点划相间线。xlDashDotDot：划线后跟两个点。xlDot ：点线。xlDouble：双线。xlLineStyleNone：无线条。xlSlantDashDot ：倾斜的划线。XlBordersIndex枚举xlDiagonalDown：对角线，从左上角到右下角。xlDiagonalUp：对角线，从左上角到右下角。xlEdgeBottom：底部边框。xlEdgeLeft：左部边框。xlEdgeRight：右部边框。xlEdgeTop：顶部边框。xlInsideHorizontal：内部水平边框。xlInsideVertical Vertical：内部垂直边框。