I am generating an excel file using phpexcel, the columns are 186 so I have created an array of the header columns and dynamically adding them the file is created well but the columns are broken as seen in the picture below. anyone ever encountered this issue? UPDATING THE QUESTION Now the xcel sheet has over 150 columns but not
Tag: phpexcel
PhpExcel write/save onto existing excel file
First of all, I have searched for my problem in both stackoverflow and on the forms, but I could not find exact question and its solution. (This one is about saving HTML to existing Excel) *** I have also seen some answers on related question about saving as new excel file, but my question is can I save onto existing
How to separate the full name that has comma in excel using php
I have a project that gets the name from excel and stores the value in the first name and last name. The problem is that in the excel file the name is stored (for example John, Constantine) how do I get the John and Constantine and store it in two different variables? this is what I wrote so far but
How to fill empty lines in an Excel file ummerged in php?
I have this code that allows me to read an xlsx file containing merged celles and unmerged them to be able to process them. The xlsx unmerged file is like this : And I would like the empty lines to be filled like this: Each time the ‘Style’ value changes the empty cells are filled with the values of the
How to read a excel file with merged cells in php?
I wrote a php script that allows me to read an uploaded excel file and insert all the images contained in a folder by renaming them with the cell values “style” and “color” to have style_color.jpg. The script works fine but if I upload an xlsx file containing merged cells like this: images with the same “style” doesn’t work.The tool
PHP SpreadSheet can’t find the function to auto size column width
I simply want the columns to autosized. I am using php spreadsheet and I can’t find how to do it. I have searched other questions but they are using functions that i can’t event find in my lib worksheet.php like getActiveSheet() Any advise ? This is my code Answer For spreadsheet the answer is:
How to use PhpSpreadsheet without installation (like PHPExcel)
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 to place the files in any location? What do I have to do to get it run? I found no
Read date value from import Excel in PHP
I’ve problem with read date value from import value (Excel) to mysql database. i’ve code as below : i tried use strtotimeto define value from excel, but i’ve problem to save it into database, if my value in excel with excel date format is 1/1/2018 (it read as 1 Jan 2018, English time format), after i used my code above,
Open a password protected EXCEL in wamp using PHP
I have an excel that has a password (When you open it, it asks for a password). I want to open it and save it to a new folder. Supposing that there is no password my script would be : How can I mention the password of the file in the fopen function? It must be only one line that
PHPExcel download using ajax call
App::import(‘Vendor’, ‘PHPExcel/Classes/PHPExcel’); $objPHPExcel = new PHPExcel(); $objPHPExcel->getActiveSheet()->setTitle(‘ReceivedMessages’); header(‘Content-Type: application/vnd.ms-excel’); …