读写Excel的工具类

首先需要在项目中添加引用，COM->Microsoft Excel 12.0 Object Library

然后需要在头文件中添加引用：

using Microsoft.Office.Interop.Excel;
using Microsoft.Office.Core;

之后就可以来对Excel进行操作了。下面是作者写的一个类，专门用来写Excel的(读未测试)。需要注意的是写的时候写单个单元格速度比写一行或多行慢很多(部分代码参考了网上的一些例子)。

class ExcelTools:IDisposable { Application xlsApplication; Workbooks xlsWorkbooks; Workbook xlsBook; //工作簿 Worksheet xlsSheet; //工作单 string resultFile; //最终文件 public ExcelTools() { xlsApplication = new Application(); // 创建excel应用程序对象 xlsWorkbooks = xlsApplication.Workbooks; } //创建Excel表单文件 public void createExcelFile(string fileInfo) { resultFile = fileInfo; xlsBook = xlsWorkbooks.Add(XlWBATemplate.xlWBATWorksheet); } //保存表单文件 public void saveFile() { ExcelInterface.SaveWorkbookAs(xlsBook, resultFile); ExcelInterface.CloseWorkbook(xlsBook,true); xlsApplication.Quit(); } //写表单单元格 public void writeSheetSingleCell(string sheetNumber,int rowIndex,int colIndex,object objectToWrite) { xlsSheet = (Worksheet)xlsBook.Sheets[sheetNumber]; ExcelInterface.WriteToCell(xlsSheet, rowIndex, colIndex, objectToWrite); xlsSheet.Columns.AutoFit(); } //写表单一行，速度快 public void writeSheetRow(string sheetNumber, int startRow, int startCol, int endCol,object[] objectsToWrite) { xlsSheet = (Worksheet)xlsBook.Sheets[sheetNumber]; Range range = xlsSheet.get_Range(xlsSheet.Cells[startRow, startCol], xlsSheet.Cells[startRow, endCol]); range.Value2 = objectsToWrite; } public void Dispose() { xlsBook = null; xlsSheet = null; xlsWorkbooks = null; xlsApplication = null; } } //Excel操作接口类 static class ExcelInterface { //功能：读取单元格的整型值 //输入：xlsSheet = 工作表 //rowIndex = 单元格行索引 //colIdenx = 单元格列索引 //返回单元格的整型值 public static int ReadInt(Worksheet xlsSheet, int rowIndex, int colIndex) { Range range = (Range)xlsSheet.Cells[rowIndex, colIndex]; int data = int.Parse((range.Value2).ToString()); return data; } //功能：读取单元格的单精度浮点数值 //输入：xlsSheet = 工作表 //rowIndex = 单元格行索引 //colIdenx = 单元格列索引 //返回单元格的单精度浮点值 public static float ReadFloat(Worksheet xlsSheet, int rowIndex, int colIndex) { Range range = (Range)xlsSheet.Cells[rowIndex, colIndex]; float data = float.Parse((range.Value2).ToString()); return data; } //功能：读取单元格的/双精度浮点数值 //输入：xlsSheet = 工作表 //rowIndex = 单元格行索引 //colIdenx = 单元格列索引 //返回单元格的双精度浮点值 public static double ReadDouble(Worksheet xlsSheet, int rowIndex, int colIndex) { Range range = (Range)xlsSheet.Cells[rowIndex, colIndex]; double data = double.Parse((range.Value2).ToString()); return data; } //功能：将对象信息写入Excel单元格中 //输入：xlsSheet = 工作表 //rowIndex = 单元格行索引 //colIdenx = 单元格列索引 //objectToWrite = 要写入的对象 public static void WriteToCell(Worksheet xlsSheet, int rowIndex, int colIndex, object objectToWrite) { Range range = (Range)xlsSheet.Cells[rowIndex, colIndex]; range.Value2 = objectToWrite; } //功能：打开工作簿 //输入：xlsWorkbooks = 工作簿集合对象 //fileDirectory = 工作簿文件路径 //readOnly = 以只读方式打开 //返回工作簿对象 public static Workbook OpenWorkbook(Workbooks xlsWorkbbooks, string fileDirectory, bool readOnly) { Workbook xlsBook = null; try { xlsBook = xlsWorkbbooks.Open(fileDirectory, Type.Missing, readOnly, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } catch (System.Exception e) { throw e; } return xlsBook; } //功能：保存工作簿 //输入：xlsWorkbook = 工作簿对象 //fileDirectory = 保存路径 public static void SaveWorkbookAs(Workbook xlsWorkbook, string fileDirectory) { xlsWorkbook.SaveAs(fileDirectory, XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } //功能：关闭工作簿 // //xlsWorkBook = 工作簿对象 //saveChanges = 保存对工作簿的修改 public static void CloseWorkbook(Workbook xlsWorkbook, bool saveChanges) { xlsWorkbook.Close(saveChanges, Type.Missing, Type.Missing); } }