Excel Read

GoAnywhere can read data from Excel 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
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 can be installed onto IBM System i, Windows, Linux and UNIX platforms.  System i is also referred to as iSeries, as400, as/400 and i5.