TITLE

Work with Open Document (ODS) spreadsheets.


SUBTITLE

data

=begin data
{"type":"page","file":"work_mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md","sources":[],"node":{"type":"block","id":"-umF1fjd94maYX7sNg-aX","margin":"","name":"root","content":[{"type":"para","id":"GwPosaLm8rtN5YQkAmJ41","margin":"","location":{"start":{"line":1,"column":1,"offset":0},"end":{"line":1,"column":137,"offset":136}},"text":"text","content":[{"meta":"https://github.com/niner/Spreadsheet-ODS/actions","type":"fcode","name":"L","content":[{"type":"block","id":"cUg2RYTkfPkIchWu0MpvI","margin":"","name":"Image","config":[],"location":{"start":{"line":1,"column":2,"offset":1},"end":{"line":1,"column":86,"offset":85}},"content":[{"type":"image","src":"https://github.com/niner/Spreadsheet-ODS/workflows/test/badge.svg","alt":"Actions Status"}]}]}]},{"type":"block","id":"qbFX9dT_hKtsPM2EMslH4","margin":"","level":1,"name":"head","location":{"start":{"line":3,"column":1,"offset":138},"end":{"line":4,"column":5,"offset":147}},"content":["NAME"]},{"type":"para","id":"hq9vxYCfiZUXaQik2pO5M","margin":"","location":{"start":{"line":6,"column":1,"offset":149},"end":{"line":6,"column":63,"offset":211}},"text":"text","content":["Spreadsheet::ODS - Work with Open Document (ODS) spreadsheets."]},{"type":"block","id":"1iI_EfdTYUWO7uG13syZ2","margin":"","level":1,"name":"head","location":{"start":{"line":8,"column":1,"offset":213},"end":{"line":9,"column":9,"offset":230}},"content":["SYNOPSIS"]},{"type":"block","id":"Wz0Z_2Ddt9n1XB6TNgDvz","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":11,"column":1,"offset":232},"end":{"line":13,"column":4,"offset":265}},"content":[{"type":"verbatim","value":"use Spreadsheet::ODS;"}]},{"type":"block","id":"AEAFg_EQibc3mFqNYvE8b","margin":"","level":1,"name":"head","location":{"start":{"line":15,"column":1,"offset":267},"end":{"line":16,"column":12,"offset":290}},"content":["DESCRIPTION"]},{"type":"para","id":"9qNVouvd8AlrpSblyTPRg","margin":"","location":{"start":{"line":18,"column":1,"offset":292},"end":{"line":18,"column":24,"offset":315}},"text":"text","content":["Spreadsheet::ODS is ..."]},{"type":"block","id":"jEIqNljfv1bH7EkViVZ-W","margin":"","level":1,"name":"head","location":{"start":{"line":20,"column":1,"offset":317},"end":{"line":21,"column":7,"offset":330}},"content":["AUTHOR"]},{"type":"para","id":"HMMCkk8P0l8hpYcAKTQHm","margin":"","location":{"start":{"line":23,"column":1,"offset":332},"end":{"line":23,"column":37,"offset":368}},"text":"text","content":["Stefan Seifert ",{"meta":"mailto:nine@detonation.org","type":"fcode","name":"L","content":["nine@detonation.org"]}]},{"type":"block","id":"xkUs0LiqWUHkuOjm7jXji","margin":"","level":3,"name":"head","location":{"start":{"line":25,"column":1,"offset":370},"end":{"line":25,"column":23,"offset":392}},"content":["has Hash $!archive"]},{"type":"para","id":"ktucLDPsrqVxjXLG4Rwju","margin":"","location":{"start":{"line":27,"column":1,"offset":394},"end":{"line":27,"column":63,"offset":456}},"text":"text","content":["Map of files in the decompressed archive we read from, if any."]},{"type":"block","id":"UCvxMoZMTL3Exa2u73RyS","margin":"","level":3,"name":"head","location":{"start":{"line":29,"column":1,"offset":458},"end":{"line":29,"column":22,"offset":479}},"content":["multi method load"]},{"type":"block","id":"vsIlkqhqhhn_rTTG8WktV","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":31,"column":1,"offset":481},"end":{"line":35,"column":4,"offset":552}},"content":[{"type":"verbatim","value":"multi method load(\n    Str $file\n) returns Spreadsheet::ODS"}]},{"type":"para","id":"8ne0Z9lYrC9XhyezxVLBa","margin":"","location":{"start":{"line":37,"column":1,"offset":554},"end":{"line":37,"column":72,"offset":625}},"text":"text","content":["Load an ODS workbook from the file path identified by the given string."]},{"type":"block","id":"H3-1aWcosWA3dA4lPka2z","margin":"","level":3,"name":"head","location":{"start":{"line":39,"column":1,"offset":627},"end":{"line":39,"column":22,"offset":648}},"content":["multi method load"]},{"type":"block","id":"3EA0BiGhKp8w3Xe6hyVoy","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":41,"column":1,"offset":650},"end":{"line":45,"column":4,"offset":726}},"content":[{"type":"verbatim","value":"multi method load(\n    IO::Path $file\n) returns Spreadsheet::ODS"}]},{"type":"para","id":"s9tG9sicUpmeBa37mdKgH","margin":"","location":{"start":{"line":47,"column":1,"offset":728},"end":{"line":47,"column":44,"offset":771}},"text":"text","content":["Load an ODS workbook in the specified file."]},{"type":"block","id":"Lh1-WiFRAqX3mzkV0Q-V-","margin":"","level":3,"name":"head","location":{"start":{"line":49,"column":1,"offset":773},"end":{"line":49,"column":22,"offset":794}},"content":["multi method load"]},{"type":"block","id":"5bgdqO9SqmajHnx5kpEvJ","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":51,"column":1,"offset":796},"end":{"line":55,"column":4,"offset":871}},"content":[{"type":"verbatim","value":"multi method load(\n    Blob $content\n) returns Spreadsheet::ODS"}]},{"type":"para","id":"mrJn7me-4Ybgu_h3Fb6d8","margin":"","location":{"start":{"line":57,"column":1,"offset":873},"end":{"line":57,"column":133,"offset":1005}},"text":"text","content":["Load an ODS workbook from the specified blob. This is useful in the case it was sent over the network, and so never written to disk."]},{"type":"block","id":"fwxVPcQI8gAAsAjHHSjO4","margin":"","level":1,"name":"head","location":{"start":{"line":59,"column":1,"offset":1007},"end":{"line":60,"column":22,"offset":1050}},"content":["COPYRIGHT AND LICENSE"]},{"type":"para","id":"uEgWJGh-mAdDxVM6MCyqs","margin":"","location":{"start":{"line":62,"column":1,"offset":1052},"end":{"line":62,"column":30,"offset":1081}},"text":"text","content":["Copyright 2022 Stefan Seifert"]},{"type":"para","id":"pN-B_vASsAkt_m6z9d4Pr","margin":"","location":{"start":{"line":64,"column":1,"offset":1083},"end":{"line":64,"column":104,"offset":1186}},"text":"text","content":["This library is free software; you can redistribute it and/or modify it under the Artistic License 2.0."]}]},"publishUrl":"/mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md","pluginsData":{"moduleInfo":{"meta":{"api":"","auth":"zef:nine","authors":["Stefan Seifert"],"build-depends":[],"depends":{"runtime":{"requires":["Libarchive::Simple","LibXML"]}},"description":"Work with Open Document (ODS) spreadsheets.","dist":"Spreadsheet::ODS:ver<0.1>:auth<zef:nine>","license":"Artistic-2.0","meta-version":1,"name":"Spreadsheet::ODS","path":"S/PR/SPREADSHEET_ODS/1609f274a6ac76d5d3cb6f089238e3d0479d1882.tar.gz","perl":"6.d","provides":{"Spreadsheet::ODS":"lib/Spreadsheet/ODS.rakumod"},"resources":[],"source-url":"git://github.com/niner/Spreadsheet-ODS.git","tags":[],"test-depends":[],"version":"0.1"},"files":[{"file":"work_mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md","publishUrl":"/mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md"},{"file":"work_mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/lib/Spreadsheet/ODS.rakumod","publishUrl":"/mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/lib/Spreadsheet/ODS.rakumod"}],"src":"zef","url":"/mods/zef/Spreadsheet::ODS"}}}
=end data


