Microsoft Excel workbooks and spreadsheets are widely used to build data analysis, and reporting applications. Many SMEs use these applications to manage structured data at different organisational levels. Project pilot owners agreed to use Microsoft Excel spreadsheets to manage some of the data that needs to be integrated in the requested applications.
The following Excel File Connector is a REST API that helps to import data through Excel files. The Excel File Connector parses spreadsheets in various Excel Workbook formats (eg, XLS and XLSX) as well as other related formats (eg, CSV) and serialises them in JSON format