C:\ Home » 2017 (Page 78)

The Anatomy Of XLSX Files

I work with webshops, and as such I work with .XLSX files a lot, and convert these to .CSV prior to import/export. It's the OS-independent format. The big standard. Also: the much bigger file! A 821KB XLSX is 87MB large as a CSV!! Considering the difference - even though they supposedly contain the same data, I thought I'd dig into the file format a bit, using this particular file as my example, and see how it really works and what they really contain.

I used to think XLSX files used some smart algorithms or formulas to effectivise the way they store data, like finding similar instances and grouping them together as one entity, or skipping delimiter symbols altogether, and instead using spaces or line breaks (which I assume take less space), but as it turns out it's nothing like that. They just use heavy compression, and if you change the filename you can see exactly what they contain - which is not just the worksheet itself (apparently only 8MB big, though, in XML format), but a lot of other resources, and even the image file for the script icon! Some very unnecessary things, I feel, but the file size does decrease drastically with compression.

Looking at the files, the worksheet I'm currently working with (it's a workbook with only one worksheet) contains these:




I found a new speedcheck site! Fast. So simple.

Think I'll be using this one from here on out, even if useful details on location, latency and upload are all omitted, unlike my old favorite Speedtest... which coincidentally seems to power this service as well, even if the Netflix brand appears in the corner.

Give it a whirl! If you wish, good sir/madame. I know I am.

The FireFox Haiku

Proudly non-profit
Free to inovate for you
And a better web

Re-installing a browser sometimes provide unexpected pleasures. :)

Don't think the installer for version 48 had any embedded poetry at all (this is 50.1.0). It's definitely better now!

To Err Is Human...

To err is human... to really screw things up you need a computer!

Sorry for the downtime! Not sure how long we were down, or why, or when we will be next time, but we're back.

Musicalish #160

Even more much overdue new music! Yeah.


Musicalish #159

Some more much overdue new music! Yeah.


Privacy   Copyright   Sitemap   Statistics   RSS Feed   Valid XHTML   Valid CSS   Standards

© 2019
Keeping the world since 2004.