asp.net中打开Excel上传文件,读取数据的方法

 
代码:
/// <summary>
    /// 打开Excel文件
    /// </summary>
    /// <param name="ExcelFileName">文件名</param>
    private void OpenExcelFile(string ExcelFileName)
    {
        Excel.Application App = new Excel.Application();
        if (App == null)
        {
            return;  //Excel尚未安装
        }
        Excel.Workbook workbook = App.Workbooks.Open(@ExcelFileName,
            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);
        CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
        try
        {
            App.Visible = false;
            App.DisplayAlerts = false;
            Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
            ProcessExcelData(workbook);
        }
        finally
        {
            App.