React

    =begin React :component<RenderItem>
    =begin data
    {"type":"page","file":"work_mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md","sources":[],"node":{"type":"block","id":"-umF1fjd94maYX7sNg-aX","margin":"","name":"root","content":[{"type":"para","id":"GwPosaLm8rtN5YQkAmJ41","margin":"","location":{"start":{"line":1,"column":1,"offset":0},"end":{"line":1,"column":137,"offset":136}},"text":"text","content":[{"meta":"https://github.com/niner/Spreadsheet-ODS/actions","type":"fcode","name":"L","content":[{"type":"block","id":"cUg2RYTkfPkIchWu0MpvI","margin":"","name":"Image","config":[],"location":{"start":{"line":1,"column":2,"offset":1},"end":{"line":1,"column":86,"offset":85}},"content":[{"type":"image","src":"https://github.com/niner/Spreadsheet-ODS/workflows/test/badge.svg","alt":"Actions Status"}]}]}]},{"type":"block","id":"qbFX9dT_hKtsPM2EMslH4","margin":"","level":1,"name":"head","location":{"start":{"line":3,"column":1,"offset":138},"end":{"line":4,"column":5,"offset":147}},"content":["NAME"]},{"type":"para","id":"hq9vxYCfiZUXaQik2pO5M","margin":"","location":{"start":{"line":6,"column":1,"offset":149},"end":{"line":6,"column":63,"offset":211}},"text":"text","content":["Spreadsheet::ODS - Work with Open Document (ODS) spreadsheets."]},{"type":"block","id":"1iI_EfdTYUWO7uG13syZ2","margin":"","level":1,"name":"head","location":{"start":{"line":8,"column":1,"offset":213},"end":{"line":9,"column":9,"offset":230}},"content":["SYNOPSIS"]},{"type":"block","id":"Wz0Z_2Ddt9n1XB6TNgDvz","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":11,"column":1,"offset":232},"end":{"line":13,"column":4,"offset":265}},"content":[{"type":"verbatim","value":"use Spreadsheet::ODS;"}]},{"type":"block","id":"AEAFg_EQibc3mFqNYvE8b","margin":"","level":1,"name":"head","location":{"start":{"line":15,"column":1,"offset":267},"end":{"line":16,"column":12,"offset":290}},"content":["DESCRIPTION"]},{"type":"para","id":"9qNVouvd8AlrpSblyTPRg","margin":"","location":{"start":{"line":18,"column":1,"offset":292},"end":{"line":18,"column":24,"offset":315}},"text":"text","content":["Spreadsheet::ODS is ..."]},{"type":"block","id":"jEIqNljfv1bH7EkViVZ-W","margin":"","level":1,"name":"head","location":{"start":{"line":20,"column":1,"offset":317},"end":{"line":21,"column":7,"offset":330}},"content":["AUTHOR"]},{"type":"para","id":"HMMCkk8P0l8hpYcAKTQHm","margin":"","location":{"start":{"line":23,"column":1,"offset":332},"end":{"line":23,"column":37,"offset":368}},"text":"text","content":["Stefan Seifert ",{"meta":"mailto:nine@detonation.org","type":"fcode","name":"L","content":["nine@detonation.org"]}]},{"type":"block","id":"xkUs0LiqWUHkuOjm7jXji","margin":"","level":3,"name":"head","location":{"start":{"line":25,"column":1,"offset":370},"end":{"line":25,"column":23,"offset":392}},"content":["has Hash $!archive"]},{"type":"para","id":"ktucLDPsrqVxjXLG4Rwju","margin":"","location":{"start":{"line":27,"column":1,"offset":394},"end":{"line":27,"column":63,"offset":456}},"text":"text","content":["Map of files in the decompressed archive we read from, if any."]},{"type":"block","id":"UCvxMoZMTL3Exa2u73RyS","margin":"","level":3,"name":"head","location":{"start":{"line":29,"column":1,"offset":458},"end":{"line":29,"column":22,"offset":479}},"content":["multi method load"]},{"type":"block","id":"vsIlkqhqhhn_rTTG8WktV","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":31,"column":1,"offset":481},"end":{"line":35,"column":4,"offset":552}},"content":[{"type":"verbatim","value":"multi method load(\n    Str $file\n) returns Spreadsheet::ODS"}]},{"type":"para","id":"8ne0Z9lYrC9XhyezxVLBa","margin":"","location":{"start":{"line":37,"column":1,"offset":554},"end":{"line":37,"column":72,"offset":625}},"text":"text","content":["Load an ODS workbook from the file path identified by the given string."]},{"type":"block","id":"H3-1aWcosWA3dA4lPka2z","margin":"","level":3,"name":"head","location":{"start":{"line":39,"column":1,"offset":627},"end":{"line":39,"column":22,"offset":648}},"content":["multi method load"]},{"type":"block","id":"3EA0BiGhKp8w3Xe6hyVoy","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":41,"column":1,"offset":650},"end":{"line":45,"column":4,"offset":726}},"content":[{"type":"verbatim","value":"multi method load(\n    IO::Path $file\n) returns Spreadsheet::ODS"}]},{"type":"para","id":"s9tG9sicUpmeBa37mdKgH","margin":"","location":{"start":{"line":47,"column":1,"offset":728},"end":{"line":47,"column":44,"offset":771}},"text":"text","content":["Load an ODS workbook in the specified file."]},{"type":"block","id":"Lh1-WiFRAqX3mzkV0Q-V-","margin":"","level":3,"name":"head","location":{"start":{"line":49,"column":1,"offset":773},"end":{"line":49,"column":22,"offset":794}},"content":["multi method load"]},{"type":"block","id":"5bgdqO9SqmajHnx5kpEvJ","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":51,"column":1,"offset":796},"end":{"line":55,"column":4,"offset":871}},"content":[{"type":"verbatim","value":"multi method load(\n    Blob $content\n) returns Spreadsheet::ODS"}]},{"type":"para","id":"mrJn7me-4Ybgu_h3Fb6d8","margin":"","location":{"start":{"line":57,"column":1,"offset":873},"end":{"line":57,"column":133,"offset":1005}},"text":"text","content":["Load an ODS workbook from the specified blob. This is useful in the case it was sent over the network, and so never written to disk."]},{"type":"block","id":"fwxVPcQI8gAAsAjHHSjO4","margin":"","level":1,"name":"head","location":{"start":{"line":59,"column":1,"offset":1007},"end":{"line":60,"column":22,"offset":1050}},"content":["COPYRIGHT AND LICENSE"]},{"type":"para","id":"uEgWJGh-mAdDxVM6MCyqs","margin":"","location":{"start":{"line":62,"column":1,"offset":1052},"end":{"line":62,"column":30,"offset":1081}},"text":"text","content":["Copyright 2022 Stefan Seifert"]},{"type":"para","id":"pN-B_vASsAkt_m6z9d4Pr","margin":"","location":{"start":{"line":64,"column":1,"offset":1083},"end":{"line":64,"column":104,"offset":1186}},"text":"text","content":["This library is free software; you can redistribute it and/or modify it under the Artistic License 2.0."]}]},"publishUrl":"/mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md","pluginsData":{"moduleInfo":{"meta":{"api":"","auth":"zef:nine","authors":["Stefan Seifert"],"build-depends":[],"depends":{"runtime":{"requires":["Libarchive::Simple","LibXML"]}},"description":"Work with Open Document (ODS) spreadsheets.","dist":"Spreadsheet::ODS:ver<0.1>:auth<zef:nine>","license":"Artistic-2.0","meta-version":1,"name":"Spreadsheet::ODS","path":"S/PR/SPREADSHEET_ODS/1609f274a6ac76d5d3cb6f089238e3d0479d1882.tar.gz","perl":"6.d","provides":{"Spreadsheet::ODS":"lib/Spreadsheet/ODS.rakumod"},"resources":[],"source-url":"git://github.com/niner/Spreadsheet-ODS.git","tags":[],"test-depends":[],"version":"0.1"},"files":[{"file":"work_mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md","publishUrl":"/mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/README.md"},{"file":"work_mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/lib/Spreadsheet/ODS.rakumod","publishUrl":"/mods/zef/Spreadsheet::ODS/Spreadsheet-ODS-0.1/lib/Spreadsheet/ODS.rakumod"}],"src":"zef","url":"/mods/zef/Spreadsheet::ODS"}}}
    =end data
    =end React


