Questions tagged [PhpSpreadsheet] (106)

1
answer

Download the data in EXCEL: PHP and PhpSpreadsheet — why does not work the first time?

The bottom line is there is a file exportmezved.php which displays a list of active requests users of the system. <button id="mezved_to_excel" class="btn btn-primary float-right" onclick="location.href='../lib/exporttoexcel/mezvedtoexcel.php'" Clicking on this button in the file mezvedtoexcel.php the formation of the E...
Darien_Ja asked April 19th 20 at 12:07
0
answer

How to remove border from pdf when you save with phpspreadsheet?

Create a file xlsx using phpspreadsheet using tcpdf (the other can't work with bitrix, access to the hosting is not). On the same object save to pdf. Pdf appear in the border. Where the table dual. How to remove them? PDF: XLSX:
Britney_Hami asked April 9th 20 at 10:56
0
answer

Why phpspreadsheet reads xlsx but not xls reads?

Good evening. You have the library installed phpspreadsheet. Everything seems correctly in composer. Tested with xlsx files that works correctly and reads and writes. But xls does not want to read (but writes). Tried different xls files to read in and generated by himself. I tried to run examples from the documentation p...
Emely_Gorcza asked April 8th 20 at 10:18
1
answer

How to put headers in excel using php?

When you download a normal excel file, get the header $headers = $list ->rangeToArray( 'A1:'.$list->getHighestColumn().'1', null, false, false, true ); But often managers download files where the headers begin at 7, 10 lines, and at the top is such as the logo and contacts. How to get the headers in these cases?
Niko asked April 8th 20 at 01:46
1
answer

How to import xls in the admin?

Hello. Do import data into database from excel file. The algorithm is that after downloading the file, you can select the appropriate columns from the table, put them next to the desired values and add products. I have already brought the column headers, and by means of drag n drop them to place next to the desired columns ...
Tevin.Watsi asked April 7th 20 at 15:57
1
answer

The Poisson distribution in phpspreadsheet?

Faced with the problem of how to bring Excel table the results of the Poisson distribution using the "phpspreadsheet" Method getCalutatedValue() causes a fatal error and overwrites the Excel file. Please tell me, because there is the possibility to implement it? And how to do it? Where to dig?
luisa_V asked April 7th 20 at 15:19
1
answer

How to make the standardization of Excel in PHP?

The system is written in PHP, the reports are uploaded in Excel (xlsx) using PHPSpreadSheet. You have to write nested loops. With cycles without attachments no problem, but how to make 2 investments in cycles is unclear. The array looks like this:$a = [ [ 'id' => 1, 'name' => 'Test', 'items' => [ [ 'label' =>...
stephanie_Dietrich asked April 4th 20 at 01:52
2
answers

How do you know that in the cell the date value using PHPExcel?

The problem is that the format of the date values come in as integers, for example - 43811 How do you know that the cell be kept just date?
rocio87 asked April 3rd 20 at 23:34
0
answer

PhpSpreadsheet not pogruzhayutsya image pasted into Excel?

UDP.1 Generally found that if posunout picture with 32Битами all the rules, there are no errors, as soon as I shove a picture 24Бита, everything breaks... When you open generated Excel POPs up a window inside pictures of the broken, half did not load... what's the problem? On another hosting all the rules, version Php7.1+, ...
Gudrun asked March 29th 20 at 23:51
0
answer

How to change the data entered in a cell in execl table according to the formula?

Hello, {username} ! Tell me please, is it possible to change user data (entered) by the formula of Excel, and leaving the values of the function executed in the input field. Example: Entering data into the "Order units" varies according to the formula field "Boxes in the order" and Vice versa, by changing the field "Boxes i...
everett_Medhurst69 asked March 29th 20 at 21:37