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.
1 Answer
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.
-
yes I did, I use it now. But the outcome is the same - html code inside a xls file.– loparrOct 22, 2012 at 19:33
-
1I've just found this: Why are the XLS/DOC export files just HTML tables? Depending on your needs you may export to CSV, this format is easily imported into Excel.– sanzanteOct 24, 2012 at 8:10