How to implement the functionality of printing (exporting to Excel) data from CGridView tables in Yii?

Question

Yii

Hello,
The task is to implement the functionality of printing and exporting data from CGridView tables to Excel. The data in the tables is different, also in many tables there are separate filters, pagination, and so on.
How to transfer data from tables to a method that will implement the export functionality?

Answer 1

CGridView takes data from a DataProvider prepared with "filters, pagination and other things" in mind. Here from the same provider also scoop out the data for other representation.

Answer 2

Create the same action as for CGridView, only pass the data not to the view, but to some library. For example like this: tyts .