Enterworks - ETT 110 - How to Import a Multi-Sheet Excel Spreadsheet by Implementing a Pre-Processor

EnterWorks can import Excel spreadsheets, but is limited to the first worksheet.  There also may be cases where the Excel spreadsheet has a data grid that does not start in the first column.  Some spreadsheets may even present multiple data grids on the same worksheet.  Such Excel spreadsheets can be fully processed by EnterWorks by implementing and configuring a Scheduled Import pre-processor that extracts the data grids from the designated worksheets.  This session shows an example with source code and ready-to-use binary that can be deployed and configured in any EnterWorks environment.  This Tech Talk Session covers:

• How to Configure a Scheduled Import to use the MultiSheetExcelPreProcessor
• How to Set up dependent operations for the extracted files
• Demonstration of the MultiSheet import processing a multi-sheet Excel spreadsheet with one worksheet having two separate ""tables"" to be loaded into separate repositories.
• How to Deploy the MultiSheetExcelPreProcessor
• Review of the Java source code for the MultiSheetExcelPreProcessor

Prerequisites - ETT 053