6 Answers, 1 is accepted
I would suggest to take a look at the Export Detail Grids how-to article - the example demonstrates how to export detail Grids to Excel and merge their workbooks with the master Grid workbook.
As for exporting initially hidden columns I would suggest to take a look at the http://dojo.telerik.com/UJUcU example.Regards,
Thank you for the code but I realised that hen I have a empty column, It's not exported ,
This is my code,
thank you in advance,
I am not sure that I understand the current scenario here - an empty column is a column without any data or a hidden column? Could it be possible to send the response from the server in order to replicate the problem? Any additional information will be very helpful.Regards,
In my case a hidden column could be empty.
Also when applying the code you have provided for me , certains column disappear after extracting to excel and appear again only if I refresh the page
I extract data from the DATABASE with the code below.
public List <
var client = from c in _context.Clients
select new Models.Clients
Code_Client = (String)c.Code_Client ,
Nom_Client = (String)c.Nom_Client,
Groupe = (String)c.Groupe,
Secteur = (String)c.Secteur,
Marche = (String)c.Marche,
Nb_Employe = (String)c.Nb_Employe,
Ca = (String)c.Ca,
Type = (String)c.Type,
Commentaires = (String)c.Commentaires,
Sous_Secteur = (String)c.Sous_Secteur,
Contact = (String)c.Contact,
Adresse = (String)c.Adresse,
Téléphone = (String)c.Téléphone ,
Cote = (bool) c.Cote,
Refere = (bool) c.Refere
After reviewing the code in your previous post I can see that after the excel export the hidden columns are not hidden. The approach shows how to show the hidden columns just for the excel export and then hide them again. Please refer to the code snippet that should be used:
Thank you for the details provided.
In order to include hidden columns in the Excel export, I would recommend using the implementation from the following knowledge base article:
Give a try to the implementation above and let me know if further assistance is needed.
Тhe web is about to get a bit better!
The Progress Hack-For-Good Challenge has started. Learn how to enter and make the web a worthier place: https://progress-worthyweb.devpost.com.