Features: export to Excel

Since version 4.0 you can use PrintDecisionGrid component to move DecisionGrid's cross-tabular data to the most popular spreadsheet application Microsoft Excel, version 95 and later.

1. As Report (for printing and presentation purposes).
2. As PivotTable (for analysis cross-tabular data outside your program).
3. As plain text using Clipboard (for fast copy data without formatting).

Each export method creates in memory instance of Excel.Application object, adds new destination worksheet(s) and fills it accordingly method's features. When output output xls file doesn't exist it is created. When it exists and already has worksheet with the same name as destination worksheet, the name of destination worksheet will be changed by adding incremental counter (PDG, PDG1, PDG2 etc.). When export is about to finish, it saves all the chages in output file.