3

I need to export views into xls file. If I use any of possible modules like views bonus or views xls export, I get a simple file with xls extension but inside is clean html code of the table instead of a compiled code as excell would produce. I can load it into excell and save it as proper xls file but is there a straight solution? Thank you.

3

Did you try the Views data export module? Here is a quote about it (from the module's project page):

... designed to provide a way to export large amounts of data from views. It provides a display plugin that can rendered progressively in a batch. Style plugins are included that support exporting in the following types:

  • CSV.
  • Microsoft XLS.
  • Microsoft DOC.
  • Basic TXT.
  • XML.

This module also exposes a drush command that can execute the view and save its results to a file.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.