Questions tagged [PhpSpreadsheet] (106)

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...

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:

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...

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?

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 ...

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?

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' =>...

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?

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+, ...

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...