Exporting to Excel/CSV and PDF

[Pablo]

Hi!

I have a question that I'm not sure if this is the place where it should be asked... 

We are developing a Silverlight app as well as an WPF app, and we need to create Excel and PDF reports from code. Is there any component or control that Telerik may have to do this (we are already using RadControls for WPF/SL, but as far as we have seen no support for this aside from GridView export-to options)? 

By now, we are exporting to CSVs and creating PDFs with a free library which support is already gone (no development since 2009, it's called MigraDoc/PDFSharp). I've seen some commercial libraries that support this functionality, but I was wondering whether Telerik has any of these. 

Thank you in advance!!

Pablo.

[Dimitrina]

Hello Pablo,

With the Q2 2011 version of the RadControls, you may use the RadDocument for exporting to PDF. This is possible with the RadRichTextBox. You could review the online demo for an example on how you could export to a PDF.

The exporting to Excel and CSV is currently done by the Export method of the RadGridView.

I hope that this is helpful.

Kind regards,
Didie
the Telerik team

[Pablo]

Hello Didie, 

sorry for not answering before. 

I'll have a look at the PDF sample.

Regarding Excel... we'd like to be able to build a complex Excel file and be able to add Excel charts, images and and custom formatting. Export in GridView just throws the data to an Excel file, but doesn't allow any other manipulation. So should we look for other components that allow us to do this? We really want to avoid using the Excel-automation option.

Thank you very much. 

Pablo.

[Dimitrina]

Hi Pablo,

 As the formats that the RadGridView uses to export to Excel are HTML and ExcelML, this would not be possible. These formats do not support the embedding of such elements.

For more advanced needs, I will suggest you to check the Telerik Reporting.

Kind regards,
Didie
the Telerik team