C操作EXCEL.docx

# Excel 行高,列宽,合并单元格,单元格边框线,冻结（转载） - 关于C#操作EXCLE常见操作比较全的网上看到的比较全的关于C#操作EXCEL常见操作集合，比较全，写的不错原文地址：/kjkj911/blog/item/0ecc3ec7855dd6d4d100600f.htmlprivate _Workbook _workBook = null;private Worksheet _workSheet = null;private Excel.Application _excelApplicatin = null;_excelApplicatin = new Excel.Application();_excelApplicatin.Visible = true;_excelApplicatin.DisplayAlerts = true;_workBook = _excelApplicatin.Workbooks.Add(XlSheetType.xlWorksheet);_workSheet = (Worksheet)_workBook.ActiveSheet;_workSheet.Name = "workSheetName";//打开已存在的Excel string strExcelPathName = AppDomain.CurrentDomain.BaseDirectory + "excelSheetName.xls"; Excel.Workbook workBook = application.Workbooks.Open(strExcelPathName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); //读取已打开的Excel Excel.Worksheet workSheet1 = (Excel.Worksheet)workBook.Sheets["SheetName1"]; Excel.Worksheet workSheet2 = (Excel.Worksheet)workBook.Sheets["SheetName2"]; //添加一个workSheet Worksheet workSheet = (Worksheet)workBook.Worksheets.Add(System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);//RowHeight "1:1"表示第一行, "1:2"表示,第一行和第二行 ((Excel.Range)_workSheet.Rows["1:1", System.Type.Missing]).RowHeight = 100;//ColumnWidth "A:B"表示第一列和第二列, "A:A"表示第一列((Excel.Range)_workSheet.Columns["A:B", System.Type.Missing]).ColumnWidth = 10;// EXCEL操作(需要冻结的字段 按住ALT+W 再按F) Excel.Range excelRange = _workSheet .get_Range(_workSheet .Cells[10, 5], _workSheet .Cells[10, 5]); excelRange.Select(); excelApplication.ActiveWindow.FreezePanes = true;//Borders.LineStyle 单元格边框线Excel.Range excelRange = _workSheet.get_Range(_workSheet.Cells[2, 2], _workSheet.Cells[4, 6]);//单元格边框线类型(线型,虚线型)excelRange.Borders.LineStyle = 1;excelRange.Borders.get_Item(XlBordersIndex.xlEdgeTop).Li