Features:

• Imports Data Directly from virtually any corporate database, spreadsheets, database files, PDF files, HTML files and more
• Extracts Data from Report Files produced on any mainframe, midrange, client/server or PC system
• Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls) spreadsheets so you can work with your data in the format you want
• Supports SharePoint® repositories, including access and export
• Works with Data in Monarch Pro to sort, filter, analyze, visualize and export data to a spreadsheet, database and other application
• Creates New Views of Data using data extracted from existing reports, combine report-based data and/or database data
• Easily Combines up to nine different data sources in one Monarch Pro session
• Is Windows Vista™ Ready

Benefits:

• Easily Integrates Data from existing business systems with desktop applications such as Microsoft Office, with no programming needed
• Ends the Need to Re-Key Data from thick printed reports. With Monarch, the report becomes live data
• Reduces Need for Custom Database Queries and Report Writing—a true self-service data access and analysis solution
• Allows use of Trusted Data Sources such as financial statements, reports, etc. for auditing, accounting, financial analysis, inventory analysis and more
• Provides Ability to Quickly and Easily Combine Data from multiple sources without programming

New to Monarch Pro:

• Linking Objects
• PDF Improvements
• Import Using OLE DB
• Import OpenXML Spreadsheets
• Enhanced Database Filters
• Import Multiple Delimited Text Files
• Import Excel Files with No Header Row
• Ability to force Data Types to Character
• Replace Nulls on Import
• Multi-Select Project Exports

New to Both Monarch Standard and Monarch Pro:

Report Window

• Report Window Exports
• Increased Number of Allowed Templates
• Increased Number of Lines in a Template
• Not Traps
• Trap on Lines Other than the First Line with Footer Templates
• Page Break on Hidden Leading Text Option
• Next Report/Previous Report Icons
• Bookmark Improvements
• Increased Number of Items in Recent Reports

Table Window

• User-Defined Functions
• Opening of Models without Data Sources
• Test Function for Calculated Fields and Filters
• Increased Number of Characters in an Expression
• Calendar Control for Inserting Dates
• Increased Number of Arguments for Min and Max Functions
• Improved Duplicate Handling
• New DateAdjust Function
• Maximize the Expression Editor
• Lookup Field Enhancements

Summary Window

• Quick Summary Design
• Summary Start Tab
• Summary Design Preferences
• Excel Subtotals and Grand Totals as formulas
• Enhanced Options for Measure Value Matching
• Hiding Summary Elements
• Excel Conditional Formatting Rules
• Excel Outlining
• Header Lines
• Multiple Blank Lines
• Increased Limits on Labels
• Increased Number of Item Fields

Table and Summary Windows

• New Excel Export Engine
• Export to OpenXML Spreadsheet (xlsx)
• Excel Autofilter
• Excel Freeze Panes
• More Control Over Exporting Null Values to Excel
• FirstValue of Field Macro

General

• Object Comments
• PDF Security Options
• Tip of the Day
• Customizable Toolbar
• Enhanced Default Folder Options
• Project and Model Portability
• Sharepoint Support
• Publishing Passwords Stored in Encrypted Form
• Saved Dialog Settings