C#

"line of ... ers"

using Microsoft.Office.Core;

private void ReadExcelValue()
{
    object o = System.Reflection.Missing.Value;
 
    Excel.Application objE = new Excel.Application();
    Excel.Workbooks objBooks = null;
    Excel.Workbook objB = null;
    Excel.Worksheet objS = null;
 
    objE.Workbooks.Open(Server.MapPath("spreadsheet.xls"), o, o, o, o, o, o, o, o, o, o, o, o, o, o);
    objBooks = objE.Workbooks;
    objB = objBooks[(object)1];
 
    objS = (Excel.Worksheet)objB.Worksheets[(object)1];
 
    //write out the text in cell "A1"
    Response.Write(((Excel.Range)objS.Cells[1, 1]).Text);
 
    Release(objS);
 
    if (objB != null)
        objB.Close(false, o, o);
    Release(objB);
 
    if (objBooks != null)
        objBooks.Close();
    Release(objBooks);
 
    if (objE != null)
        objE.Quit();
    Release(objE);
 
    GC.Collect();
 
    System.Diagnostics.Process[] objPr = System.Diagnostics.Process.GetProcessesByName("Excel");
    foreach (System.Diagnostics.Process pr in objPr)
        pr.Kill();
}

private void Release(object obj)
{
    try
    {
        System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
    }
    catch { }
    finally
    {
        obj = null;
    }
}