I am using Mpdf to generate a pdf from a phpSpreadsheet object. It works pretty well, but if a numeric cell is followed by a string cell I get no gap between the cells. I suspect this is because the ...

For a legacy application I have to use PHPExcel and populate an existing Excel file(Excel5 format). A particular cell value starts disappearing in final excel file randomly. File is generated ...

Can you help me to create class library of phpspreadsheet like PHPexcel in codeigniter 3 to load it in autoload config, and how to move this folder under third_party in my application? I am create the ...

What im trying to do is convert chart.js to image with toDataURL then past it using ajax and using the url to set image path for php excel. I want to past the data without using any button and my php ...

I'm having trouble loading an excel spreadsheet using PHPspreadsheet. I receive the following error... Fatal error: Uncaught PhpOffice\PhpSpreadsheet\Reader\Exception: Could not open "...

I am using PHPExcel to export a MySql select and it's working fine. I know PHPExcel is deprecate and now there is PHPspreadsheets, but it's an old project with an old php version Anyway, I'd like to ...

I have an addin in excel which has many user defined function for calculating gas properties etc. I want to fetch the calculated value from a cell which has a formulae which is user defined. for eg I ...

I am trying to create an Excel file from my Database that looks like this : User Name User Lastname Group A Group B Group X John Doe X X Jane Doe X I have 3 tables : a User table, a Group Table, and ...

I'm trying to import a two sheet excel file using Laravel Excel. The excel file contains two sheets, one for the main building and the second one with all the apartments inside, all I need is to pass ...

I have a data base of over 16k columns. Each column is identified by an ID. I am trying to make an automated daily report. The data is updated every day. I have 1 sheet which is (data) sheet. I am ...

I am using below code to Export into .xlsx using package maatwebsite/excel $fileName = 'Stats-GroupID_' . $groupId . '-' . time() . '.xlsx'; return Excel::download($statsExport->setGroupId($...

$rowIndex = 1; foreach ($request->warehouses as $warehouse) { $whId = $warehouse['id_warehouse']; $warehouse = Warehouse::find($whId); if ($warehouse) { foreach ($rowDetails ...

I have an excel file which contains PDF - embedded (attached) in it. I am trying to use PHPExcel and PHPSpreadsheet to fetch the data. I am successful in fetching the images but other objects like PDF ...

I need to read an excel file and upload the information to my DB, the structure of the information is the next one. The idea is to take A1, then B2 to B8, N amoung of times, i make the test with a ...

I'm encountering an issue with the GD extension in my XAMPP environment while trying to install the `phpoffice/phpspreadsheet` package. The error message indicates that the `ext-gd` extension is ...