Questions tagged [PhpSpreadsheet] (106)

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

I use the library phpspreadsheet to create reports in excel (for printing, a sheet as A4) in the code prescribed the size of each column when you open the document and just press a button to allow edits, just changing the size of the columns adds to each column of about 2-3 mm and I have one column Siegal how to solve this ...

Form using phpexcel report. Need cell some of the text to make a different size, and set other color. How to do it?

There is a need to make the transition from columns 5 are filled with, how to implement? It is imperative that they are filled below the main table

I'm using PhpExcel, and not PhpSpreadsheet, because in the past I never got to install the image. I need to set cell borders. I tried various options. Here the red color of the text is established, and the borders - no:$objReader = new PHPExcel_Reader_Excel2007(); $objPHPExcel = $objReader->load('..\..\control-files\temp...

Hi all. Using PHPSpreadsheet edit the xls file and then it wants to save to pdf using mPdf. Here is the code:$spreadsheet = IOFactory::load(public_path('form_3.XLS')); $worksheet = $spreadsheet->getActiveSheet()->setCellValue('N16', $data); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf($spreadsheet); $writer...

There is code like this:$sheet ->getStyleByColumnAndRow($column, $row) ->getNumberFormat() ->setFormatCode('@') ; $sheet->setCellValueByColumnAndRow( $position, $row, $value ); The idea is that it should set the cell text format, and then if we set a value like "+5", it has to remain that way. In practice, ther...

PhpSpreadsheet Tell me how to place an image in the cell in the center? the picture is smaller than the height of the cell, the cell has be a style center.'alignment'=>[ 'horizontal'=>\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,'vertical'=>\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER ...

<? require_once "xls/Classes/PHPExcel.php"; $file = file_get_contents("name_file.xlsx"); $pExcel = PHPExcel_IOFactory::load($file); $objWriter = PHPExcel_IOFactory::createWriter($pExcel, 'Excel5'); $objWriter->save('name_file' . '.xls'); Right now the example doesn't work? since the method PHPExcel_IOFactory::load as...