In one of my projects, I am using the PHPExcel package to load data from .xlxs files. The smaller files load without any problem. The larger files (1-2 MB) exceed the PHP memory and execution time. I have tried increasing both using ini_set but it still takes to long and the browser then times out.
After some reading on the PHPExcel library, it states the ability to use cell caching and some other settings configurations.
How do I implement these while using PHPExcel in a DHTMLX connector? Is this my only option to load larger .xlxs files to a grid?
Here is my current connector code:
ini_set('memory_limit', '256M');
ini_set('max_execution_time', 300);
$dhx_conn = '/dhtmlx/connector/';
// PHPExcel files
require_once($dhx_conn.'PHPExcel.php');
require_once($dhx_conn.'PHPExcel/IOFactory.php');
// Connectors
require($dhx_conn.'db_excel.php');
require($dhx_conn.'grid_connector.php');
$grid = new GridConnector('../../../_apps/bills/Test.xlsx', 'ExcelDBDataWrapper');
$gridConfig = new GridConfiguration();
$gridConfig->setHeader($grid->sql->excel_data(array('A1','B1','C1','D1','E1','F1','G1','H1','I1','J1','K1','L1','M1','N1')));
$grid->set_config($gridConfig);
$grid->render_table('A2', 'id', 'A,B,C,D,E,F,G,H,I,J,K,L,M,N');Thank you