I’m trying to fill an excel file with data coming from a mysql server and using phpSpreadSheet. Then, I need to create a graph so users can see the graph already made. I can fill the excel file no problem, but the graph doesn’t show up. So I decided to simplify the problem by adding the headers an…
Tag: excel
PHP encoding Umlauts in .csv for Excel
I’m working on a PHP script that creates a .csv file from some data. Unfortunately, in Excel Umlauts are not displayed properly: Löl becomes L√∂l (this is just in Excel, in Apple’s Numbers, Atom and Textedit everything looks fine). I have tried hundreds of functions to try and get the encoding rig…
Laravel: How to store Excel File in a given path?
I have a function which is converting my blade view into Excel format and downloading it. Now I want to save it in a specified location, i.e: public/uploads/release Here is my controller: public …
PHPSpreadsheet: Formatting a cell for time also includes the date
I am trying to format a time cell using PHPSpreadsheet but it seems to be including the date as well when looking at the formula bar. There also seems to be some inconsistency when converting from a …
How to install Maatwebsite/Laravel-Excel for laravel 5.4?
I’m working on a project with laravel 5.4. I’m editing an old project and adding some features. But I’m facing a problem with installing excel package that is suitable to this version. I think …
Read XLS in PHP using PhpSpreadsheet
I have a requirements to read XLS files (not xlsx) using PhpSpreadsheet and I having trouble. I tried this (as the documentation say but…) but didn’t work (it worked with a xlsx file, but no with a xls file!) Then I tried to open file differently: but also doesn’t work… I really need t…
Upload file shows Error Notice: Only variables should be passed by reference in
I tried to take it off this error I do not understand why it happens, because I am uploading the file correctly… Right now is uploading the files, it shows me the error Error Notice: Only variables should be passed by reference in… Answer When calling end(), you must pass an array as a variable an…
Looping through columns and rows in PHPExcel to create objects
I’m using PHPExcel library to loop through my excel spreadsheet. This is my current script : try { $inputfiletype = PHPExcel_IOFactory::identify($inputfilename); $objReader = …
Import CSV/Excel data into MYSQL database and remove duplicate using codeigniter
Today i came across a functionality where i need to import the CSV/Excel file in to MYSQL database via codeigniter. There is a special requirement from client where he can upload the CSV/Excel file in …
Attach excel stream to swiftmailer message?
I’m trying to attach an Excel file in a SwiftMailer message. The trick is that I don’t want to save the excel file and then attach it and then delete it, instead I just want to generate the excel and …