Limiting Parse Excel to CDT to only a set number of rows

Question

Using the new Excel Tools plugin, we are having users upload an excel following a template. We want to allow users to use up to a certain number of rows (lets sat hypothetically 100) and restrict them in some way if they try to upload more than that. We can of course parse all of the rows and then take only the first 100 of those, but we don't want to have to process 10000000000 rows and if someone should try that and crash our server. Restricting to the first 100 out of 10000000000 after the fact doesn't help. Our servers have still crashed. We need to stop the parsing from moving forward after 100, or find out before we run the node that it's going to be more than 100 and tell the user "NO". 
 From what I can gather the older version of Parse Excel to CDT, which was deprecated in favor of the Excel Tools plugin we're now using, had a Max Row value? Is there something now to prevent us from parsing the entire Excel if it's more than 100?

Josh · Answer

You will likely need to update Excel Tools to take in a Max Row value and apply the logic to stop parsing the file stream. A workaround is to validate that the file size of the uploaded document is less than a certain upper limit, ex. 10 MB.