public DataSet getExcelData(string _file, string tablename) { DataTable dt = new DataTable(tablename); impData.Tables.Add(iobj.ConvertXLS(_file, dt)); return(impData); }
public int ImportHRAAUDITR(string _filepath, string _source, string _qy) { int _counter = 0; HRAImportDAL iobj = new HRAImportDAL(); HRAConvertExcel tObj = new HRAConvertExcel(); HRAParseData pObj = new HRAParseData(); DataSet ds = new DataSet(); ds.Clear(); DataTable dt = new DataTable("AUDITRTable"); iobj.Rollback(_source, _qy); ds.Tables.Add(tObj.ConvertXLS(_filepath, dt)); _counter = pObj.parseHRAAUDITR(ds, _qy); return(_counter); }