Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require "vendor/autoload.php";
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
- $parse = explode('http://', file_get_contents("parse.txt"));
- array_shift($parse);
- $spreadsheet = new Spreadsheet();
- $sheet = $spreadsheet->getActiveSheet();
- $i=1;
- foreach($parse as $item){
- $sheet->setCellValue('A'.$i, $i);
- $sheet->setCellValue('B'.$i, strval($item));
- $i++;
- }
- $writer = new Xlsx($spreadsheet);
- $writer->save('hello world.xlsx');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement