IOOXmlSupport example

Posted by: mikelodder7 on 8 September 2017, 2:55 pm EST

  • Posted 8 September 2017, 2:55 pm EST

    I am trying to implement the interface IOOXmlSupport while extending the CurrencyCellType for more control over my Excel exports.  All of the interface properties and methods are pretty straight forward to implement except 'ExcelGetValue'. 

    What do I return? There is no way to find out that I can see to get the current cell that it is asking for.  I can't see any methods to call in the base class.

    Is there an example anywhere? 

  • Replied 8 September 2017, 2:55 pm EST

    Normally, the cell's value is exported to the Excel file. In a few cases, it is more desirable to export a property of the cell type object instead of the cell's value. For example, consider the HyperLinkCellType where the cell's value is a boolean value indicating visited status. In the case of the HyperLinkCellType, it is more desirable to export the cell type's Link property than to export the cell's value. In this type of case, a custom cell type can implement the IOOXmlSupport's ExcelGetValue property to return a non-null value from the cell type to be exported instead of the cell's value.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels