This topic is locked
[SOLVED]

 Disable Excel export radio button

5/12/2017 12:10:32 PM
PHPRunner General questions
B
buddymoots author

Is there a way to disable the Excel export radio button on the export page so only
Word

CSV (comma separated values)

XML
appear in the export options?
The reason I ask is that the export works but is large when using Excel format, the server runs out of memory. The other formats work fine.

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 32 bytes) in /plugins/PHPExcel/Style/Border.php on line 374
mbintex 5/13/2017

you could edit
bsexportoutput.htm
and delete

<div class="row">

<div class="col-md-4">

##if @ext=="php"##

{BEGIN groupExcel}

<INPUT TYPE="radio" NAME="type" VALUE="excel2007" CHECKED {$excelradio_attrs}>

<span> <img src="images/excel.jpg" align="absmiddle" alt=" ">&nbsp;Excel 2007</span>

{END groupExcel}

##else##

<INPUT TYPE="radio" NAME="type" VALUE="excel" CHECKED {$excelradio_attrs}>

<span> <img src="images/excel.jpg" align="absmiddle" alt=" ">&nbsp;Excel</span>

##endif##

</div>

</div>


But then you would never have Excel anymore until you change it again.
Since if clauses are possible in these templates, one could perhaps make that more versatile.

admin 5/13/2017

You can remove 'Export to Excel' option in Visual Editor but better option is to increase memory_limit variable in php.ini so export doesn't break.

B
buddymoots author 5/19/2017

Thank you guys.
I increased the memory to 1Gb but it still consumes and errors. All the other exports work even at 128Mb, so I'll set the memory back and remove the option in the editor to download Excel.