Use Shared String table instead of inlineString

seamusabshere / xlsx_writer

Writes XLSX files. Simple, clean XML and style. Supports autofilters and headers/footers with images and page numbers if you're willing to do a little Excel hacking.

MIT License

33 stars 10 forks source link

Use Shared String table instead of inlineString #3

Closed ledbettj closed 12 years ago

ledbettj commented 12 years ago

generate a xl/sharedstring.xml file containing string values in the document.
add appropriate references in other XML documents to the shared strings table.

What I was trying to make happen was to make the document readable in iWorks Numbers 2009, but it still doesn't seem to work correctly. This may be valuable anyway (or maybe not).

Tested and works with LibreOffice 3.4.3 on OS X as that's all I have access to. It would be great if someone else could test in native Excel.

seamusabshere commented 12 years ago

hey @ledbettj i've got Office for Mac 2011 and i'll give it a go - thank you!

seamusabshere commented 12 years ago

@ledbettj thanks for the idea! it will be in the next gem release.

you may be interested in one change i made to your implementation: digest strings with MD5 so that i don't have to keep them in memory as hash keys