Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
155
Excel formattedstring
posted

Hi,

I am trying to read an excel file and display the data from the excel file on to a WPF form. Is there anyway I can display the rich text (cell) content from Excel to a WPF form ?

I am able to retrieve the formatted cell content from excel and access the field which is of type Infragistics.Documents.Excel.FormattedString.  How do I display the formattedstring on a wpf form ? do we have any controls to display these type of fields ?

Thanks

Raghu

Parents
  • 17475
    Offline posted

    Hello Raghu,

    When it comes to importing and exporting rich text content I would suggest you to use the XamRichTextEditor as it was created to cope with rich text content: http://help.infragistics.com/Help/Doc/WPF/2015.1/CLR4.0/html/xamRichTextEditor_Managing_Import_Export_RTF.html#_Ref362603137. The documentation page above illustrates how the export and import could be handled within this control.
    If you prefer to use the Excel engine and create a workbook, you can use the CellFormat to format the content of the cell though it will not be a rich content:  http://help.infragistics.com/Help/Doc/WPF/2015.1/CLR4.0/html/IGExcelEngine_Copy_a_Cells_Format.html.

Reply Children