Questions tagged [PhpSpreadsheet] (106)

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
1
answer

The excel document after the permission edit, change the size of the columns?

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 ...
florian_Pollich56 asked March 27th 20 at 11:41
1
answer

How to use phpexcel to set the text format?

Form using phpexcel report. Need cell some of the text to make a different size, and set other color. How to do it?
misty_Sawayn asked March 23rd 20 at 20:30
0
answer

How to make the transition columns in phpspreadsheets?

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
Gilda.Berge asked March 21st 20 at 12:59
1
answer

Why not set the borders in PhpExcel?

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...
kailee80 asked March 20th 20 at 12:32
0
answer

Why mPdf crooked displays pdf?

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...
Idella75 asked March 20th 20 at 12:08
2
answers

PhpSpreadsheet: How to set the format of the cell to accept text values without clipping them "+"sign?

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...
Ross.Bahring asked March 19th 20 at 20:47
1
answer

PhpSpreadsheet how to place an image in the cell in the center?

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 ...
Cindy asked March 19th 20 at 09:44
1
answer

In the library PHPExcel to load a file contained in a variable?

<? 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...
hattie.Hans asked March 19th 20 at 09:00