Excel Read
GoAnywhere Director™ can read data from Excel 2010 (and earlier) documents using a variety of user-specified options.
- Specify sheet name to read
- Row number where column headings are located
- Starting row number for data
- Field (column) types and sizes
- Trim options
- Formatting options for dates and numbers
- Null substitute values
- Pass in variables (at runtime) to override attributes
The data read from Excel documents can be imported into database tables or translated into other formats including fixed-width text, delimited text and XML formats.
GoAnywhere Director can be installed onto Windows, Linux, IBM i, AIX (pSeries), UNIX, HP-UX, Mac OS and Solaris platforms. IBM i is also referred to as System i, iSeries, as400, as/400 and i5.
