User:Barris Hartley

Excel Integration
New page - more edits to come http://office.microsoft.com/en-gb/excel/HA101656321033.aspx http://www.sage.co.uk/software_and_services/growth/sagebi_for_line_500__sage1000.aspx

The pervasive use of Microsoft Excel []across the world has brought about the necessity for Vendors of Software Packages and end users of these packages, to employ a method of achieving “Excel Integration”. From this necessity has emerged a specific technology that, in various forms and versions, has become established as Excel Integration. An early form of the technology was a simple “plug” or extract utility that was able to fetch data from a source, in most cases an Accounting package, and place it in an Excel Spreadsheet. The user would then utilse the functionality of Microsoft Excel to “cut and paste”, add formulae, macros and layout preferences before delivering the result as a report. Later versions were developed to filter the data extract and reduce, to some extent, the amount of time and effort needed to produce the final spreadsheet. Modern Excel Integration technologies provide extensive functionality in automating the integration to one or many ODBC compliant database sources. Single click interaction for instance, produces complete pre-defined Microsoft Excel output containing the current, real-time data. Excel Integration continues to expand in functionality incorporating all aspects of Microsoft offerings as well as tapping into the growing list of available communications including Internet and cellular technologies. Excel Integration is a living and expanding reality of modern information technology.