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.
 
Excel


GoAnywhere Director can be installed onto Windows, VMware, 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.