New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[BUG] Import EXCEL happens exception at PHP7.4, response: Trying to access array offset on value of type int #2478
Comments
Thanks for submitting the ticket. Unfortunately the information you provided is incomplete. We need to know which version you use and how to reproduce it. Please include code examples. Before we can pick it up, please check (https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/ISSUE_TEMPLATE.md) and add the missing information. To make processing of this ticket a lot easier, please make sure to check (https://laravel-excel.maatwebsite.nl/3.1/getting-started/contributing.html) and double-check if you have filled in the issue template correctly. This will allow us to pick up your ticket more efficiently. Issues that follow the guidelines correctly will get priority over other issues. |
Can you show a bit more stacktrace, I cannot confirm the bug when using the package on PHP7.4. Maybe it's something in your own code? |
Hi @patrickbrouwers thanks for the package, I'm a big fan of it! I am getting a similar error after upgrading, although it is during an export, and the stacktrace indicates the problem is with phpsreadsheet, not Laravel-Excel, but google brought me here. Here is the stacktrace:
|
Fixed in PhpSpreadsheet, see PHPOffice/PhpSpreadsheet#1300 |
In the PHPExcel file "DefaultValueBinder.php", replace this line 82: |
DefaultValueBinder.php inside of vendor folder? or where is it? same problem here. |
My apologies. I should have been more specific. In my installation, it is located in the PHPExcel folder at this location: PHPExcel\Cell\DefaultValueBinder.php |
the line i think is the 62, not 82 my friend! and i hope that it will work 'cause im stress out. I cant find the solution to error in my project : Error ERROR: Trying to access array offset on value of type int '/Cell/DefaultValueBinder.php:56'. I have high hopes! |
This is the path : third_party/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php Now search === '=' and check if there is matching line then replace with that particular to |
it works! love you! |
When I was almost downgrading to PHP 7.3, thanks man this helped me |
Any idea to solve this issue with PHP 7.4.3 & maatwebsite/excel version 2.1? |
You would have to fork the deprecated phpexcel package and maintain the fork yourself. |
strpos of bool, rly? Just put this code after check to is_bool and is_float |
Code is not part of this package, but of legacy PhpExcel |
Thank You man. Loved it. Thankx @burello <3 |
The best thing to do is to update the
fixed the problem. |
i have this e'rror too |
al klakkel |
Thanks working for me !! orderimportexport.ocmod opencart 3x |
In the PHPExcel file "DefaultValueBinder.php", replace this line 82: Amazing, you saved me bro, thank you so much |
replace this line 82: working for me... |
Please report errors within PhpSpreadsheet to PhpSpreadsheet. |
Versions
Description
Import EXCEL happens exception at PHP7.4,
Exception->message() is:
Trying to access array offset on value of type int.
Steps to Reproduce
Expected behavior:
import a xlsx file as i running the code on php72w
Actual behavior:
happened after I uploaded my server circumstance from php7.2 to php7.4 when I import a Excel would be fail like above.
would be normal again if I downgrade from php7.4 to php7.2.
Additional Information
And what is in Import Class:
The text was updated successfully, but these errors were encountered: