I’m having a problem with the excel formatting of export operation, here’s my code SubmissionDetailExportExcel.php pengajuan_detail.blade.php When i opened the exported file, it became something like this: The second data after the first one goes to the right instead in the same column, how do i fix this Answer Fixed it by deleting the “rowspan”
Tag: excel
Phpspreadsheet formula not accepted
With phpspreadsheet, i can’t put a formula in a cell. I get an error : L43 -> Formula Error: An unexpected error occurred While when i put this formula in an excel file directly it’s working nice. My formula is : “=IF(SUM(J2:J41)<>SUM(L2:L41);”1″;”2″)”. There is my code : $sheet->setCellValue($cell, $formula); I also test with $sheet->setCellValueExplicit($cell, $formula, DataType::TYPE_FORMULA); But i doesn’t work
PHP exporting several excel files
I’m trying to export several tables from a database and creating a excel file for each table using PHP. The loop however is “bugged”. Instead of creating a new file for each loop it just puts all data into the same file. The code: If I kill the loop after the first iteration it exports the data correctly from ONE
How to display the original data in excel whichever returns from the database in php?
I am using matwebsite for exporting excel files ,i am getting the data from the database it’s stored in the exported excel file upto this part it’s working fine .some of the values are more than 15 digits at that time it’s displaying as scientifc format for that i made some changes using columnFormats() function now it supports upto 16
Upload txt file using PHP into database and then return Excel file
What I need to do is upload txt file into databe using PHP, do some calculations based on that table, and then return result in Excel file. This code works well, but I’m not getting all data from the .txt file, since it looks like it stops when it finds a comma. Here is the code: And here is the
AJAX Post is sending only partial rows PHP
AJAX Post is sending only partial rows PHP. This is my code: excelRows contains 39 rows, but I am getting only 25 rows to PHP. Here is my PHP script – Answer UPDATE Here is a sample AJAX-call with the data you provided. So far everything works OK. Maybe you should try it out again with your original data and
How to show the Id number in descending order?
I am using PHP and I have to export the data from the database. I am using the below code which is working. I am getting all the records. Notice that I am getting all the records in descending order and id is showing ascending `order. This is my expected output: How can I show the Id in descending order?
Convert Excel file to array while preseerving formatting when using PHPSpreadsheet
Whatever I do, my array does not keep cell value formatting when I convert data to array. How to convert formatting to HTML preferably? Answer Looks like converting spreadsheet to HTML file, and reading that through DOMDocument parser work for me for now.
Excel file can not be saved in PHP COM Application
we are having issues saving excel sheets in PHP. Minimalistic code: The call to save will throw a com_exception with message “Source: Microsoft Excel Description: Das Dokument wurde nicht gespeichert.” (German for “The document was not saved.”) When any worksheet of the workbook has been opened and i am trying to save the worksheet again i get another com_exception with
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