Header with with Excel export

Suite and Optimus Suite 5
#1

Just tried PDF and Excel export (had to move the code around a little bit, to make it work with Zend framework) with PHP - it works beautifully.

However, there are some minor problems that I don’t know how to fix. Need some help :frowning:

  1. PDF export - while the row data is automatically word wrapped, the header data isn’t. It is all overflowing into next cell, and in general unreadable. IS there any way to fix it? I tried CSS word-wrap property, but it didn’t work.

  2. Excel export - this works quickly for smaller tables, but if the table is even a bit large - say around 100 rows and 10 columns, it takes 7-8 seconds and more. IS there anyway to speed it up?
    Also, how to add a visual indicator to the user, so she knows the table is being generated?

  3. Is there any way to add generic footer - “generated from xyz.com” or something like that?

Thanks.

#2

(1) Non-wrapping text content for the header is expected behavior, but it must not overflow a next cell, we will investigate this issue.

(2) by default excel export uses binary format, you can try to use excel-html instead

Try to use the next url for the export ( as param of toExcel )
dhtmlxgrid.appspot.com/export/html

This functionality exists in latest php version as well

$xml = simplexml_load_string($xmlString); $excel = new gridHTMLGenerator(); //export to excel through html $excel->printGrid($xml);

(3)
Only through code modification.

#3

Hi,
please, try to update grid-pdf-php from attachment.
It should fix overflow problem for PDF-headers.
grid-pdf-php.zip (982 KB)

#4

For generic footer, try using
attachFooter() or setFooterLabel() functions