ASP.NET

public DataTable ReadingDatafromExcel()
    {
        DataTable dt = new DataTable();
        try
        {
            //Reading Data from Excel file to Data Table
            string FilePath = System.AppDomain.CurrentDomain.BaseDirectory.ToString();
            string _filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
            string _attachpath = FileUpload1.PostedFile.FileName;
            string _fileexten = Path.GetExtension(FileUpload1.PostedFile.FileName);

            string strConn = "";

            if (_fileexten == ".xls")
            {
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                          "Data Source=" + _attachpath + ";" +
                          "Extended Properties=Excel 8.0;";
            }
            else if (_fileexten == ".xlsx")
            {
                strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" +
                          "Data Source=" + _attachpath + ";" +
                          "Extended Properties=Excel 12.0;";
            }

            OleDbConnection oledbconn = new OleDbConnection(strConn);
            oledbconn.Close();
            oledbconn.Open();
            //You must use the $ after the object you reference in the spreadsheet
            OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", oledbconn);

            DataSet myDataSet = new DataSet();
            

            myCommand.Fill(myDataSet, "ExcelInfo");
            dt = myDataSet.Tables[0];
            oledbconn.Close();
            myCommand.Dispose();

            //Adding Columns to Data table

            DataColumn dcGender = new DataColumn("Gender", System.Type.GetType("System.String"));
            dt.Columns.Add(dcGender);

            DataColumn dcCulture = new DataColumn("Culture", System.Type.GetType("System.String"));
            dt.Columns.Add(dcCulture);
            
        }
        catch (Exception dataex)
        {
            Response.Write("Excel Excep:" + dataex.Message.ToString());
        }
        return dt;
    }

Yifei Jia wrote:

Console.WriteLine("Changed: {1}", e.FullPath);