3 ms·
TL;DR [I found it hard to find which actual limit was hit.] > The problems are believed to have arisen when labs sent in their results using CSV files, which h
by karmakaze 6y ago
TL;DR [I found it hard to find which actual limit was hit.]
> The problems are believed to have arisen when labs sent in their results using CSV files, which have no limits on size. But PHE then imported the results into Excel, where documents have a limit of just over a million lines.
> The technical issue has now been resolved by splitting the Excel files into batches.
- codeulike 6y agoFurther down, maybe the article has been updated PHE had set up an automatic process to pull this data together into Excel templates so that it could then be uploaded to a central system and made available to the NHS Test and Trace team as well as other government computer dashboards. The problem is that the PHE developers picked an old file format to do this - known as XLS. As a consequence, each template could handle only about 65,000 rows of data rather than the one million-plus rows that Excel is actually capable of.