no message

zhaojs

2023-07-31 0de015249a3abe05031eb4f5d988e8eb7ef83c87

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
<?php
 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
 
require __DIR__ . '/../Header.php';
$inputFileType = 'Xlsx';
 
$helper->log('Start');
 
$spreadsheet = new Spreadsheet();
 
$aSheet = $spreadsheet->getActiveSheet();
 
$gdImage = @imagecreatetruecolor(120, 20);
$textColor = imagecolorallocate($gdImage, 255, 255, 255);
imagestring($gdImage, 1, 5, 5, 'Created with PhpSpreadsheet', $textColor);
 
$baseUrl = 'https://phpspreadsheet.readthedocs.io';
 
$drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing();
$drawing->setName('In-Memory image 1');
$drawing->setDescription('In-Memory image 1');
$drawing->setCoordinates('A1');
$drawing->setImageResource($gdImage);
$drawing->setRenderingFunction(
    \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::RENDERING_JPEG
);
$drawing->setMimeType(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_DEFAULT);
$drawing->setHeight(36);
$helper->log('Write image');
 
$hyperLink = new \PhpOffice\PhpSpreadsheet\Cell\Hyperlink($baseUrl, 'test image');
$drawing->setHyperlink($hyperLink);
$helper->log('Write link: ' . $baseUrl);
 
$drawing->setWorksheet($aSheet);
 
$filename = tempnam(\PhpOffice\PhpSpreadsheet\Shared\File::sysGetTempDir(), 'phpspreadsheet-test');
 
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, $inputFileType);
$writer->save($filename);
 
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
 
$reloadedSpreadsheet = $reader->load($filename);
unlink($filename);
 
$helper->log('reloaded Spreadsheet');
 
foreach ($reloadedSpreadsheet->getActiveSheet()->getDrawingCollection() as $pDrawing) {
    $helper->log('Read link: ' . $pDrawing->getHyperlink()->getUrl());
}
 
$helper->log('end');