Working with Excel Documents

Displaying Excel Documents

The ImGearExcelBookDocument and ImGearExcelSheetDocument objects can be created and processed in any thread with any apartment state: STA or MTA. If they also need to be displayed, then there are some concepts which should be taken into account:

In WPF display scale mode the calling thread must use the STA apartment state, which is a requirement of Windows Presentation Foundation. ImageGear will create a WPF Canvas in the context of this calling thread to render the document pages for display.
In Native display scale mode, which is the default for ImageGear, there are no restrictions for displaying Excel pages in a multithreaded environment.

Additional Information

The following topics are also covered in this section:

Below are the groups of the Open XML SpreadsheetML, which ImageGear supports (read only):

At a high level, the following SpreadsheetML features are not currently supported.

Excel files containing these features can still be loaded by ImageGear. However, the unsupported content will be ignored.

ImageGear renders only accepted revision changes of the document; i.e., if it has "Track Changes" enabled, please make sure to accept all/required changes in the document prior to opening it with ImageGear.

Formulas (The last cached value will be displayed, if available)
Table Definitions
Pivot Tables
Query Tables
Chartsheets
Dialogsheets
External Data Connections
Supplementary Data Connections
Custom XML Mappings

More information can be found about all of the above SpreadsheetML features in the ECMA-376 Specification.