Re:We’re happy with SQLite and not urgently interested in a ...
by wenc on Friday May 04, 2018 @02:15PM
(#16996851)
XLSX is actually a decent format for business users. The only trouble is it has tons of limits [1], most restrictive being the limit of 1,048,576 rows by 16,384 columns.
I'm working with a client who had to split up their data into several XLSX files because they hit a row limit.
They can of course ETL the data into a real SQL database, but ETL tools for end users are still not a common thing plus not all end users have access to a SQL database.
I'm working with a client who had to split up their data into several XLSX files because they hit a row limit.
They can of course ETL the data into a real SQL database, but ETL tools for end users are still not a common thing plus not all end users have access to a SQL database.
[1] https://support.office.com/en-us/article/excel-specification...