Download Phpspreadsheet Without Composer
Merri Coffill
Composer is the only official and supported solution to usePhpSpreadsheet. Alternative custom solutions are possible, but I'dstrongly advise against them. Not using composer will give you morework to set up, and potential issues to maintain.
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.
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...
STEP 1: INSTALL COMPOSER (Needs PHP) on the DEVELOPMENT PC
a) I installed Composer and used the instructions of PHPSPreadsheet to install the PHPSpreadsheet
b) I used an exclusive folder called phpspread. I used command prompt, moved into the phpspread folder and ran the composer command
1- We download the external library PHPSpreadSheet without composer -download.com/downloads/phpoffice/phpspreadsheet/1.8.2.0/phpoffice_phpspreadsheet_1.8.2.0_require.zip 2- Then we proceed to load the external library in the scriptcase:...
I'm working in an environment where I can't use Composer. Is there any way to install the PHPSpreadsheet library so the module recognizes it without using composer? I tried putting it in libraries/PHPSpreadsheet, but trying to do an export has no result and gives the log error "PhpSpreadsheet library not installed."
I added a plugin phpspreadsheet to my source folder PHPspreadsheet as PHPexcel is deprecated in 7.0 php. Xlinesoft is still using PHPexcel . I can send emails as attachments from the old PHPexcel but this particular script will not work in PHP 7.0 +
It's actually this line of code that is supposed to open excel in browser for download. won't work in 7.0 with deprecated PHPexcel.
$objWriter->save('php://output'); // does not work with PHPexcel in anything PHP 7.0 or + .Here is an older topic on the same subject but now I need it to go to the browser , which don't work with PHP 7 it seems.
So thinking I can add phpspreadsheet to the source folder in the latest build , I could fix this . NOT
I build my project and the plugin is not there . It seems any custom plugins added to the plugins folder in the source code do not get generated into a project and build. Click Here old topic but should work
So I injected it myself into the output folder but because I get a 500 error on the button handler in debugging can't find params f - ???? proto . Json. If I just send the xlsx file as an email attachment it works perfect.
I have checked in tips and tricks and fhumes has some examples ( but no databases to test them ) great example of pdf files which he is using in a button , but the code if far more than I need and templated. His code does not actually show you how to install the phpspreadsheet unforunately. He uses composer I assume , Can't use this in my situation as one it is way too much time and two not need when the zip file can be extracted and just added to plugins folder and call it using autoloader.
Anyone Ideas ???
10.3 Build 33877
10.3 Build 33978 ( beta )
Thanks James,
Looks like that may work for that situation . Although if I add to the source / Plugins folder ( option 1 or 2 ) , it should do the same thing and not using client before but using on server code. This always worked in 9.8 or below . Maybe they changed this. Unfortunately this a going to be a template that is going to be offered in the xlinesoft marketplace and needs to be clean code , so I can't use the solution in the video due to having to change the header and having to edit html . Unfortunately I need this to be clean html without editing anything in editor like we used to , from anyone who uses the template so they do not have to enter the extra code ( I will have to investigate further to see if the template will carry over the code to a new project ).. But it does give me some ideas . So I appreciate you taking the time to remind of the video.
As far as my code for PHPexcel , It is stored in the button handler event and keep getting 500 error when I try to output to browser . Weird thing is I can send it as an attachment but can't output it to the browser. I looked at the Excel output function built in
and it does use (php://output) , so I am stuck here as usual . Spent 20 hours on this . I am done with it . Just am taking it out of the picture. The user will have to decide Unfortunately. It's really a shame that samples for these situations are not provided and the fact that PHPexcel is still even being used . Not only that xlinesoft is using an outdated version 1.7 which was from 2012 , instead of 1.8 ( 2015 ) which are all deprecated and phpspreadsheet is what works the best with PHP 7+ but can't install it correctly. I keep loosing it in the builds.
Another issue I found is that custom buttons that are deleted do not get removed permanetly ( they still exist in the code ) . I removed some test button's and looked at the project and all the initial test buttons are still in the output folder after doing a clean build and new output folder . Seems another issue. I think what is happening is ,it is saving them for the option in designer to use them over again. They need to add an option in designer to delete past test buttons, so if you make ten test buttons save , guess what , they come back on build after removing them. Thanks for the post.
If you are building your installation on a development machine that is on a different PHP version to the server where it will be deployed, or if your PHP CLI version is not the same as your run-time such as php-fpm or Apache's mod_php, then you might want to add the following to your composer.json before installing:
(SOLVED BELOW) I am stuck for a few days now trying to effectively use composer to install phpspreadsheet on a php project I am working on for a client. Since phpspreadsheet requires php >= 7.2 I installed multiple versions of php (5.6, 7.1,2,3,4, 8.0) on my Linux drive (ubuntu 20.04.2 LTS focal).I uninstalled an Ampps server which only had php7.1. Apache2 was already installed. I installed mysql-server 8.0 after some difficulties (until I purged the ampps installation).
bcrypt is a hashing algorithm which is scalable with hardware (via a configurable number of rounds). Its slowness and multiple rounds ensures that an attacker must deploy massive funds and hardware to be able to crack your passwords. Add to that per-password salts (bcrypt REQUIRES salts) and you can be sure that an attack is virtually unfeasible without either ludicrous amount of funds or hardware.
bcrypt uses the Eksblowfish algorithm to hash passwords. While the encryption phase of Eksblowfish and Blowfish are exactly the same, the key schedule phase of Eksblowfish ensures that any subsequent state depends on both salt and key (user password), and no state can be precomputed without the knowledge of both. Because of this key difference, bcrypt is a one-way hashing algorithm. You cannot retrieve the plain text password without already knowing the salt, rounds and key (password). [Source]
Since introduction of composer install in version 7.5.3, it has been an excellent way for dependencies management while minimizing file distribution size. Users can keep dependencies updated by running composer update without reaching out to us, a win-win.
PHPExcel (deprecated) has now been replaced by PHPSpreadsheet. It requires two PHP extensions, depending versions of PHP, sometime they are not enabled by default. If they are missing, you are like to encounter the following error messages during composer install.
Trying to use composer to install phpspreadsheet on a php project I am working on for a client. Since phpspreadsheet requires php >= 7.2 I installed multiple versions of php (5.6, 7.1,2,3,4, 8.0) on my Linux drive (ubuntu 20.04.2 LTS focal).
I uninstalled an Ampps server because it only had php7.1. Apache2 was already installed. I installed mysql-server 8.0 after some difficulties (until I purged the ampps installation), and configured the server myself. It serves a website using a database with minor problems related to the old PHPExcel module.
Composer did install globally, and I did initialize a basic composer.json in my webroot directory. A ```/vendor``` dir was created containing a ```/composer``` dir, but no phpspreadsheet folder, and many errors detailed below.
If I run ```$ composer diagnose``` from the web root dir in the terminal I got the following error:
```
[Composer\Exception\NoSslException]
The openssl extension is required for SSL/TLS protection but is not available. If you can not enable the openssl extension, you can disable
this error, at your own risk, by setting the 'disable-tls' option to true.
```
Attempts to run ```$ composer update``` or ```upgrade``` stall with the same error.
But I tried to update this dependencies but they are locked. I think I have to change composer.json to unlock some configuration, but I'm not sure what should I do.What is the right way to update Drupal Core?Thanks.
Composer already has a --ignore-platform-reqs option (notice the s in reqs), but it ignores all platform requirements, including PHP version, extensions (ext-*), and composer-plugin-api.
We have several URLs with an error status because theyshould not be public i.e., composer.json, and one with an info status because itreturned a HTTP status code that is not ideal i.e., lib/classes/. Image attached.