Excel limitations, see https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
ODS: https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F Hälsningar Andreas Oxenstierna T-Kartor Geospatial AB Olof Mohlins väg 12 Kristianstad mobile: +46 733 206831 mailto: andreas.oxenstie...@t-kartor.com<mailto:andreas.oxenstie...@t-kartor.com> www.t-kartor.com<http://www.t-kartor.com> On 10 Jan 2022, 11:42 +0100, Even Rouault <even.roua...@spatialys.com>, wrote: Marta, What is the bug exactly ? "2 billion records" : by record, you mean cells, like a sheet with 2048 columns and 1048576 rows ? By quickly looking at the code I can't see an obvious limitation, but that doesn't mean anything. Closer investigation would be needed. Please file an issue at https://github.com/OSGeo/gdal/issues/new with exact details how to reproduce (number of rows/features, and columns/fields in particular). But even if the writer side would work, the OGR reader side would probably have issues as the whole spreadsheet will be loaded into RAM and for 2 billion cells, I would expect at least 32 or more GB of RAM to be needed. Perhaps spreadsheet software are able to cope with that in a smarter way. Even Le 10/01/2022 à 11:27, Kopszak Marta - Partner Hurt a écrit : Dear Sirs, I ran into an error when exporting data through the OGR library to the .xlsx and .ods format. The bug occurs when there are more than 2 billion records in the database. I know the problem was solved for other formats, e.g. csv. Will the problem be solved also for other formats (e.g. xlsx, .ods)? If this is not the correct e-mail, please forward this e-mail to the appropriate person. Kind regards, Marta Kopszak [Logo Orange]<https://www.orange.pl/> Marta Kopszak Współpracownik Rozwój Sieci Stacjonarnej, Wydział Rozwoju Planowania Orange Polska, gen. Romualda Traugutta 55, 50-416 Wrocław | RODO - informacja o danych<https://www.orange.pl/zobacz/rodo> _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/gdal-dev -- http://www.spatialys.com My software is free, but my time generally not.
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev