This is a migrated thread and some comments may be shown as answers.

[Solved] Export to excel

7 Answers 370 Views

Grid

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

7 Answers, 1 is accepted

answered on 19 Feb 2010, 08:02 AM

Hi Vincent Girard,

Currently built-in export to Excel capabilities are not in our plans. However it is rather easy to implement export to CSV format using the grid data. You can check this forum thread for a working example. If XLS or XLSX format is required perhaps this blog post would help.

I hope this helps,
Atanas Korchev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

Accepted

answered on 19 Feb 2010, 01:58 PM

Hello Vincent Girard,

The sample is made for the futures release 2010.1.218 and will require some modification to work with older versions:

VIEW:

<%= Html.ActionLink("Export to Excel", "Export", new { page = 1, orderBy = "~", filter = "~"}, new { id = "exportLink" }) %>

<script type="text/javascript">

function onDataBound() {

var grid = $(this).data('tGrid');

var $exportLink = $('#exportLink');

var href = $exportLink.attr('href');

href = href.replace(/page=([^&]*)/, 'page=' + grid.currentPage);

href = href.replace(/orderBy=([^&]*)/, 'orderBy=' + (grid.orderBy || '~'));

href = href.replace(/filter=(.*)/, 'filter=' + (grid.filterExpression || '~'));

$exportLink.attr('href', href);

}

</script>

<%= Html.Telerik().Grid(Model)

.Name("Grid")

.Columns(columns =>

{

columns.Bound(o => o.OrderID);

columns.Bound(o => o.ShipAddress);

columns.Bound(o => o.CustomerID);

columns.Bound(o => o.ShipCountry);

columns.Bound(o => o.OrderDate);

})

.Pageable()

.Sortable()

.Filterable()

.Ajax( ajax => ajax.Action("IndexAjax", "Home"))

.ClientEvents(events => events.OnDataBinding("onDataBound"))

%>

Controller:

public ActionResult Export(int page, string orderBy, string filter)

{

//Get the data representing the current grid state - page, sort and filter

GridModel model = Model().ToGridModel(page, 10, orderBy, filter);

var orders = model.Data.Cast<Order>();

Regards,
Atanas Korchev
the Telerik team