Esempi in PHP per Spreadsheet_Excel_Reader::dump_csv

Esempio n. 1

File: common_helper.php Progetto: bantyroy/acs_dev_prj

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;
    }
}