Advertisement
qsadfasdgfgads

Untitled

Apr 3rd, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. <?php
  2. require "vendor/autoload.php";
  3.  
  4. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  5. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  6.  
  7. $parse = explode('http://', file_get_contents("parse.txt"));
  8. array_shift($parse);
  9. $spreadsheet = new Spreadsheet();
  10. $sheet = $spreadsheet->getActiveSheet();
  11. $i=1;
  12. foreach($parse as $item){
  13. $sheet->setCellValue('A'.$i, $i);
  14. $sheet->setCellValue('B'.$i, strval($item));
  15. $i++;
  16. }
  17.  
  18.  
  19.  
  20. $writer = new Xlsx($spreadsheet);
  21. $writer->save('hello world.xlsx');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement