Excel文件操作

需要引用的库包括

Microsoft.Office.Interop.Excel
Microsoft.Office.Tools
Microsoft.Office.Tools.Common
Microsoft.Office.Tools.Excel
Microsoft.VisualStudio.Tools.Application.Runtime
Office

通常导入以下的namespace

using Microsoft.Office.Tools.Excel;
using Microsoft.VisualStudio.Tools.Applications.Runtime;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;

打开方式

try
{
	Excel.Application m_ExcelApplication = new Excel.Application();
	Excel.Workbook m_ExcelWorkbook = m_ExcelApplication.Workbooks.Open(txtBx_DataFileName.Text, miss, false,
                    miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss);
	Excel.Worksheet t_WorkSheet = m_ExcelWorkbook.Worksheets[1];
	/*
	 * 处理部分
	 */
	m_ExcelWorkbook.Close(ture, filename, miss);
	m_ExcelApplication.Quit();
}

单元格内容的操作方式,单元格做内容比较时将格式统一为String方便比较

t_WorkSheet.Cells[i, j].Value != null;
String.compare(t_WorkSheet.Cells[i, j].Value.ToString, "123");