Microsoft Excel is a powerful business tool with many advanced charting, graphing, and algorithmic/statistical capabilities, making it a favorite among business users. It has been estimated that 50% of the world’s business logic is contained within Excel spreadsheets.
Traditional data integration into Excel usually takes the form of
- Hand entry of data from a paper source
- Data imported from another file (database, spreadsheet, delimited text file, etc.)
- Date pulled by an intermediate program from another source (Visual Basic, macro, etc.)