Hi.. i am using xamdatagrid and export to excel.Its working fine .But i want to change the format of the excel.I am sending the excel file format.Highlighted one(yellow color) i am displaying in textblock above xamdatagrid.Rest of the things i am geting clearly.can't we give bold for header.Plz solve this problem.
Hello Shankar,
Thank you for your post. I have been looking into it and I created a sample project for you with the functionality you want. Basically I handled the Exporter’s ExportStarted event and format the worksheet before the Exporting of the XamDataGrdi starts. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
Thanks sir... its working.but how to make header bold.How to make it header bold.It is generated through xamdatagrid know.
I have modified the sample I sent you before, so now it has the functionality you want. Basically I handled the DataPresenterExporter’s HeaderLabelExporting event and set the FormattSettings’ FontWeight to Bold. Please let me know if this helps you or you need further assistance on this matter.
Thanks... it solved my problem..
Hello,
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
You can see how to set custom Excel Cell Style in our Feature Browser under xamDataGrid / Style / Custom Excel Export Styling section.
Hi... Can i make the excel format what i am sending.I am sending application in which it contains format.xls and i want format like that.Plz help me in solving this....