Sergey Shuchkin
Sergey Shuchkin
SimpleXLSXGen 1.2.16 https://github.com/shuchkin/simplexlsxgen https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_autoFilter_topic_ID0EIDM4.html#topic_ID0EIDM4 ```php $data = [ ['autofilter'], [1000], [2000], [3000], [4000], [5000], [1500] ]; $xlsx = SimpleXLSXGen::fromArray($data); $xlsx->autoFilter('A1:B5'); $xlsx->saveAs('autofilter.xlsx'); ```
fixed in 1.2.16 use `$xlsx->autoFilter('A2:B10');`
borders are not currently supported
> Do you plan to make an update for borders near future? Thanks. I know how, but don't have time now :|
class MyXLSXGen extends SimpleXLSXGen {}
:) you have to write this class
current supported formatting https://github.com/shuchkin/simplexlsxgen#formatting
1.2.15 only global font size supported $xlsx->setDefaultFontSize( 16 )
hmm if u want bowser dialog use $xlsx->downloadAs('request.xlsx'); exit(); if u want save xlsx in server specified path use $xlsx->saveAs('/backup/request.xlsx');
images - no new sheets - https://github.com/shuchkin/simplexlsxgen#more-examples