1 | <?php |
||||
2 | |||||
3 | use PhpOffice\PhpSpreadsheet\Spreadsheet; |
||||
4 | |||||
5 | require __DIR__ . '/../Header.php'; |
||||
6 | $inputFileType = 'Xlsx'; |
||||
7 | |||||
8 | $helper->log('Start'); |
||||
9 | |||||
10 | $spreadsheet = new Spreadsheet(); |
||||
11 | |||||
12 | $aSheet = $spreadsheet->getActiveSheet(); |
||||
13 | |||||
14 | $gdImage = @imagecreatetruecolor(120, 20); |
||||
15 | $textColor = imagecolorallocate($gdImage, 255, 255, 255); |
||||
1 ignored issue
–
show
Bug
introduced
by
Loading history...
|
|||||
16 | imagestring($gdImage, 1, 5, 5, 'Created with PhpSpreadsheet', $textColor); |
||||
1 ignored issue
–
show
It seems like
$gdImage can also be of type false ; however, parameter $image of imagestring() does only seem to accept resource , maybe add an additional type check?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
Loading history...
|
|||||
17 | |||||
18 | $baseUrl = 'https://phpspreadsheet.readthedocs.io'; |
||||
19 | |||||
20 | $drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing(); |
||||
21 | $drawing->setName('In-Memory image 1'); |
||||
22 | $drawing->setDescription('In-Memory image 1'); |
||||
23 | $drawing->setCoordinates('A1'); |
||||
24 | $drawing->setImageResource($gdImage); |
||||
1 ignored issue
–
show
It seems like
$gdImage can also be of type false ; however, parameter $value of PhpOffice\PhpSpreadsheet...ing::setImageResource() does only seem to accept resource , maybe add an additional type check?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
Loading history...
|
|||||
25 | $drawing->setRenderingFunction( |
||||
26 | \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::RENDERING_JPEG |
||||
27 | ); |
||||
28 | $drawing->setMimeType(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_DEFAULT); |
||||
29 | $drawing->setHeight(36); |
||||
30 | $helper->log('Write image'); |
||||
31 | |||||
32 | $hyperLink = new \PhpOffice\PhpSpreadsheet\Cell\Hyperlink($baseUrl, 'test image'); |
||||
33 | $drawing->setHyperlink($hyperLink); |
||||
34 | $helper->log('Write link: ' . $baseUrl); |
||||
35 | |||||
36 | $drawing->setWorksheet($aSheet); |
||||
37 | |||||
38 | $filename = tempnam(\PhpOffice\PhpSpreadsheet\Shared\File::sysGetTempDir(), 'phpspreadsheet-test'); |
||||
39 | |||||
40 | $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, $inputFileType); |
||||
41 | $writer->save($filename); |
||||
42 | |||||
43 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
||||
44 | |||||
45 | $reloadedSpreadsheet = $reader->load($filename); |
||||
46 | unlink($filename); |
||||
47 | |||||
48 | $helper->log('reloaded Spreadsheet'); |
||||
49 | |||||
50 | foreach ($reloadedSpreadsheet->getActiveSheet()->getDrawingCollection() as $pDrawing) { |
||||
51 | $helper->log('Read link: ' . $pDrawing->getHyperlink()->getUrl()); |
||||
52 | } |
||||
53 | |||||
54 | $helper->log('end'); |
||||
55 |