• 0 Posts
  • 4 Comments
Joined 2 years ago
cake
Cake day: June 13th, 2023

help-circle


  • r3waldtoLinux@lemmy.mlProblems with .xls files of 1.5 GB
    link
    fedilink
    English
    arrow-up
    2
    ·
    2 years ago

    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?