root

para

L<Examples| file:../examples/index.podlite>


L<Download |file:../download/index.podlite>


=begin React :component<HeaderCol> :id<menu> 
=para L<Documentation|/doc/introduction>
=para L<Modules| /mods>
=para L<Examples| file:../examples/index.podlite>
=para L<Download |file:../download/index.podlite>
=para L<About|file:../about/index.podlite>
=para 🔍 K<⌘K>/K<ctrl-K>
=end React


HEADER

FOOTER

Spreadsheet::ODS


=begin data
{"type":"page","file":"work_mods/zef/Spreadsheet::XLSX/dist/README.md","sources":[],"node":{"type":"block","id":"HCWzh0nAO9plwiIkXofR6","margin":"","name":"root","content":[{"type":"block","id":"ciRvED0Qm72uUhXa1jgcX","margin":"","level":1,"name":"head","location":{"start":{"line":1,"column":1,"offset":0},"end":{"line":1,"column":20,"offset":19}},"content":["Spreadsheet::XLSX"]},{"type":"para","id":"3KzgS8dbtDNf4t_MwVVCM","margin":"","location":{"start":{"line":3,"column":1,"offset":21},"end":{"line":5,"column":37,"offset":199}},"text":"text","content":["A Raku module for working with Excel spreadsheets (XLSX format), both\nreading existing files, creating new files, or modifying existing files\nand saving the changes. Of note, it:"]},{"type":"list","id":"JxSqH65BlO2-PC1QngdeD","margin":"","level":1,"list":"itemized","content":[{"type":"block","id":"NebSUGLcvqJ9fKOMn24fU","margin":"","name":"item","level":1,"location":{"start":{"line":7,"column":1,"offset":201},"end":{"line":8,"column":73,"offset":347}},"content":[{"type":"para","id":"UeCaVgVuys1p5SXqYNsfd","margin":"","location":{"start":{"line":7,"column":3,"offset":203},"end":{"line":8,"column":73,"offset":347}},"text":"text","content":["Knows how to lazily load sheet content, so if you don't look at a sheet\nthen time won't be spent deserializing it (down to a cell level, even)"]}]},{"type":"block","id":"Q65RtrRjNVd-6UZVqxIhB","margin":"","name":"item","level":1,"location":{"start":{"line":9,"column":1,"offset":348},"end":{"line":11,"column":47,"offset":540}},"content":[{"type":"para","id":"6jZmQZ0l8SkpUuFSrUW7W","margin":"","location":{"start":{"line":9,"column":3,"offset":350},"end":{"line":11,"column":47,"offset":540}},"text":"text","content":["In the modification scenario, tries to leave as much intact as it can,\nmeaning that it's possible to poke data into a sheet more complex than\ncould be produced by the module from scratch"]}]},{"type":"block","id":"z2aX_GTe_DdpqWqNs9Ecj","margin":"","name":"item","level":1,"location":{"start":{"line":12,"column":1,"offset":541},"end":{"line":13,"column":34,"offset":642}},"content":[{"type":"para","id":"aqiWWfA5RE53IPDe7KR2M","margin":"","location":{"start":{"line":12,"column":3,"offset":543},"end":{"line":13,"column":34,"offset":642}},"text":"text","content":["Only depends on the Raku LibXML and Libarchive modules (and their\nrespective native dependencies)"]}]}]},{"type":"para","id":"6mu5dmjG03koUzgKVoK5f","margin":"","location":{"start":{"line":15,"column":1,"offset":644},"end":{"line":17,"column":76,"offset":867}},"text":"text","content":["This module is currently in development, and supports the subset of XLSX\nformat features that were immediately needed for the use-case it was built\nfor. That isn't so much, for now, but it will handle the most common needs:"]},{"type":"list","id":"TQ5AN4HtbeOtpY8a9OMUJ","margin":"","level":1,"list":"itemized","content":[{"type":"block","id":"094WcT4cKSQaudfm4IbKU","margin":"","name":"item","level":1,"location":{"start":{"line":19,"column":1,"offset":869},"end":{"line":19,"column":25,"offset":893}},"content":[{"type":"para","id":"_svOAuguVfoH-JXwLR7N3","margin":"","location":{"start":{"line":19,"column":3,"offset":871},"end":{"line":19,"column":25,"offset":893}},"text":"text","content":["Enumerating worksheets"]}]},{"type":"block","id":"kRzCJq7bSqUoZMleyrm_7","margin":"","name":"item","level":1,"location":{"start":{"line":20,"column":1,"offset":894},"end":{"line":20,"column":53,"offset":946}},"content":[{"type":"para","id":"frZ8skr2Qc1-7S39e1YGN","margin":"","location":{"start":{"line":20,"column":3,"offset":896},"end":{"line":20,"column":53,"offset":946}},"text":"text","content":["Reading text and numbers from cells on a worksheet"]}]},{"type":"block","id":"clyTHUi9KuA_iWYHcLf09","margin":"","name":"item","level":1,"location":{"start":{"line":21,"column":1,"offset":947},"end":{"line":21,"column":68,"offset":1014}},"content":[{"type":"para","id":"h6_60hVMaZjzvfSQ2mtA_","margin":"","location":{"start":{"line":21,"column":3,"offset":949},"end":{"line":21,"column":68,"offset":1014}},"text":"text","content":["Creating new workbooks with worksheets with text and number cells"]}]},{"type":"block","id":"TI59TsvbqSnWZ2xxi1Rnd","margin":"","name":"item","level":1,"location":{"start":{"line":22,"column":1,"offset":1015},"end":{"line":23,"column":13,"offset":1095}},"content":[{"type":"para","id":"vbuk4C1Fx1ZhizJSyJHfP","margin":"","location":{"start":{"line":22,"column":3,"offset":1017},"end":{"line":23,"column":13,"offset":1095}},"text":"text","content":["Setting basic styles and number formats on cells in newly created\nworksheets"]}]},{"type":"block","id":"Duz1aoATEa0_A-HcalJrq","margin":"","name":"item","level":1,"location":{"start":{"line":24,"column":1,"offset":1096},"end":{"line":24,"column":64,"offset":1159}},"content":[{"type":"para","id":"ZZg-HDfeajymWAIvRC9lY","margin":"","location":{"start":{"line":24,"column":3,"offset":1098},"end":{"line":24,"column":64,"offset":1159}},"text":"text","content":["Reading a workbook, making modifications, and saving it again"]}]},{"type":"block","id":"6i09uKCVvkbkain-lH4Y4","margin":"","name":"item","level":1,"location":{"start":{"line":25,"column":1,"offset":1160},"end":{"line":25,"column":63,"offset":1222}},"content":[{"type":"para","id":"O4lRAitzYDh-2OP61FoDr","margin":"","location":{"start":{"line":25,"column":3,"offset":1162},"end":{"line":25,"column":63,"offset":1222}},"text":"text","content":["Reading and writing column properties (such as column width)"]}]}]},{"type":"block","id":"Ds6MnbblVkelFl2gkFeTk","margin":"","level":2,"name":"head","location":{"start":{"line":27,"column":1,"offset":1224},"end":{"line":27,"column":12,"offset":1235}},"content":["Synopsis"]},{"type":"block","id":"sLBSs7TeV2Hr1yVqHpTRq","margin":"","level":3,"name":"head","location":{"start":{"line":29,"column":1,"offset":1237},"end":{"line":29,"column":31,"offset":1267}},"content":["Reading existing workbooks"]},{"type":"block","id":"AGhhKr_kj7FA32LoR2FsD","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":31,"column":1,"offset":1269},"end":{"line":51,"column":4,"offset":1913}},"content":[{"type":"verbatim","value":"use Spreadsheet::XLSX;\n\n# Read a workbook from an existing file (can pass IO::Path or a\n# Blob in the case it was uploaded).\nmy $workbook = Spreadsheet::XLSX.load('accounts.xlsx');\n\n# Get worksheets.\nsay \"Workbook has {$workbook.worksheets.elems} sheets\";\n\n# Get the name of a worksheet.\nsay $workbook.worksheets.name;\n\n# Get cell values (indexing is zero-based, done as a multi-dimensional array\n# indexing operation [row ; column].\nmy $cells = $workbook.worksheets[0].cells;\nsay .value with $cells[0;0];      # A1\nsay .value with $cells[0;1];      # B1\nsay .value with $cells[1;0];      # A2\nsay .value with $cells[1;1];      # B2"}]},{"type":"block","id":"Om00hUA246Y1BKykz9yc3","margin":"","level":3,"name":"head","location":{"start":{"line":53,"column":1,"offset":1915},"end":{"line":53,"column":27,"offset":1941}},"content":["Creating new workbooks"]},{"type":"block","id":"Qqq_WMPS6Vsz-MK71OI7v","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":55,"column":1,"offset":1943},"end":{"line":84,"column":4,"offset":3109}},"content":[{"type":"verbatim","value":"use Spreadsheet::XLSX;\n\n# Create a new workbook and add some worksheets to it.\nmy $workbook = Spreadsheet::XLSX.new;\nmy $sheet-a = $workbook.create-worksheet('Ingredients');\nmy $sheet-b = $workbook.create-worksheet('Matching Drinks');\n\n# Put some data into a worksheet and style it. This is how the model\n# actually works (useful if you want to add styles later).\n$sheet-a.cells[0;0] = Spreadsheet::XLSX::Cell::Text.new(value => 'Ingredient');\n$sheet-a.cells[0;0].style.bold = True;\n$sheet-a.cells[0;1] = Spreadsheet::XLSX::Cell::Text.new(value => 'Quantity');\n$sheet-a.cells[0;1].style.bold = True;\n$sheet-a.cells[1;0] = Spreadsheet::XLSX::Cell::Text.new(value => 'Eggs');\n$sheet-a.cells[1;1] = Spreadsheet::XLSX::Cell::Number.new(value => 6);\n$sheet-a.cells[1;1].style.number-format = '#,###';\n\n# However, there is a convenience form too.\n$sheet-a.set(0, 0, 'Ingredient', :bold);\n$sheet-a.set(0, 1, 'Quantity', :bold);\n$sheet-a.set(1, 0, 'Eggs');\n$sheet-a.set(1, 1, 6, :number-format('#,###'));\n\n# Save it to a file (string or IO::Path name).\n$workbook.save(\"foo.xlsx\");\n\n# Or get it as a blob, e.g. for a HTTP response.\nmy $blob = $workbook.to-blob();"}]},{"type":"block","id":"6aYcJO-lKjyUKYDGa51uc","margin":"","level":2,"name":"head","location":{"start":{"line":86,"column":1,"offset":3111},"end":{"line":86,"column":11,"offset":3121}},"content":["Credits"]},{"type":"para","id":"FRn2G_kRxkTvkH2nuVDzZ","margin":"","location":{"start":{"line":88,"column":1,"offset":3123},"end":{"line":91,"column":87,"offset":3442}},"text":"text","content":["Thanks goes to ",{"meta":"https://agrammon.ch/","type":"fcode","name":"L","content":["Agrammon"]}," for making the development of\nthis module possible. If you need further development on the module and are\nwilling to fund it (or other Raku ecosystem work), you can get in contact with\n",{"meta":"https://www.edument.se/en","type":"fcode","name":"L","content":["Edument"]}," or ",{"meta":"https://www.oetiker.ch/en/","type":"fcode","name":"L","content":["Oetiker+Partner"]},"."]}]},"publishUrl":"/mods/zef/Spreadsheet::XLSX/dist/README.md","pluginsData":{"moduleInfo":{"meta":{"api":"","auth":"zef:jnthn","build-depends":[],"depends":["Libarchive","LibXML:ver<0.6.0+>"],"description":"Work with Excel (XLSX) spreadsheets.","dist":"Spreadsheet::XLSX:ver<0.2.4>:auth<zef:jnthn>","license":"Artistic-2.0","name":"Spreadsheet::XLSX","path":"S/PR/SPREADSHEET_XLSX/ec12baedfe4248ba5de2f31b4467dba8ec5be6ac.tar.gz","perl":"6.*","provides":{"Spreadsheet::XLSX":"lib/Spreadsheet/XLSX.rakumod","Spreadsheet::XLSX::Cell":"lib/Spreadsheet/XLSX/Cell.rakumod","Spreadsheet::XLSX::CellStyle":"lib/Spreadsheet/XLSX/CellStyle.rakumod","Spreadsheet::XLSX::ContentTypes":"lib/Spreadsheet/XLSX/ContentTypes.rakumod","Spreadsheet::XLSX::Exceptions":"lib/Spreadsheet/XLSX/Exceptions.rakumod","Spreadsheet::XLSX::Relationships":"lib/Spreadsheet/XLSX/Relationships.rakumod","Spreadsheet::XLSX::Root":"lib/Spreadsheet/XLSX/Root.rakumod","Spreadsheet::XLSX::SharedStrings":"lib/Spreadsheet/XLSX/SharedStrings.rakumod","Spreadsheet::XLSX::Styles":"lib/Spreadsheet/XLSX/Styles.rakumod","Spreadsheet::XLSX::Workbook":"lib/Spreadsheet/XLSX/Workbook.rakumod","Spreadsheet::XLSX::Worksheet":"lib/Spreadsheet/XLSX/Worksheet.rakumod"},"resources":[],"source-url":"https://github.com/jnthn/spreadsheet-xlsx.git","test-depends":[],"version":"0.2.4"},"files":[{"file":"work_mods/zef/Spreadsheet::XLSX/dist/README.md","publishUrl":"/mods/zef/Spreadsheet::XLSX/dist/README.md"}],"src":"zef","url":"/mods/zef/Spreadsheet::XLSX"}}}
=end data


    =begin React :component<RenderItem>
    =begin data
    {"type":"page","file":"work_mods/zef/Spreadsheet::XLSX/dist/README.md","sources":[],"node":{"type":"block","id":"HCWzh0nAO9plwiIkXofR6","margin":"","name":"root","content":[{"type":"block","id":"ciRvED0Qm72uUhXa1jgcX","margin":"","level":1,"name":"head","location":{"start":{"line":1,"column":1,"offset":0},"end":{"line":1,"column":20,"offset":19}},"content":["Spreadsheet::XLSX"]},{"type":"para","id":"3KzgS8dbtDNf4t_MwVVCM","margin":"","location":{"start":{"line":3,"column":1,"offset":21},"end":{"line":5,"column":37,"offset":199}},"text":"text","content":["A Raku module for working with Excel spreadsheets (XLSX format), both\nreading existing files, creating new files, or modifying existing files\nand saving the changes. Of note, it:"]},{"type":"list","id":"JxSqH65BlO2-PC1QngdeD","margin":"","level":1,"list":"itemized","content":[{"type":"block","id":"NebSUGLcvqJ9fKOMn24fU","margin":"","name":"item","level":1,"location":{"start":{"line":7,"column":1,"offset":201},"end":{"line":8,"column":73,"offset":347}},"content":[{"type":"para","id":"UeCaVgVuys1p5SXqYNsfd","margin":"","location":{"start":{"line":7,"column":3,"offset":203},"end":{"line":8,"column":73,"offset":347}},"text":"text","content":["Knows how to lazily load sheet content, so if you don't look at a sheet\nthen time won't be spent deserializing it (down to a cell level, even)"]}]},{"type":"block","id":"Q65RtrRjNVd-6UZVqxIhB","margin":"","name":"item","level":1,"location":{"start":{"line":9,"column":1,"offset":348},"end":{"line":11,"column":47,"offset":540}},"content":[{"type":"para","id":"6jZmQZ0l8SkpUuFSrUW7W","margin":"","location":{"start":{"line":9,"column":3,"offset":350},"end":{"line":11,"column":47,"offset":540}},"text":"text","content":["In the modification scenario, tries to leave as much intact as it can,\nmeaning that it's possible to poke data into a sheet more complex than\ncould be produced by the module from scratch"]}]},{"type":"block","id":"z2aX_GTe_DdpqWqNs9Ecj","margin":"","name":"item","level":1,"location":{"start":{"line":12,"column":1,"offset":541},"end":{"line":13,"column":34,"offset":642}},"content":[{"type":"para","id":"aqiWWfA5RE53IPDe7KR2M","margin":"","location":{"start":{"line":12,"column":3,"offset":543},"end":{"line":13,"column":34,"offset":642}},"text":"text","content":["Only depends on the Raku LibXML and Libarchive modules (and their\nrespective native dependencies)"]}]}]},{"type":"para","id":"6mu5dmjG03koUzgKVoK5f","margin":"","location":{"start":{"line":15,"column":1,"offset":644},"end":{"line":17,"column":76,"offset":867}},"text":"text","content":["This module is currently in development, and supports the subset of XLSX\nformat features that were immediately needed for the use-case it was built\nfor. That isn't so much, for now, but it will handle the most common needs:"]},{"type":"list","id":"TQ5AN4HtbeOtpY8a9OMUJ","margin":"","level":1,"list":"itemized","content":[{"type":"block","id":"094WcT4cKSQaudfm4IbKU","margin":"","name":"item","level":1,"location":{"start":{"line":19,"column":1,"offset":869},"end":{"line":19,"column":25,"offset":893}},"content":[{"type":"para","id":"_svOAuguVfoH-JXwLR7N3","margin":"","location":{"start":{"line":19,"column":3,"offset":871},"end":{"line":19,"column":25,"offset":893}},"text":"text","content":["Enumerating worksheets"]}]},{"type":"block","id":"kRzCJq7bSqUoZMleyrm_7","margin":"","name":"item","level":1,"location":{"start":{"line":20,"column":1,"offset":894},"end":{"line":20,"column":53,"offset":946}},"content":[{"type":"para","id":"frZ8skr2Qc1-7S39e1YGN","margin":"","location":{"start":{"line":20,"column":3,"offset":896},"end":{"line":20,"column":53,"offset":946}},"text":"text","content":["Reading text and numbers from cells on a worksheet"]}]},{"type":"block","id":"clyTHUi9KuA_iWYHcLf09","margin":"","name":"item","level":1,"location":{"start":{"line":21,"column":1,"offset":947},"end":{"line":21,"column":68,"offset":1014}},"content":[{"type":"para","id":"h6_60hVMaZjzvfSQ2mtA_","margin":"","location":{"start":{"line":21,"column":3,"offset":949},"end":{"line":21,"column":68,"offset":1014}},"text":"text","content":["Creating new workbooks with worksheets with text and number cells"]}]},{"type":"block","id":"TI59TsvbqSnWZ2xxi1Rnd","margin":"","name":"item","level":1,"location":{"start":{"line":22,"column":1,"offset":1015},"end":{"line":23,"column":13,"offset":1095}},"content":[{"type":"para","id":"vbuk4C1Fx1ZhizJSyJHfP","margin":"","location":{"start":{"line":22,"column":3,"offset":1017},"end":{"line":23,"column":13,"offset":1095}},"text":"text","content":["Setting basic styles and number formats on cells in newly created\nworksheets"]}]},{"type":"block","id":"Duz1aoATEa0_A-HcalJrq","margin":"","name":"item","level":1,"location":{"start":{"line":24,"column":1,"offset":1096},"end":{"line":24,"column":64,"offset":1159}},"content":[{"type":"para","id":"ZZg-HDfeajymWAIvRC9lY","margin":"","location":{"start":{"line":24,"column":3,"offset":1098},"end":{"line":24,"column":64,"offset":1159}},"text":"text","content":["Reading a workbook, making modifications, and saving it again"]}]},{"type":"block","id":"6i09uKCVvkbkain-lH4Y4","margin":"","name":"item","level":1,"location":{"start":{"line":25,"column":1,"offset":1160},"end":{"line":25,"column":63,"offset":1222}},"content":[{"type":"para","id":"O4lRAitzYDh-2OP61FoDr","margin":"","location":{"start":{"line":25,"column":3,"offset":1162},"end":{"line":25,"column":63,"offset":1222}},"text":"text","content":["Reading and writing column properties (such as column width)"]}]}]},{"type":"block","id":"Ds6MnbblVkelFl2gkFeTk","margin":"","level":2,"name":"head","location":{"start":{"line":27,"column":1,"offset":1224},"end":{"line":27,"column":12,"offset":1235}},"content":["Synopsis"]},{"type":"block","id":"sLBSs7TeV2Hr1yVqHpTRq","margin":"","level":3,"name":"head","location":{"start":{"line":29,"column":1,"offset":1237},"end":{"line":29,"column":31,"offset":1267}},"content":["Reading existing workbooks"]},{"type":"block","id":"AGhhKr_kj7FA32LoR2FsD","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":31,"column":1,"offset":1269},"end":{"line":51,"column":4,"offset":1913}},"content":[{"type":"verbatim","value":"use Spreadsheet::XLSX;\n\n# Read a workbook from an existing file (can pass IO::Path or a\n# Blob in the case it was uploaded).\nmy $workbook = Spreadsheet::XLSX.load('accounts.xlsx');\n\n# Get worksheets.\nsay \"Workbook has {$workbook.worksheets.elems} sheets\";\n\n# Get the name of a worksheet.\nsay $workbook.worksheets.name;\n\n# Get cell values (indexing is zero-based, done as a multi-dimensional array\n# indexing operation [row ; column].\nmy $cells = $workbook.worksheets[0].cells;\nsay .value with $cells[0;0];      # A1\nsay .value with $cells[0;1];      # B1\nsay .value with $cells[1;0];      # A2\nsay .value with $cells[1;1];      # B2"}]},{"type":"block","id":"Om00hUA246Y1BKykz9yc3","margin":"","level":3,"name":"head","location":{"start":{"line":53,"column":1,"offset":1915},"end":{"line":53,"column":27,"offset":1941}},"content":["Creating new workbooks"]},{"type":"block","id":"Qqq_WMPS6Vsz-MK71OI7v","margin":"","name":"code","config":[{"name":"lang","value":"raku","type":"string"}],"location":{"start":{"line":55,"column":1,"offset":1943},"end":{"line":84,"column":4,"offset":3109}},"content":[{"type":"verbatim","value":"use Spreadsheet::XLSX;\n\n# Create a new workbook and add some worksheets to it.\nmy $workbook = Spreadsheet::XLSX.new;\nmy $sheet-a = $workbook.create-worksheet('Ingredients');\nmy $sheet-b = $workbook.create-worksheet('Matching Drinks');\n\n# Put some data into a worksheet and style it. This is how the model\n# actually works (useful if you want to add styles later).\n$sheet-a.cells[0;0] = Spreadsheet::XLSX::Cell::Text.new(value => 'Ingredient');\n$sheet-a.cells[0;0].style.bold = True;\n$sheet-a.cells[0;1] = Spreadsheet::XLSX::Cell::Text.new(value => 'Quantity');\n$sheet-a.cells[0;1].style.bold = True;\n$sheet-a.cells[1;0] = Spreadsheet::XLSX::Cell::Text.new(value => 'Eggs');\n$sheet-a.cells[1;1] = Spreadsheet::XLSX::Cell::Number.new(value => 6);\n$sheet-a.cells[1;1].style.number-format = '#,###';\n\n# However, there is a convenience form too.\n$sheet-a.set(0, 0, 'Ingredient', :bold);\n$sheet-a.set(0, 1, 'Quantity', :bold);\n$sheet-a.set(1, 0, 'Eggs');\n$sheet-a.set(1, 1, 6, :number-format('#,###'));\n\n# Save it to a file (string or IO::Path name).\n$workbook.save(\"foo.xlsx\");\n\n# Or get it as a blob, e.g. for a HTTP response.\nmy $blob = $workbook.to-blob();"}]},{"type":"block","id":"6aYcJO-lKjyUKYDGa51uc","margin":"","level":2,"name":"head","location":{"start":{"line":86,"column":1,"offset":3111},"end":{"line":86,"column":11,"offset":3121}},"content":["Credits"]},{"type":"para","id":"FRn2G_kRxkTvkH2nuVDzZ","margin":"","location":{"start":{"line":88,"column":1,"offset":3123},"end":{"line":91,"column":87,"offset":3442}},"text":"text","content":["Thanks goes to ",{"meta":"https://agrammon.ch/","type":"fcode","name":"L","content":["Agrammon"]}," for making the development of\nthis module possible. If you need further development on the module and are\nwilling to fund it (or other Raku ecosystem work), you can get in contact with\n",{"meta":"https://www.edument.se/en","type":"fcode","name":"L","content":["Edument"]}," or ",{"meta":"https://www.oetiker.ch/en/","type":"fcode","name":"L","content":["Oetiker+Partner"]},"."]}]},"publishUrl":"/mods/zef/Spreadsheet::XLSX/dist/README.md","pluginsData":{"moduleInfo":{"meta":{"api":"","auth":"zef:jnthn","build-depends":[],"depends":["Libarchive","LibXML:ver<0.6.0+>"],"description":"Work with Excel (XLSX) spreadsheets.","dist":"Spreadsheet::XLSX:ver<0.2.4>:auth<zef:jnthn>","license":"Artistic-2.0","name":"Spreadsheet::XLSX","path":"S/PR/SPREADSHEET_XLSX/ec12baedfe4248ba5de2f31b4467dba8ec5be6ac.tar.gz","perl":"6.*","provides":{"Spreadsheet::XLSX":"lib/Spreadsheet/XLSX.rakumod","Spreadsheet::XLSX::Cell":"lib/Spreadsheet/XLSX/Cell.rakumod","Spreadsheet::XLSX::CellStyle":"lib/Spreadsheet/XLSX/CellStyle.rakumod","Spreadsheet::XLSX::ContentTypes":"lib/Spreadsheet/XLSX/ContentTypes.rakumod","Spreadsheet::XLSX::Exceptions":"lib/Spreadsheet/XLSX/Exceptions.rakumod","Spreadsheet::XLSX::Relationships":"lib/Spreadsheet/XLSX/Relationships.rakumod","Spreadsheet::XLSX::Root":"lib/Spreadsheet/XLSX/Root.rakumod","Spreadsheet::XLSX::SharedStrings":"lib/Spreadsheet/XLSX/SharedStrings.rakumod","Spreadsheet::XLSX::Styles":"lib/Spreadsheet/XLSX/Styles.rakumod","Spreadsheet::XLSX::Workbook":"lib/Spreadsheet/XLSX/Workbook.rakumod","Spreadsheet::XLSX::Worksheet":"lib/Spreadsheet/XLSX/Worksheet.rakumod"},"resources":[],"source-url":"https://github.com/jnthn/spreadsheet-xlsx.git","test-depends":[],"version":"0.2.4"},"files":[{"file":"work_mods/zef/Spreadsheet::XLSX/dist/README.md","publishUrl":"/mods/zef/Spreadsheet::XLSX/dist/README.md"}],"src":"zef","url":"/mods/zef/Spreadsheet::XLSX"}}}
    =end data
    =end React


