Postingan lainnya
saat upload file .xlsx eror respon File does not exist.
saya ada kendala, saat upload file format .xlsx responnya :
Error loading file "112435.xlsx": Could not open uploads/dokumen/impor/112435.xlsx for reading! File does not exist.
yang salah atau kekurangannya dimana ya?
sedangkan file masih ada, tidak dipindah dan dihapus.
berikut syntaxnya
public function impor_desainer($id_elemen) {
cek_login();
$this->load->view('konek');
$db = new mysqli(db_host, db_user, db_pass, db_name);
$nama = date('His');
mysqli_query($db, "DELETE FROM database_elemen WHERE id_dda='$id_elemen'");
$this->load->library(array('PHPExcel', 'PHPExcel/IOFactory'));
$fileName = time().$_FILES['dokumen']['name'];
$config['upload_path'] = 'uploads/dokumen/impor/';
$config['file_name'] = $nama.'.xlsx';
$config['allowed_types'] = 'xlsx';
$this->load->library('upload');
$this->upload->initialize($config);
if(! $this->upload->do_upload('dokumen') )
$this->upload->display_errors();
$media = $this->upload->data('dokumen');
$inputFileName = 'uploads/dokumen/impor/'.$nama.'.xlsx';
try {
$inputFileType = IOFactory::identify($inputFileName);
$objReader = IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch(Exception $e) {
die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
}
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
for ($row = 2; $row <= $highestRow; $row++) {
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
$data = array(
"kode1"=> $rowData[0][0],
"kode2"=> $rowData[0][1],
"kode3"=> $rowData[0][2],
"kode4"=> $rowData[0][3],
"kode5"=> $rowData[0][4],
"kode6"=> $rowData[0][5],
"kode7"=> $rowData[0][6],
"urutan"=> $rowData[0][7],
"teks"=> $rowData[0][8],
"satuan"=> $rowData[0][9],
"tampil"=> $rowData[0][10],
"tampil_dataku"=> $rowData[0][11]
);
$impor_id_dda = $id_elemen;
$impor_kode1 = $data['kode1'];
$impor_kode2 = $data['kode2'];
$impor_kode3 = $data['kode3'];
$impor_kode4 = $data['kode4'];
$impor_kode5 = $data['kode5'];
$impor_kode6 = $data['kode6'];
$impor_kode7 = $data['kode7'];
$impor_urutan = $data['urutan'];
$impor_teks = $data['teks'];
$impor_satuan = $data['satuan'];
$impor_tampil = $data['tampil'];
$impor_tampil_dataku = $data['tampil_dataku'];
$impor_create_at = date('Y-m-d H:i:s');
$impor_update_at = '0000-00-00 00:00:00';
mysqli_query($db, "INSERT INTO database_elemen SET id='', id_dda='$impor_id_dda', kode1='$impor_kode1', kode2='$impor_kode2', kode3='$impor_kode3', kode4='$impor_kode4', kode5='$impor_kode5', kode6='$impor_kode6', kode7='$impor_kode7', urutan='$impor_urutan', teks='$impor_teks', satuan='$impor_satuan', tampil='$impor_tampil', tampil_dataku='$impor_tampil_dataku', create_at='$impor_create_at', update_at='$impor_update_at'");
}
redirect(site_url('dda_dua/row_desainer/'.$id_elemen));
}
0
2 Jawaban:
<div>coba format mode nya harus bisa diread<br>cek tentang mengubah chmod</div>
0
Tanggapan
pakainya windows 10 mas. ngubah format modenya di codingnya maksudnya? apa gimana?
https://v2cloud.com/tutorials/how-to-change-folder-permissions-on-windows-2016
Jawaban Terpilih
<div>library ga support, jadi diganti. referensi https://github.com/PHPOffice/PhpSpreadsheet</div>
0