///<summary>
/// 获取指定文件的指定单元格内容
///</summary>
/// <param
name="fileName">文件路径</param>
/// <param
name="row">行号</param>
/// <param
name="column">列号</param>
///
<returns>返回单元指定单元格内容</returns>
public string getExcelOneCell(string fileName,
int row, int column)
{
Microsoft.Office.Interop.Excel.Application app = new
Application();
Workbook
wbook = app.Workbooks.Open(fileName, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing);
Worksheet
workSheet = (Worksheet)wbook.Worksheets[1];
string
temp = ((Range)workSheet.Cells[row, column]).Text.ToString();
wbook.Close(false, fileName, false);
app.Quit();
NAR(app);
NAR(wbook);
NAR(workSheet);
return
temp;
}
//此函数用来释放对象的相关资源
private void NAR(Object o)
{
try
{
//使用此方法，来释放引用某些资源的基础 COM
对象。 这里的o就是要释放的对象
System.Runtime.InteropServices.Marshal.ReleaseComObject(o);
}
catch {
}
finally
{
o = null; GC.Collect();
}
}
加载中，请稍候......
喜欢
加载中…