In order to test a layout, you have to upload another source file. When a layout is tested, it parses the uploaded file as per the structure defined in the layout and generates the output and error files.
Follow the below steps to test the Excel layout:
- Click the Test Schema
button from the toolbar. This displays the defined excel layout.
- Click Test File
button and browse the file which you want to upload. Ensure that the uploaded file extension is .xls/.xlsx. - This will test and display the uploaded file according to the defined layout.
- You can view the record which are parsed successfully in XML View tab and click Error View tab to see the error records.
You can also download the XML file by clicking the Download XML
button.