New to Telerik UI for ASP.NET Core? Download free 30-day trial

ASP.NET Core TreeList Excel Export

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Telerik REPL
Change Theme
default
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Ocean Blue A11Y

Purple

Turquoise
Bootstrap Theme

Main

Bootstrap 3

Bootstrap 3 Dark

Main Dark

Nordic

Turquoise

Turquoise Dark

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Material 2

Material 2 Dark

Nova
Classic Theme

Main

Green

Green Dark

Lavender

Lavender Dark

Main Dark

Metro

Metro Dark

Moonlight

Opal

Opal Dark

Silver

Silver Dark

Uniform
Fluent Theme

Main
Launch Theme Builder

HtmlHelper
TagHelper
Files:
                    excel_export.cshtml
                
                    Excel_ExportController.cs
                
                    EmployeeDirectoryController.cs
                
                    EmployeeDirectoryModel.cs
                
                    Excel_Export_TagHelper.cshtml

Also available for:

CLIENT-SIDE API HTML HELPER API

(typeof KendoLicensing === 'object' && KendoLicensing.setScriptKey('141j041f611f063e0837023e133i0i490g310c3a18445h425d3857365b3359385c365c455g1a600i4d0445041j0820161k145i1825195k3h4i05280a1i0j20165k3h4k49500f1d0h1g182216243e22161e115e415g455i455c410e223a265h0i572d402j59163i0243234g4116592h3901562j08521j4d4319591b3d245030371i57034g265e1658215j3a29502g5f2k462d4726512j084e2e521c132c3k204c0a4k46084g23381j32123324532f083b0e46521c4j243826452j5c14552a4j24133i305k0h59174a284219391b3301392h591a3a5k19452b3d103e1a560d300b4e23380227612155480h41005g2a5727330b4h293a0j3c013c0h3j16234g0e3c28612e591a3j2e600k440c422i59085616410h5h024427012b5i255k0g4808365c2g602h08370h4b2d5g034g410c4b114h22322f3a0g1d5b014e3h063d114117204f0951460k1h5a043a5i28033g165j3a0g511i3k18460f3058082f3i084b0661294j2k0b372i51074a1f3g5i1c3d144d22612b0c1d3821552f4a104e4153063e0e4230560a3h105k3f5g2807410j4d234126052d4h0d431g3i2158133a2g0b2j3d4d1149305e2a3j0a2f4i204e12315b163i2h5e341h42055e0j1d5c2d5a1g5k2d542k544b224a2b5e2k472e49151d0i1b462252065a1i3g6116430g47095i3e600j3j1b3g303c245g2b032b571k4d0b4018391k322c382a5i185a11581d32203a144c3e0i48534721352d3g210i3e224j03355d2j0b4g431351072947214d1b41134c0d410137293b23590k581c4g1k60284024310a361a3f04365d381j51195b311h3c1j3j2h0c5h1b5f174a283k300859375a3423371b0k3f1b4g023e1k332546005a1k370h475229484g3j0d4d0f5e34552d4d0k23195k1k6016244a094g101c422j0g4i2438094d2c5i330h4f1j3d2a5a321e4h0g1k4e1g3e225f3111613a0d5e235g2h3d1d165j08571b5h3a1c5a3658295h1d311j17440i450d2f5h0a3a2356074412590a450h4i351435'));kendo.syncReady(function(){jQuery("#treelist").kendoTreeList({"columns":[{"field":"FirstName","title":"First name","width":"220px","filterable":true},{"field":"LastName","title":"Last name","filterable":true},{"field":"Position","filterable":true},{"field":"Address","filterable":true}],"excel":{"fileName":"Kendo UI TreeList Export.xlsx","proxyURL":"/aspnet-core/treelist/excel_export_save"},"height":540,"sortable":true,"dataSource":{"type":(function(){if(kendo.data.transports['aspnetmvc-ajax']){return 'aspnetmvc-ajax';} else{throw new Error('The kendo.aspnetmvc.min.js script is not included.');}})(),"transport":{"read":{"url":"/aspnet-core/employeedirectory/all"},"prefix":""},"schema":{"data":"Data","total":"Total","errors":"Errors","model":{"id":"EmployeeId","fields":{"EmployeeId":{"nullable":false,"type":"number"},"FirstName":{"nullable":false,"type":"string"},"LastName":{"nullable":false,"type":"string"},"ReportsTo":{"nullable":true,"type":"number","defaultValue":null},"Address":{"nullable":false,"type":"string"},"City":{"nullable":false,"type":"string"},"Country":{"nullable":false,"type":"string"},"Phone":{"nullable":false,"type":"string"},"Extension":{"nullable":false,"type":"number","defaultValue":null},"Position":{"nullable":false,"type":"string"},"BirthDate":{"nullable":false,"type":"date","defaultValue":null},"hasChildren":{"nullable":false,"type":"boolean"},"HireDate":{"nullable":false,"type":"date","defaultValue":null},"CountryFlag":{"nullable":false,"type":"string"}},"parentId":"ReportsTo","expanded":true}}},"pageable":{"autoBind":false,"buttonCount":10},"filterable":true,"toolbar":{"items":[{"name":"excel"}]}});});

Description

Out of the box, the Telerik for ASP.NET Core TreeList component enables you to export its data to Excel. Under the hood, the Excel export functionality builds a kendo.ooxml.Workbook. Prior to the export itself, you can further modify the file by using the built-in configuration options of the TreeList, such as exporting multiple pages, modifying the name of the Excel file, saving the exported file on the server, and more.

This demo showcases how to enable the Excel export functionality through the Toolbar() configuration option and, also, how to change the name of the Excel file on the server by setting the ProxyURL() and FileName() configuration methods.

Additional Apps

This TreeList example is part of unique collection of hundreds of ASP.NET Core demos, with which you can see all Telerik ASP.NET Core components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in Telerik REPL for ASP.NET Core or ThemeBuilder.

ASP.NET Core TreeList Excel Export

Description

Additional Apps

Support & Learning Resources

Additional Resources