PHPOffice / PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files
https://phpspreadsheet.readthedocs.io
MIT License
13.37k stars 3.47k forks source link

503 Service Unavailable reading XLSX of 140MB #2495

Open Aurugorn opened 2 years ago

Aurugorn commented 2 years ago

This is:

- [x] a bug report
- [ ] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

To render the XLSX properly $spreadsheet = $reader->load($filename);

What is the current behavior?

Timeout 503 service unavailable.

What are the steps to reproduce?

Create 140mb+ XLSX file, read with PHP

Please provide a Minimal, Complete, and Verifiable example of code that exhibits the issue without relying on an external Excel file or a web server:

<?php

require __DIR__ . '/vendor/autoload.php';

// Create new Spreadsheet object
$filename = 'path/to/xlsx';
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet = $reader->load($filename);

Which versions of PhpSpreadsheet and PHP are affected?

Latest

jatindergit commented 2 years ago

I am facing the same issue when uploading only 4 mb of file. image php 7.3 "phpoffice/phpspreadsheet": "^1.23"

MarkBaker commented 2 years ago

There's a big assumption you're making here; and that's the assumption that I can figure out what the problem is without any more information to go on., such as a sample file