Custom Format for Data in gridview

[Usman]

How can i generate a custom format of the data that is displayed in the gridview?

for example, i want to generate a timesheet for employees in my organization, the first line of the sheet should be the name of organization, second line should be the name of the employee and then the gridview should be binded with the database.

i also want to export data from this gridview to excel sheet. 

format image is attached bellow

can someone help me?

 

[Dimitar]

Hi Usman,

Thank you for writing.

You can build a form which contains a grid along with the other fields (if they are needed at this point). Then you can export the grid with the new spread exporter. This will allow you to edit the exported document by using our Spread Processing Library and add the additional fields to the document. More information is available in the following articles: 

• Spread export
• Add Header and Footer to the Exported Document
• Spread Processing
• Insert and Remove Cells
• Get, Set and Clear Cell Properties

I hope this information helps.

Regards,
Dimitar
Telerik

[Usman]

thank you so much for your response. 

the grid view spread exporter is present in which library?

its giving me error namespace not found. i have included the reference but still no luck.. any help?

[Dimitar]

Hello Usman,

Thank you for writing back.

You should add a reference to the TelerikExport assembly. In addition, you may need to include the SpreadProcessing assemblies as well. The following article shows which assemblies you should reference: Getting Started.

Let me know if you have additional questions.

 

Regards,
Dimitar
Telerik