public class ExcelReader

    {

        private string filePath;

        private string fileName;

        private OleDbConnection conn;

        private DataTable readDataTable;

        private string connString;

        private FileType fileType = FileType.noset;



        public ExcelReader()

        {



        }



        private void SetFileInfo(string path)

        {

            filePath = path;



            fileName = this.filePath.Remove(0, this.filePath.LastIndexOf("\\") + 1);

            switch (fileName.Split('.')[1])

            {

                case "xls": connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'"; fileType = FileType.xls;

                    break;

                case "xlsx": connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'"; fileType = FileType.xlsx;

                    break;

                case "csv": connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath.Remove(filePath.LastIndexOf("\\") + 1) + ";Extended Properties='Text;FMT=Delimited;HDR=YES;IMEX=1;'"; fileType = FileType.csv;

                    break;

            }

        }





        public DataTable ReadFile(string path)

        {

            if (System.IO.File.Exists(path))

            {

                SetFileInfo(path);

                OleDbDataAdapter myCommand = null;

                DataSet