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.
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:
- Microsoft XLS.
- Microsoft DOC.
- Basic TXT.
This module also exposes a drush command that can execute the view and save its results to a file.