Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know. I've been writing professionally about computers, the internet, and technology ...

ExcelTable is a pipelined table interface to read Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods), and flat files (delimited or positional) as if they were external tables.

There are some additional functions for workbooks and worksheets, as well as support of further data types. The biggest change is the full capable reader support for workbook, worksheet and style ...