i have a view in my project. And i want to import and export the views in Excel format. How to achieve this?
You can use views data export module.
This module is 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.