Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to hide page header and footer during the Excel file export with unoconv?

I've tried to use a template (narrow margins, disabled header, disabled footer), but it does not work. I mean: margins become narrow, but I still can see header and footer.

Command I use to export:

$ unoconv -d spreadsheet -f pdf -t margins.ots -v document.xml

where

  • document.xml is XML structured Excel file
  • margins.ots is a template with narrow margins and disabled header/footer

Any help is greatly appreciated!

share|improve this question

It is not possible to hide Excel header and footer with unoconv. Instead, you should set them to empty strings in the Excel file itself before passing it to unoconv.

For example, if you generate Excel files with python xlwt, you can do this:

sheet = book.get_sheet(0)
sheet.header_str = ''
sheet.footer_str = ''
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .