How to allow NEW sheets (that we don't care about) to be added to the schema?

Posted by: kdunn on 3 August 2017, 2:34 pm EST

  • Posted 3 August 2017, 2:34 pm EST

    I have a schema that works.  It looks at the right sheets, however, the users sometime add a sheet to the end.  I don't care about the sheet, but when the dissembler runs it bombs because of the extra sheet.

     

    Is there a setting to say allow more sheet to be added?

     

    Thanks,

  • Replied 3 August 2017, 2:34 pm EST

    kdunn,


    Apologies for replying so late. Do you want Spread to parse the extra sheet added by your user OR do you want Spread to ignore the extra sheet?


    If it is former then unfortunately there is no way Spread can parse the file until and unless the extra sheet has been added in the Schema.


    If it is latter then yes there is a way. While creating Schema, in the SpreadSheet Schema Wizard, we need to select the Data Range and then Spread will only parse the data in this range and will ignore the remaining part. For e.g. if Excel file has 3 worksheets and I want to parse only first 2 sheets then I will select only these 2 sheets in the "Data Range" while creating Schema. Remaining all sheets (even though created by users) will be completely ignored by Spread.


    Let me know if you have further questions regarding the same.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels