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 and the graph
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 right (see the commented functions below). Could someone please
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 to solve this… please help! PS: I’ve
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 and not the return value
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 …