function upload_data_from_file($name, $UploadDir) { $CI =& get_instance(); $def_val = "value not inserted"; $ext = getExtension($name); if ($ext == '.xls') { require_once 'excel_reader2.php'; $pathToFile = $UploadDir . $name; $data = new Spreadsheet_Excel_Reader($pathToFile); $worksheet = $data->dump_csv($row_numbers = false, $col_letters = false, $sheet = 0, $table_class = 'excel'); $row = 0; if (!empty($worksheet)) { $number_of_column = count($worksheet[0]); $all_keys = array(); $final_array = array(); foreach ($worksheet as $key => $row) { for ($i = 0; $i < $number_of_column; $i++) { $final_array[$key][$i] = base64_decode($row[$i]) == '' ? 'value not inserted' : base64_decode($row[$i]); } } } //pr($final_array,1); return $final_array; } elseif ($ext == '.csv') { $ret = array(); $info = fopen($UploadDir . $name, "r"); $i_cnt = 0; $row = 0; while (($values = fgetcsv($info)) !== false) { $ret[] = $values; } return $ret; } else { return FALSE; } }