I am trying to load excel files. Excel files are as such that data is sometimes in different sheet and data start row also might differ from file to file.
We have excel sheet index and data start row coming from another File. I am trying to do following: Create a raw file using transform node to dynamically create a workbookSpec property file (XML) and then load it in Excel node. However, I am getting following error while trying to do the same: "Error initializing the Excel Reader: Exception attempting to validate specification Validated against XSD: ExcelFileOutputSpec.xsd At Line 1, Column 1. Contained Exception: Content is not allowed in prolog."
Can you suggest an approach to dynamically load files with differing sheet index and data start rows.
Please sign in to leave a comment.