This is a migrated thread and some comments may be shown as answers.

Totally New in Telerik need some advices :-)

1 Answer 19 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
MAE
Top achievements
Rank 1
MAE asked on 12 Oct 2016, 03:26 AM

Hi everyone , I'm novice using Telerik so I wanted to ask what Telerik Controls (for WPF purposes) do I need to use to export database (MYSQL) information (or simple text) to Excel format and what Exactly do I need to use or do in order PRE format the excel cells? For example , how to make my exported excel files have a pre defined background color , foreground color , alternate cell background colors , fonts , font size , etc

Right now I have zero knowledge in this topic so if you can explain me what to do with detail I'd really grateful :-)

1 Answer, 1 is accepted

Sort by
0
Tanya
Telerik team
answered on 14 Oct 2016, 01:07 PM
Hello,

You can use the RadSpreadProcesing library to create an XLSX document. You should create a workbook, add the worksheets you would like to use and set the values from the database by iterating through the worksheet's cells. For more information on how to apply different prop[erties to the cells, you might find helpful to check the Get, and Clear Cell Properties article. When you are ready with the content, you can export the document using XlsxFormatProvider.

We have several examples showing how to use the library in our XAML SDK repository on GitHub.

Hope this is helpful.

Regards,
Tanya
Telerik by Progress
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Tags
General Discussions
Asked by
MAE
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Share this question
or