How to read a single column in excel sheet using a specified column name?
<p>i want to read excel file please help me below code i tried please help me to pass excel values to array list.</p>

<pre><code>        Excel.Application excel = null;
        Excel.Workbook wkb = null;

        excel = new Excel.Application();
        wkb = ExcelTools.OfficeUtil.OpenBook(excel, fullPath);
        Excel.Worksheet sheet = wkb.Sheets["Data"] as Excel.Worksheet;
        Excel.Range range = null;

        if (sheet != null)
            range = sheet.get_Range("A1", Missing.Value);

        string A1 = String.Empty;

        if (range != null)
            A1 = range.Text.ToString();
</code></pre>
