Skip Navigation
InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)RW
r3wald @discuss.tchncs.de
Posts 0
Comments 3
Problems with .xls files of 1.5 GB
  • For real, what are you using this one for? If I take the compression ratio into account (times 10), subtract meta data (minus a third) and consider the character encoding (two bytes per character) I still get around 5000000000 characters. That's all numbers? You wouldn't store binary content in there, would you?

    Anyway, take a decent pc with at least twice the memory the file will need uncompressed. Kill all other applications. Open up your file and split it up. Make a separate file for each worksheet. If there are more than 100000 rows, split them in separate files too. Don't embed any binary content.

    And for god's sake: use a different tool. That very much depends on what you are trying to do. What is it?

  • Was passiert gerade in eurer bubble so?
  • Aufgrund persönlicher Kontakte in eines der wichtigen Bundesministerien kann ich euch verraten: Da gibt es eine Staatssekretärin, die ihre Leute damit beauftragt, eine KI zum Redenschreiben zu bringen. Die Mitarbeiter verzweifeln jetzt schon, die Zuhörer dann später.