skip to Main Content

According to the PhpSpreadsheet Doc it’s neccessary to install it with composer.
In my case I just have a webspace without Terminal but Plesk. Is it anyway possible to use PhpSpreadsheet, like it is with PHPExcel where you just have to place the files in any location?
What do I have to do to get it run? I found no further information how to with only FTP webserver access.

6

Answers


  1. In your case there are two options for you!

    Answer: 1

    Alternative method without terminal

    Run composer with a PHP script in browser

    Answer: 2

    Third party sites, which allow to download composer packages online. get PHPspreadsheet latest version.

    https://php-download.com/package/phpoffice/phpspreadsheet

    Bonus You can download almost any composer packages @ https://php-download.com

    Login or Signup to reply.
  2. Have you considered installing composer locally, running it as instructed, and then just sending the generated files to the server via normal FTP? You install composer on your computer and run it there, then upload via FTP/SFP…

    Composer is not “necessarily” intended to run live while the user is downloading the pages, it is intended to be run “mainly” on your local computer and generating the files and dependencies that later on you upload to the server. It can update the files on your server, but that is a convenience not a necessity.

    Login or Signup to reply.
  3. Smartpal, thanks for your pack, it works fine!

    Also it possible to replace folder:

    /phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/
    

    in Smartpal’s archive with more fresh sources from phpspreadsheet github and it also will work.

    PS: If you have issues with reading xls files saved in encoding other than CP1252, you have to seek literals CP1252 in file ./src/PhpSpreadsheet/Reader/Xls.php and replace them with other value that you need or some named constant or even mb_detect_encoding(). Then it will read such xls correctly.

    Login or Signup to reply.
  4. By registering custom autoloader and PSR simplecache autoloader it is possible to fully workaround composer installation – see:

    https://github.com/PHPOffice/PhpSpreadsheet/issues/31#issuecomment-354502740

    Please note, that installation via composer is currently the only officially supported solution.

    Login or Signup to reply.
  5. sample code

    require 'vendor/autoload.php'; 
    use PhpOfficePhpSpreadsheetSpreadsheet; 
    use PhpOfficePhpSpreadsheetWriterXlsx; 
    $spreadsheet = new Spreadsheet(); 
    $sheet = $spreadsheet->getActiveSheet();
    $sheet->setCellValue('A1', 'Hello World !');
    
    $writer = new Xlsx($spreadsheet);
    $writer->save('hello world.xlsx');
    
    Login or Signup to reply.
  6. I had the same problem. I downloaded Library on github from
    https://github.com/PHPOffice/PhpSpreadsheet
    and made a few changes

    1. changed its namespaces
    2. used autoload.php file
    3. It worked

    the Library without the need of Composer is in this link
    https://github.com/YoloZoloo/PhpSpreadSheet/tree/master

    You can change the folder name to any folder you like.
    Load [AnyFolder]->table.php from your server and press 「ダウンロード」.

    Hit back to me if you encounter any issues

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search