Totally New in Telerik need some advices :-)

2 posts, 0 answers
  1. MAE
    MAE avatar
    6 posts
    Member since:
    Oct 2016

    Posted 11 Oct 2016 Link to this post

    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 :-)

  2. Tanya
    Tanya avatar
    894 posts

    Posted 14 Oct 2016 Link to this post


    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, Set 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.

    Telerik by Progress
    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Back to Top