File Edit Options Buffers Tools PHP C Help <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); require APPPATH . '/third_party/vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; class Bos extends CI_Controller { function __construct() { parent::__construct(); } public function index() { $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $writer->save('./uploads/hello_world.xlsx'); $data['title'] = 'Backorders'; $this->load->view('bos/index',$data); }

https://phpspreadsheet.readthedocs.io/en/develop/

function read_excel($o) { $path = $o['full_path']; $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx'); $spreadsheet = $reader->load($path); $v = $spreadsheet->getActiveSheet()->getCell('A1')->getValue(); var_dump($v); } 11.07.18

https://phpspreadsheet.readthedocs.io/en/develop/topics/accessing-cells/

function read_excel_to_array($o) { $path = $o['full_path']; $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx'); $spreadsheet = $reader->load($path); $worksheet = $spreadsheet->getActiveSheet(); $last_row = $worksheet->getHighestRow(); // e.g. 10 $last_col = $worksheet->getHighestColumn(); $last_col_index = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($last_col); $a = []; for($row = 1; $row <= $last_row; ++$row): for($col = 1; $col <= $last_col_index; ++$col): $a[$row][$col] = $worksheet->getCellByColumnAndRow($col, $row)->getValue(); endfor; endfor; return $a; } 11.07.18

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024