I Have a function that reads a xls on php, transforms it, and returns it in csv, heres the html <!DOCTYPE html> <html> <head> <title>Import</title> </head> <body> <h1>File upload</h1> <form method="POST" action="process.php" enctype="multipart/form-data"> <label>File</label> <input type="file" name="arquivo"><br><br> <input type="submit" value="send">…
I'm using PhpSpreadsheet to read a specific value from a local xlsx file, but it's taking 510ms, which is too slow. I need it to be under 20ms, similar to reading from a CSV file with the same data in…
I am preparing a project, I am preparing an allocation form, but I am having a problem, While creating the table, I want to group the incoming date data according to the quota data. So let me explain it like…
PHP Excel - modify .xlsm file with macros without loosing macros Is there any php library or approach to modify xlsm file which has macros without loosing macros. I want to export large data in xlsm template. the xlsm template…
I want to create export file date-range report using ci. views.php <div class="form-group row"> <label for="attn_date" class="col-sm-4 col-form-label">From</label> <div class="col-sm-8"> <input type="date" class="form-control" id="attn_from" name="attn_from"> <?= form_error('attn_from'); ?> </div> </div> <div class="form-group row"> <label for="attn_date" class="col-sm-4 col-form-label">To</label> <div class="col-sm-8"> <input…
I want to calculate all values in the column C and place it at the bottom on the same Column C as total sum. I'm generating excel with data from database - some orders and their amount. Want to calculate…
I installed Laravel excel and created a form. I have completed all the configurations related to Laravel excel. I select and upload my excel file in the form I created, and then I get the following error. PHP Version: 8.1.7…
I want to install phpoffice/phpexcel in My Project. When composer install or composer update, i receive error: Package phpoffice/phpexcel is abandoned, you should avoid using it. Use phpoffice/phpspreadsheet instead. What is wrong with my project? Please help me. My project…
According to the PhpSpreadsheet Doc it's neccessary to install it with composer. In my case I just have a webspace without Terminal but Plesk. Is it anyway possible to use PhpSpreadsheet, like it is with PHPExcel where you just have…