I have defined a title and a header for a particular view. Neither is output, only the fields are output and they show up as a table (even in a DOC).

How can I get the output to look like the page view I have which has:

Label1: Field1
Label2: Field2
LabelX: FieldX


mdlopresti’s picture

I'm not sure but I'm having the same issue. I think its a theming template issue but I am still a noob.

The default views template of the header area looks like this

see views-view.tpl.php line 36

<?php if ($header): ?>
    <div class="view-header">
      <?php print $header; ?>
  <?php endif; ?>

But this module's theming calls the $header and $footer variables to add the wrapping elements around the body.

see views-data-export.tpl.php

<?php print $header ?>
<?php print $body ?>
<?php print $footer ?>

This template is used on every data export type. I think the solution might be to break the wrapping elements off of into separate .tpl.php files for each data type. Then ensure the $header variable is being passed the normal data and place it within a conditional statement with a validator to ensure the data being rendered won't break the format.

But again I'm still a noob.

mdlopresti’s picture

Also I am using 7.x-3.0-beta6

Steven Jones’s picture

Category: bug » support
Status: Active » Fixed

You should be able to use the header specific template: views-data-export-doc-header.tpl.php to change the header output of a DOC export.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

jvieille’s picture

Status: Closed (fixed) » Active

I have the same problem. the Views header and footer are not output

To address this issue, I used the $static variable to output a header with the first row - adding a php customfield with this code:

if (!isset($static)) print "your header";
$static = true;
Steven Jones’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

sadanand kenganal’s picture

I have written #5 code. The code works fine. But the header text(value) is not displaying in the doc or(Any other format). Please help me. How to do ?.

sportel’s picture

Issue summary: View changes
Status: Closed (fixed) » Active

I'm not sure why this issue status is set to 'fixed'. Since the header is still not showing, the problem still exists.
@Steven Jones: you suggest we do something with the views-data-export-xls-header.tpl.php? Could you explain what?



silurius’s picture

Also experiencing this issue under 7.x-3.0-beta7.

silurius’s picture

Category: Support request » Bug report
nbouhid’s picture

May this be a lack of memory issue? Are you using memcache or something similar? How many memory limit do you have set for PHP?

silurius’s picture

Mine is set to 512M and I'm not using memcache. Edit: should have also mentioned that PHP out of memory errors are not showing up in the server log.

nbouhid’s picture

silurius, are you able to test it with more amount of memory assigned (like 1gb)?

silurius’s picture

Yes, I upped it to 1GB and still the exported XLS shows only view row output, not header or footer content. But I really doubt it's related to the php memory_limit setting, because (1) when php memory is exceeded there are symptoms on the frontend (slow performance, sometimes blank pages or error pages) and (2) whenever php memory is exceeded, the event gets reported in the php error log, which is not the case here.

Steven Jones’s picture

Category: Bug report » Support request
Status: Active » Fixed

So if you want to change the header then you just need to find the file called:


And copy it to somewhere in your theme (beware if you're using the admin theme to do your data export) and then flush caches. This template will then get picked up an used.

Just tested this, and it's working fine for me.

silurius’s picture

Status: Fixed » Needs work

Thanks, Mr. Jones. Unfortunately, I did exactly this (taking care to ensure that tpl files were in the correct theme/templates folder), retested and nothing appears to have changed.

1. Copied views-data-export-xls-body.tpl.php, views-data-export-xls-footer.tpl.php and views-data-export-xls-header.tpl.php files into theme's "templates" sub-directory.
2. Double-checked that display filters (including exposed) matched attached data export filters exactly.
3. Added a Global:text field to header area of data export display, put some text in there.
4. Cleared all caches.
5. Pulled up results in view display.
6. Downloaded to Excel, and no header content is visible.

Steven Jones’s picture

Status: Needs work » Fixed

So, because of the nature of creating export files, the view 'areas' like headers, footers etc configured in the UI will not work, sorry.

You actually need to edit the actual file: views-data-export-doc-header.tpl.php

And add the things you want in there.

heshanlk’s picture

The only working solution for me was editing the views-data-export-doc-header.tpl.php file. We have the access to the $view object there so we can use dynamic values. Thanks.

omar’s picture

@heshan.lk Feel like pasting some code in here for others to use?

heshanlk’s picture

Status: Fixed » Closed (won't fix)

@omar, I have a very specific solution I did. What you all need to do is create a template file for your header, body or footer in your theme folder and update the markup. Thanks.

jpparisi’s picture

Just wanted to post this in case anyone else gets stuck. You can add similar code to a separate template file and it will print the region as you would expect. In my case, I was trying to add a footer to my CSV.


 * CSV files don't really have a footer.

print $view->display_handler->render_area('footer');
doitDave’s picture

Status: Closed (won't fix) » Active

Sorry, with all due respects to the great work that already has been done here, I also clearly consider this not fixed. I cannot go along with the point that (so I understood it, correct me if I got it wrong) "this is a data export and thus no header or footer", because it does not respect all possible use cases.

I figure this is due to the module's history, which, IIRC, started with CSV and XML - in that regard, the said argument is right (but then you should at least not include "DOC", but move such displays into another dedicated child module IMO). But while you do want to provide Word docs and other data types which include some kind of end user presentation, custom header and footer (without having to dig into code, or templating) is simply what anyone configuring the view would expect. And if no one intuitively expected this behaviour, we would never had this here issue opened. Would you really disagree on this? Would it hurt anyone to improve the module design in this regard and thus make it even better?

I know, there's different opinions on template-hacking being "the Drupal way" or not, however, making things more intuitive is for sure never a bad idea, right. Also keep in mind that simply not everyone has the means to "quickly" hack templates or any prod sources. And then think of multisite installations, with probably 20 different instances sharing your module. No, you do not want this. So please, no forced template hacking. Thanks.

No offense, au contraire, your module is a great tool I would not want to miss -- but also not to "hack". There is really enough "quickly hacked" stuff all around already. Isn't it. :)

Thx for reading!

alibama’s picture

is this getting fixed in 7.x-4.x? hack the template != fixed ;) anyhow, it's a great (crucial) module, and this is no disrespect. it'd be great to have a working solution though