How to use PHPSpreadsheet classes inside a function

Question

I have created a AJAX function that runs on a click event on the front end. Inside this function I want to be able to generate a XLS Spreadsheet but I am unable to do this inside the function. I believe its to do with me declaring the use statements outside the function maybe the function is unable to access the classes? I tried declairing them inside the function and I got this error;

syntax error, unexpected 'use'

Doe's anyone have a solution for this? Here's my code;

add_action('wp_ajax_nopriv_campaign', 'email_campaign');
add_action('wp_ajax_campaign', 'email_campaign');

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

function email_campaign(){
    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();
    $sheet->setCellValue('A1', 'Hello World !');
    $writer = new Xlsx($spreadsheet);
    $writer->save('hello world.xlsx');

    die();
}

here is how I call my function;

$('#campaign_form').submit(function(e){
    e.preventDefault();

    $.ajax({
        url: ajax_url,
        type: 'post',
        dataType: 'json',
        data: { 
            action: 'campaign'
        },
        error : function(response){
            console.log(response);
        },
        success : function(response){
            console.log(response);
        }
    });
});

What php version do you have on server? Have you tried to put the use / import of other classes at the top of the file? Below namespace? — Nikola Kirincic, Jun 18 '19 at 11:53
@blues Oh that error doesn't matter now. It was because I was was declaring use inside my function. I now know that it must be declared in the outermost scope of the file — Reece, Jun 18 '19 at 12:02
@niklaz I'm running php 7. I have no idea what your asking in your second question sorry — Reece, Jun 18 '19 at 12:04

Imran Khan · Answer 1 · 2019-06-18T12:12:03.513

1

Modify Your Code as :

require_once 'vendor/autoload.php';

function email_campaign(){
    $path = dirname(__DIR__).'/sheets';
    $fileName = 'hello_world.xlsx';

    $spreadsheet = new PhpOffice\PhpSpreadsheet\Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();
    $sheet->setCellValue('A1', 'Hello World !');
    $writer = new PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
    $writer->save($path.'/'.$fileName);
}

edited Jun 18 '19 at 12:12

answered Jun 18 '19 at 11:54

Imran Khan

311
4
9

Thanks but the XLSX speadsheet isn't been generated – Reece Jun 18 '19 at 12:00
Spreadsheet is generated but code must define where to save the file full path and also better to generate file name without space. – Imran Khan Jun 18 '19 at 12:05
How do I declare where to save the file? Usually it just automatically saves to my root dir on the server. – Reece Jun 18 '19 at 12:06
@Reece Modified code will save to /sheets/hello_world.xlsx You can modify path as you want, mentioned is just for example. – Imran Khan Jun 18 '19 at 12:12
POST https://website.co.uk/wp-admin/admin-ajax.php 500 I'm getting this error in the console – Reece Jun 18 '19 at 12:25
@Reece Check the path you are generating and is it writable by your code. – Imran Khan Jun 18 '19 at 12:29

How to use PHPSpreadsheet classes inside a function

1 Answers1