CompletIT Community Server

Hi,

Is there a way to programmatically create a title that will appear at the top of Excel and PDF reports?

If not, I guess I will add the title to a cell in the top row(s) of the dataGridView just before the export (which I'm doing with my own button instead of using the widget), and then remove it after the export is complete. 

I'm just wondering if there is another way.

 Thanks

Hi djohnson60618,

Yes, it is possible to define the title of the exported grid view. You just have to create and pass the appropriate settings that should be used during the export to Excel or Pdf.

For example:

//Create the settings and initialize it with the appropriate values
DGVEPdfExportSettings settings = new DGVEPdfExportSettings();
settings.ExportHeaderText = true;
settings.HeaderText = "Some sample header text";
//.....

For more information and samples read chapter 3.3 Pdf from the Developers Guide.

If you have any other questions do not hesitate to contact us.

Sincerely Yours
Support Team

I don't have the ExportHeaderText and the HeaderText properties in the DGVEExcelExportSettings object, I don't know why.

I was able to set the headertext with the DGVEPrintSettings but not with the DGVEExcelExportSettings. I'm using VB.

I also need to give some format to the exported excel like the Autosum, is that possible?

Thank you very much for your time.