Work with Excel (XLSX) spreadsheets.


Spreadsheet::XLSX


An interface to libxlsxio, a C library to read and write XLSX files


Spreadsheet::Libxlsxio


The Raku Knowledge Base


=begin React :component<HeaderCol> :id<footer>  
=begin nested :!nested
=item1 B<Language>
    =item2 L<Get started|file:../getting-started/getting-started.podlite>
    =item2 L<Why Raku?|/doc/language/faq#Why-should-I-learn-Raku-What's-so-great-about-it>
    =item2 L<Try Raku|https://glot.io/new/raku>
    =item2 L<Raku cheat sheet|https://github.com/Raku/mu/blob/master/docs/Perl6/Cheatsheet/cheatsheet.txt>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<Raku on Exercism|https://exercism.org/tracks/raku>
    =item2 L<Wikipedia|https://en.wikipedia.org/wiki/Raku_(programming_language)>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>

=end nested
=begin nested :!nested

=item1 B<L<Documentation|/doc>>
    =item2 L<Getting started, Migration guides from other languages, & Tutorials | file:../doc/introduction.podlite>
    =item2 L<Language References|file:../doc/reference.podlite>
    =item2 L<Type Reference| file:../doc/types.podlite>
    =item2 L<Miscellaneous| file:../doc/miscellaneous.podlite>
    =item2 L<FAQs (Frequently Asked Questions)|/doc/language/faq>
    =item2 L<Community|/doc/language/community>
    =item2 L<The list of all documents|file:../doc/index.podlite>

