Excel Read
GoAnywhere 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 IBM System i, IBM System p (AIX), IBM System z (Mainframe), Windows, Linux, UNIX, HP-UX, Mac OS and Solaris platforms. System i is also referred to as iSeries, as400, as/400 and i5.
