{"id":34623,"date":"2022-01-05T16:06:05","date_gmt":"2022-01-05T21:06:05","guid":{"rendered":"https:\/\/mjtsai.com\/blog\/?p=34623"},"modified":"2022-01-05T16:06:05","modified_gmt":"2022-01-05T21:06:05","slug":"parsing-numbers-files-with-python","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2022\/01\/05\/parsing-numbers-files-with-python\/","title":{"rendered":"Parsing .numbers Files With Python"},"content":{"rendered":"<p><a href=\"https:\/\/github.com\/masaccio\/numbers-parser\">numbers-parser<\/a> (via <a href=\"https:\/\/news.ycombinator.com\/item?id=29753204\">Hacker News<\/a>):<\/p>\n<blockquote cite=\"https:\/\/github.com\/masaccio\/numbers-parser\"><p><code>numbers-parser<\/code> is a Python module for parsing <a href=\"https:\/\/www.apple.com\/numbers\/\">Apple Numbers<\/a><code>.numbers<\/code> files. It supports Numbers files generated by Numbers version 10.3, and all 11.x up to 11.2\n(current as of November 2021).<\/p><p>[&#8230;]<\/p><p>Numbers uses a proprietary, compressed binary format to store its tables.\nThis format is comprised of a zip file containing images, as well as\n<a href=\"https:\/\/github.com\/google\/snappy\">Snappy<\/a>-compressed\n<a href=\"https:\/\/github.com\/protocolbuffers\/protobuf\">Protobuf<\/a><code>.iwa<\/code> files containing\nmetadata, text, and all other definitions used in the spreadsheet.<\/p><\/blockquote>\n\n<p>Previously:<\/p>\n<ul>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2013\/10\/26\/exploring-the-new-iwork-file-formats\/\">Exploring the New iWork File Formats<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>numbers-parser (via Hacker News): numbers-parser is a Python module for parsing Apple Numbers.numbers files. It supports Numbers files generated by Numbers version 10.3, and all 11.x up to 11.2 (current as of November 2021).[&#8230;]Numbers uses a proprietary, compressed binary format to store its tables. This format is comprised of a zip file containing images, as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"2022-01-05T21:06:08Z","apple_news_api_id":"bc569855-ef39-4a9a-830e-9f59299fe8e3","apple_news_api_modified_at":"2022-01-05T21:06:08Z","apple_news_api_revision":"AAAAAAAAAAD\/\/\/\/\/\/\/\/\/\/w==","apple_news_api_share_url":"https:\/\/apple.news\/AvFaYVe85SpqDDp9ZKZ_o4w","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[4],"tags":[31,2078,30,2077,241,74,71,232],"class_list":["post-34623","post","type-post","status-publish","format-standard","hentry","category-programming-category","tag-ios","tag-ios-15","tag-mac","tag-macos-12","tag-numbers","tag-opensource","tag-programming","tag-python"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/34623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=34623"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/34623\/revisions"}],"predecessor-version":[{"id":34624,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/34623\/revisions\/34624"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=34623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=34623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=34623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}