/
var
/
www
/
vhosts
/
nabawater
/
vendor
/
phpoffice
/
phpspreadsheet
/
samples
/
Basic
/
/var/www/vhosts/nabawater/vendor/phpoffice/phpspreadsheet/samples/Basic
mkdir
upload
Name
Size
Mode
Actions
data/
-
0755
rm
01_Simple.php
1839
0644
edit
dl
rm
01_Simple_download_ods.php
2123
0644
edit
dl
rm
01_Simple_download_pdf.php
1758
0644
edit
dl
rm
01_Simple_download_xls.php
2101
0644
edit
dl
rm
01_Simple_download_xlsx.php
2144
0644
edit
dl
rm
02_Types.php
4937
0644
edit
dl
rm
03_Formulas.php
3328
0644
edit
dl
rm
04_Printing.php
2281
0644
edit
dl
rm
05_Feature_demo.php
164
0644
edit
dl
rm
06_Largescale.php
164
0644
edit
dl
rm
07_Reader.php
539
0644
edit
dl
rm
08_Conditional_formatting.php
4976
0644
edit
dl
rm
08_Conditional_formatting_2.php
2541
0644
edit
dl
rm
09_Pagebreaks.php
2257
0644
edit
dl
rm
11_Documentsecurity.php
1851
0644
edit
dl
rm
12_CellProtection.php
1503
0644
edit
dl
rm
13_Calculation.php
6742
0644
edit
dl
rm
13_CalculationCyclicFormulae.php
1075
0644
edit
dl
rm
14_Xls.php
380
0644
edit
dl
rm
15_Datavalidation.php
3360
0644
edit
dl
rm
16_Csv.php
1140
0644
edit
dl
rm
17_Html.php
382
0644
edit
dl
rm
18_Extendedcalculation.php
2947
0644
edit
dl
rm
19_Namedrange.php
2624
0644
edit
dl
rm
20_Read_Excel2003XML.php
323
0644
edit
dl
rm
20_Read_Gnumeric.php
329
0644
edit
dl
rm
20_Read_Ods.php
317
0644
edit
dl
rm
20_Read_Sylk.php
315
0644
edit
dl
rm
20_Read_Xls.php
599
0644
edit
dl
rm
22_Heavily_formatted.php
1475
0644
edit
dl
rm
23_Sharedstyles.php
1828
0644
edit
dl
rm
24_Readfilter.php
1145
0644
edit
dl
rm
25_In_memory_image.php
1481
0644
edit
dl
rm
26_Utf8.php
1400
0644
edit
dl
rm
27_Images_Xls.php
322
0644
edit
dl
rm
28_Iterator.php
1225
0644
edit
dl
rm
29_Advanced_value_binder.php
4668
0644
edit
dl
rm
30_Template.php
1242
0644
edit
dl
rm
31_Document_properties_write.php
3088
0644
edit
dl
rm
31_Document_properties_write_xls.php
3077
0644
edit
dl
rm
37_Page_layout_view.php
1021
0644
edit
dl
rm
38_Clone_worksheet.php
1837
0644
edit
dl
rm
39_Dropdown.php
4033
0644
edit
dl
rm
40_Duplicate_style.php
996
0644
edit
dl
rm
41_Password.php
374
0644
edit
dl
rm
42_RichText.php
2680
0644
edit
dl
rm
43_Merge_workbooks.php
829
0644
edit
dl
rm
44_Worksheet_info.php
734
0644
edit
dl
rm
45_Quadratic_equation_solver.php
2008
0644
edit
dl
rm
46_ReadHtml.php
405
0644
edit
dl
rm
Edit:
/var/www/vhosts/nabawater/vendor/phpoffice/phpspreadsheet/samples/Basic/40_Duplicate_style.php
(996B)
<?php use PhpOffice\PhpSpreadsheet\Cell\Coordinate; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Style\Style; require __DIR__ . '/../Header.php'; $helper->log('Create new Spreadsheet object'); $spreadsheet = new Spreadsheet(); $worksheet = $spreadsheet->getActiveSheet(); $helper->log('Create styles array'); $styles = []; for ($i = 0; $i < 10; ++$i) { $style = new Style(); $style->getFont()->setSize($i + 4); $styles[] = $style; } $helper->log('Add data (begin)'); $t = microtime(true); for ($col = 1; $col <= 50; ++$col) { for ($row = 0; $row < 100; ++$row) { $str = ($row + $col); $style = $styles[$row % 10]; $coord = Coordinate::stringFromColumnIndex($col) . ($row + 1); $worksheet->setCellValue($coord, $str); $worksheet->duplicateStyle($style, $coord); } } $d = microtime(true) - $t; $helper->log('Add data (end) . time: ' . round($d . 2) . ' s'); // Save $helper->write($spreadsheet, __FILE__);
Save
cmd:
run