Excel Integration

Excel Integration

Use Excel for file interchange or data takeon.

Excel Icon

Excel Data

Outside of email Excel is worlds most used business application, with an estimated 10 million excel programmers in the world. It’s wide spread use, and columnar format makes it perfect for data interchange, especially for data take-on exercises.

IMan provides you with full capabilities for consuming and producing Excel data. You can integrate almost Excel file producing application with Sage Enterprise Management (formerly SageX3), Sage300, Sage200, SageCRM & SagePay.

  • Bi-Directional – Read & Write Capability

    With IMan you can consume and produce flat or a multi-level hierarchical Excel data.

  • File, Email & Webservices

    Excel data can be read from/written to files, as attachments in Email or from and to simple REST webservice endpoints.

  • File Format Support

    IMan supports Excel 97-2003, 2007 and OpenOffice formats.

Read Capabilities

IMan provides you the tools to quickly consume Excel data of any almost form.

As long as the data is structured and on a single worksheet. It’s just point and click.

  • Full Hierarchical Data Support – Data can be hierarchically arranged with by the order of the rows within the file OR by values within data.
  • Consume 100’s of thousands lines in any single batch.
  • Field and schema detection – Just point IMan at your Excel data and it will work out the fields and the hierarchical elements.
  • Consume multiple files or attachments per integration.
  • Support for header & footer lines.

Write Capabilities

  • Full Hierarchical Data Support
  • Control over output – Write/don’t write field headings, values in quotes, line endings, file/attachment names, etc.
  • Ability to create files/attachments/posts per transaction i.e. a file per order, a POST per invoice or shipment.
  • Templated Output – Allows you to preformat an Excel sheet for prettified report distribution.

Request a demo of IMan today

If you have an integration requirement and would like to see IMan in action, please get in touch.

Request Demo

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close