Faults:
Existing code only looks at one worksheet, instead of all
Existing code does not account for rows without data
Headers shifted ("Company Name (* Denotes Covid 19 Related WARN)" vs "Company Name " (with a space)
Code should probably convert those two strings to just "Company Name" and pick it up in the transformer side as that.
Likely an easy fix I'm hoping to get to this afternoon, but it's blocking all the transformers in the meantime.
Faults: Existing code only looks at one worksheet, instead of all Existing code does not account for rows without data Headers shifted ("Company Name (* Denotes Covid 19 Related WARN)" vs "Company Name " (with a space)
Code should probably convert those two strings to just "Company Name" and pick it up in the transformer side as that.
Likely an easy fix I'm hoping to get to this afternoon, but it's blocking all the transformers in the meantime.