=item1 B<Resources>
    =item2 L<The Raku Guide|https://raku.guide/>
    =item2 L<Books |https://perl6book.com/>
    =item2 L<Rosetta Code | https://www.raku.org/community/rosettacode>

=end nested
=begin nested :!nested

=item1 B<Resoures>
    =item2 L<Download | file:../download/index.podlite>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>

=item1 B<Learning>
    =item2 L<The Raku Guide|https://raku.guide/>
    =item2 L<Wikibook |https://en.wikibooks.org/wiki/Raku_Programming>
    =item2 L<Books |https://perl6book.com/>
    =item2 L<Rosetta Code | https://www.raku.org/community/rosettacode>
    =item2 L<Learn Raku in Y minutes|https://learnxinyminutes.com/docs/raku/>
    =item2 L<Golfing |https://github.com/AlexDaniel/raku-golf-cheatsheet>
=end nested
=begin nested :!nested

=item1 B<Explore>
    =item2 L<Raku Blog Aggregator|https://planet.raku.org/>
    =item2 L<Rakudo Weekly|https://rakudoweekly.blog/>
    =item2 L<The Weekly Challenge |https://perlweeklychallenge.org/>
    =item2 L<Raku Advent Calendar|https://raku-advent.blog/>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>
    =item2 L<empty|#>

=end nested
=end React


=begin React :component<CookieConsent> :id<CookieConsent> :buttonCaption("Got it!")
=para
This website uses cookies for analytics.
=end React


Spreadsheet::ODS

NAME

SYNOPSIS

DESCRIPTION

AUTHOR

has Hash $!archive

multi method load

multi method load

multi method load

COPYRIGHT AND LICENSE

Spreadsheet::ODS v0.1

Authors

License

Dependencies

Test Dependencies

Provides

Documentation