3 ms·
As much as I hate how unstructured spreadsheets can be (and almost always are), I have successfully integrated spreadsheets into business processes by developin
by mcculley 4y ago
As much as I hate how unstructured spreadsheets can be (and almost always are), I have successfully integrated spreadsheets into business processes by developing a schema for the spreadsheet and enforcing it. I have web apps which use the Apache POI library to parse the spreadsheet. They kick it back to the user if anything is not where it is expected to be. Less technical end users can then use Excel as their UI for entering data into forms. It works great for some use cases.
- ludicity 4y agoYou are a person of iron discipline, and I respect it. This was almost done at my current workplace, but the spreadsheets were not adequately formatted/enforced early on, and there wasn't political will to insist users re-do work if a newer version had been produced, so it fell to the engineers. I give you, and only you, a pass to use these in the future.