Category Archives: Web Tools

phpspreadsheet Allowed memory size of xxxxx bytes exhausted

This error could be found in laravel log

Solution: Change memory limit in PHP

Reference:

  1. https://www.drupal.org/forum/support/post-installation/2013-02-12/solved-fatal-error-allowed-memory-size-of-33554432-bytes

jQuery Datatable reload()

Example:

Reference:

  1. https://datatables.net/reference/api/ajax.reload()
  2. https://stackoverflow.com/questions/42905454/datatables-ajax-reload-loses-page

Set explicit value of a cell (alphabet coordinate)

By data type

https://phpspreadsheet.readthedocs.io/en/latest/topics/accessing-cells/

Datatable with buttons

Download with extensions

https://datatables.net/download/

HTML

Javascript