Category : excel

I have an export function and when I die the results. It is { "outsourcer": "NS&C㈱", "manager_name": "安楽", "worker_name": "吉田邦広", "sesnum1": "MS-JAN-", "sesnum2": 1, "start": "2021/10/29", "work": "TEST作業1", "cost": 765000, "worktime_l": "140", "worktime_h": "180", "cost_add": 1000, "cost_trip": "7000", "cost_trip_terms": "泊数換算", "cost_midnight": 3000, "cost_reduced": 0, "end_date": "2022/03/31", "end": "2022/03/31", "quarter": "年度2022 1Q", "reserve1": "", "reserve2": "", ..

Read more

I have some post datas from another page. $xls = new Excel_XML; $xls->addWorksheet(‘Names’, $data); $xls->sendWorkbook(‘test.xls’); I export my excel file. $row[‘nmbr1’], -> Column A $row[‘nmbr2’], -> Column B $row[‘nmbr3’], _> Column C I want to change color some range. For example 60<nmbr1<80 is green. 150<nmbr2<200 is yellow like this not all columns. If number has ..

Read more

How to get data from multiple row in excel? Example on this excel i want get data from coloum kriteria 1 & kriteria 2 then save to table hasil "nilai_awal" Excel Example public function collection(Collection $rows) { foreach ($rows as $row) { Hasil::create([ ‘kriteria_id’ => $row[29], ‘alternatif_id’ => $row[30], ‘nilai_awal’ => $row[14], ” ]); } ..

Read more

I have installed the latest version of this library using Composer. I created a test file to test the library’s functionality, but when I try to parse a file and make a data array out of it, I get this error; Fatal error: Uncaught PhpOfficePhpSpreadsheetReaderException: Could not find zip member zip:///home/klik/tmp/php4cfRJH#_rels/.rels in /home/klik/scripts/PhpSpreadsheet-master/src/PhpSpreadsheet/Shared/File.php:159 Stack trace: ..

Read more

I’m trying to pass the variable cat to search the data related in DB and make a report in excel. Unfortunely i’m getting the following error: Unresolvable dependency resolving [Parameter #1 [ $cat ]] in class movieController Route: Route::get(‘/search/report{cat}’, [movieController::class , ‘export’])->name(‘search-report’); movieCatExport: class movieCatExport implements FromCollection, Responsable, WithHeadings, ShouldAutoSize{ use Exportable; //private $fileName=’usertest.csv’; /** ..

Read more

I ran memory_get_usage(); before and after the RVTM_Excel() function that loads and reads a Excel file. before the function the memory usage was 2354960 and after 45541928, so I was wondering if there is a way to unset these variables at the end of this function, because I don’t know how, since unset() doesn’t do ..

Read more