Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Excelを扱うRubyGemまとめ 2022

Keita Mohri
December 02, 2022

Excelを扱うRubyGemまとめ 2022

Qiita Night~Ruby~

Keita Mohri

December 02, 2022
Tweet

More Decks by Keita Mohri

Other Decks in Programming

Transcript

  1. ࣗݾ঺հ ໟརܒଠ .PISJ,FJUB ‣ 'VTJD$0 -5% ‣ ઌਐٕज़෦໳*P5νʔϜνʔϜϦʔμʔ ‣ 2JJUB4JMWFSड৆

      $POUSJCVUJPOT  ‣ IUUQTGVTJDDPKQNFNCFST ‣ ؤுͬͯॻ͍͚ͨͲ͋·Γ೔ͷ໨Λݟ͍ͯͳ͍هࣄ  23ίʔυ%FFQ%JWFʔσʔλූ߸Խͱ͔ޡΓగਖ਼ͱ͔ʔ  IUUQTRJJUBDPN,UB.JUFNTGBFCGFF 2
  2. TQSFBETIFFU 16 ‣😄 - ͍Ζ͍Ζͳํ๏ͰηϧʹσʔλΛೖΕΒΕΔ ‣🥲 - ܭࢉ͕ࣜೖྗͰ͖ͳ͍ - σϑΥϧτͷϑΥϯτ͕ઃఆͰ͖ͣɺߦ͝ͱɾηϧ͝ͱʹࢦఆ͢Δඞཁ͕͋Δ

    - ৭͕ΧϥʔύϨοτ͔Β͔͠બ΂ͳ͍ - υΩϡϝϯτ͕खബ - υΩϡϝϯτʹࡌ͍ͬͯͳ͍΋ͷ͸ιʔείʔυΛݟͯճΔඞཁ͕͋Δ - ͦ΋ͦ΋.xls͔͠ରԠ͍ͯ͠ͳ͍ɻɻ
  3. SVCZ9- 18 ‣😄 - ਺͕ࣜ࢖͑Δ - ॻࣜઃఆܥͷϝιουʹ໋໊نଇ͕͋ͬͯ෼͔Γ΍͍͢ - .xlsx͕ѻ͑ͯɺಡΈࠐΈɺॻ͖ࠐΈ͕Ͱ͖Δͷ͸͜Ε͚ͩ ‣🥲

    - σϑΥϧτͷϑΥϯτ͕ઃఆͰ͖ͣɺߦ͝ͱɾηϧ͝ͱʹࢦఆ͢Δඞཁ͕͋Δ - ܩઢΛҾ͘ͱ͖ɺηϧͷ্ԼࠨӈͦΕͧΕΛݸผʹࢦఆ͢Δඞཁ͕͋Δ - ޿ൣғʹܩઢΛҾ͘ͱ݁ߨॏ͍ - ஋͕ೖ͍ͬͯͳ͍ηϧͷॻࣜΛ͍͡Ζ͏ͱͨ͠ΒౖΒΕΔ
  4. DBYMTY 20 ‣😄 - Example͕ͱͯ΋ॆ࣮͍ͯ͠ΔͷͰಋೖ͠΍͍͢ - ࢦఆൣғʹҰׅͰॻࣜઃఆ͕Ͱ͖Δ - ਺͕ࣜ࢖͑Δ -

    ͳΜͱάϥϑ·Ͱ࡞Εͯ͠·͏ ‣🥲 - উखʹྻͷ෯͕ௐ੔͞Εͯ͠·͏ - ݻఆ͢ΔͳΒஞҰࢦఆ͢Δඞཁ͕͋Δ - جຊతʹExcelͷηϧ൪஍?ͰͷࢦఆʢA1:C1ͳͲ)ʹͳΔ - ߦɾྻͷindex஋͔Βͷม׵ϝιουΛ༻ҙ͢Ε͹ղܾ͚ͩΕͲ΋ - (༨ஊ)͍͟࡞Ζ͏ͱͨ͠ΒҰےೄͰ͸͍͔ͳ͍😏
  5. "84-BNCEBΛ࢖ͬͯΈΔ 27 ‣.Net Core - Open XML SDK 2.5 for

    Officeͱ͍͏ެࣜSDK͕͋Δ - ͜ΕΛ࢖͑͹Microsoft७ਖ਼ͷϥΠϒϥϦͰExcelϑΝΠϧ͕࡞Εͯ͠·͏ʂ - Open XML SDKΛϥοϓͨ͠ClosedXMLͱ͍͏ϥΠϒϥϦ΋ ‣Python - openpyxlͱ͍͏ϥΠϒϥϦ͕σϑΝΫτΒ͍͠ - ಡΈॻ͖͕Ͱ͖ͯɺάϥϑ΋ग़ͤΔ DTW KTPOͳͲ FYDFM