Tech
Two spreadsheet parsers, and only the richer one is kept
School and employee transport operators do not send you a schema. They send the workbook the school or the factory already had. The column titles are whatever that office typed. Sometimes there is no header row. Sometimes the student list, the school address, and the vehicle list are three different sheets.
We used to solve this by asking the operator to rebuild the file into a template. That failed on the morning a shift list arrived half an hour before the buses left. There was no time to r...
Read the full discussion on Dev.to
This article was aggregated from Dev.to. Click to join the conversation.
View on Dev.to