最近开发项目中，涉及到通过c#，向Excel中读取数据、插入图片、读取时间等操作。经过查找网上资料，终于完成相关操作，现将代码粘贴出来：
1 public class ExcelControl:ConvertObject 2 { 3 //Fields 4 private _Workbook _objBook=null ; 5 private Application _objExcel=null ; 6 private object _objOpt=Missing.Value ; 7 private Range _objRange=null ; 8 private _Worksheet _objWorkSheet=null ; 9 private Sheets _objSheets=null ; 10 private string _savePath;//文件保存路径 11 private int _sheetIndex=1;//工作表的索引 12 private string _templatePath;//文件模板路径 13 14 15 16 //Properties 17 public string SavePath 18 { 19 get { return _savePath; } 20 set { _savePath = value; } 21 } 22 23 public int SheetIndex 24 { 25 get { return _sheetIndex; } 26 set { _sheetIndex = value; } 27 } 28 public string TemplatePath 29 { 30 get { return _templatePath; } 31 set { _templatePath = value; } 32 } 33 34 //Methods 35 36 public ExcelControl() 37 { 38 this._objExcel = new ApplicationClass(); 39 } 40 41 public void CellsAlignment(int startRow, int startColumn, int endRow, int endColumn, XlHAlign hAlign, XlVAlign vAlign) 42 { 43 Range range = this._objWorkSheet.get_Range(this._objWorkSheet.Cells[startRow, startColumn], this._objWorkSheet.Cells[endRow, endColumn]); 44 range.HorizontalAlignment = hAlign; 45 range.VerticalAlignment = vAlign; 46 } 47 48 public void CellsUnite(int startRow, int startColumn, int endRow, int endColumn) 49 { 50 this._objWorkSheet.get_Range(this._objWorkSheet.Cells[startRow, startColumn], this._objWorkSheet.Cells[endRow, endColumn]).MergeCells = true; 51 } 52 53 /// 54 /// 关闭excel 55 /// 56 public void Close() 57 { 58 try 59 { 60 this._objBook.Close(_objOpt, _objOpt, _objOpt); 61 this._objExcel.Workbooks.Close(); 62 this._objExcel.Quit(); 63 Marshal.ReleaseComObject(_objBook); 64 Marshal.ReleaseComObject(_objExcel); 65 this._objBook = null; 66 this._objExcel = null; 67 GC.Collect(); 68 } 69 catch(Exception ex) 70 { 71 ErrMessage = ex.Message; 72 } 73 } 74 75 /// 76 /// 获取excel中单元格数据 77 /// 78 /// 79 /// 95 /// 向excel中插入图片 96 /// 97 /// 图片名称 98 /// 左边宽度 99 /// 顶部宽度 100 /// 宽度 101 /// 高度 102 public void InsertPictures(string pictureName, int left, int top, int width, int height) 103 { 104 this._objWorkSheet.Shapes.AddPicture(pictureName, MsoTriState.msoFalse, MsoTriState.msoTrue, (float)left, (float)top, (float)width, (float)height); 105 } 106 107 public bool InsertRow(object rowID, object colunmID) 108 { 109 try 110 { 111 Range range = (Range)this._objWorkSheet.Cells[rowID, colunmID]; 112 range.Select(); 113 range.EntireRow.Insert(this._objOpt, this._objOpt); 114 return true; 115 } 116 catch (Exception) 117 { 118 return false; 119 } 120 } 121 122 /// 123 /// 打开excel 124 /// 125 /// 142 /// 打开模板 143 /// 144 /// 145 /// 163 /// 行自动适合宽度 164 /// 165 /// 166 public void RowAutoFit(int rowNum) 167 { 168 Range range = (Range)this._objWorkSheet.Rows[rowNum.ToString() + ":" + rowNum.ToString(), Type.Missing]; 169 range.EntireColumn.AutoFit(); 170 } 171 172 /// 173 /// 保存 174 /// 175 /// 191 /// 另存为 192 /// 193 /// 223 /// 工作表激活状态 224 /// 225 /// 241 /// 242 /// 243 /// 244 /// 261 /// 设置显示警告 262 /// 263 /// 264 public void SetDisplayAlerts(bool b) 265 { 266 this._objExcel.DisplayAlerts = b; 267 } 268 269 /// 270 /// 向excel中插入值 271 /// 272 /// 插入位置 273 /// 插入值 274 public void SetRange(object range, object newValue) 275 { 276 try 277 { 278 this._objRange = this._objWorkSheet.get_Range(range, this._objOpt); 279 this._objRange.Value2 = newValue; 280 } 281 catch (Exception ex) 282 { 283 this.ErrMessage = ex.Message; 284 } 285 } 286 287 /// 288 /// 获取excel中时间格式 289 /// 290 /// 291 /// 本人能力有限，如有错误，望大家指正。