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
0
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
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.