Qiita Night~Ruby~
ExcelΛѻ͏RubyGem·ͱΊ 20222JJUB/JHIUʙ3VCZʙ 'SJໟརܒଠ1
View Slide
ࣗݾհໟརܒଠ.PISJ,FJUB‣ 'VTJD$0 -5%‣ ઌਐٕज़෦*P5νʔϜνʔϜϦʔμʔ‣ 2JJUB4JMWFSड $POUSJCVUJPOT‣ IUUQTGVTJDDPKQNFNCFST‣ ؤுͬͯॻ͍͚ͨͲ͋·ΓͷΛݟ͍ͯͳ͍هࣄ 23ίʔυ%FFQ%JWFʔσʔλූ߸Խͱ͔ޡΓగਖ਼ͱ͔ʔ IUUQTRJJUBDPN,UB.JUFNTGBFCGFF2
FYDFMHFNݕࡧʂ3
FYDFMHFNݕࡧʂ4
&YDFMܥ(FNۀքʹͱͬͯ͋Μ·Γྑ͘ͳ͍😕
2JJUB/JHIUτϦΨʔͰߋ৽͢Δͧʂ💪
͜ͷ༨നͦΕΛॻ͘ʹڱ͗͢Δ7‣͍Ζ͍Ζௐ·͕ͨ͠ɺ݁ߏͳϘϦϡʔϜʹͳͬͯ͠·ͬͨͷͰ ৄࡉQiitaͷهࣄ, GithubΛ͝ࢀর͍ͩ͘͞ɻ- Qiita: https://qiita.com/Kta-M/items/53083a17b7f0c3645c24- Github : https://github.com/Kta-M/excel_gems
01ௐࠪର
ௐࠪର9‣The Ruby Toolboxͷ্Ґʹ͋Δͷ͔ΒDBYMTYʹҾ͖ܧ͕ΕͨͷͰআ֎ BYMTYΛSBJMTʹಋೖ͢ΔͨΊͷ(FNͳͷͰআ֎
ௐࠪର10‣The Ruby Toolboxͷ্Ґʹ͋Δͷ͔ΒDBYMTYʹҾ͖ܧ͕ΕͨͷͰআ֎ BYMTYΛSBJMTʹಋೖ͢ΔͨΊͷ(FNͳͷͰআ֎
લͱ΄΅มΘͬͯͳ͍ʘ ?P?ʗ
͔ΜͨΜൺֱද12
02ॻ͖ࠐΈ෦
͔ΜͨΜൺֱද14
TQSFBETIFFU15
TQSFBETIFFU16‣😄- ͍Ζ͍Ζͳํ๏ͰηϧʹσʔλΛೖΕΒΕΔ‣🥲- ܭࢉ͕ࣜೖྗͰ͖ͳ͍- σϑΥϧτͷϑΥϯτ͕ઃఆͰ͖ͣɺߦ͝ͱɾηϧ͝ͱʹࢦఆ͢Δඞཁ͕͋Δ- ৭͕ΧϥʔύϨοτ͔Β͔͠બͳ͍- υΩϡϝϯτ͕खബ- υΩϡϝϯτʹࡌ͍ͬͯͳ͍ͷιʔείʔυΛݟͯճΔඞཁ͕͋Δ- ͦͦ.xls͔͠ରԠ͍ͯ͠ͳ͍ɻɻ
SVCZ9-17
SVCZ9-18‣😄- ͕ࣜ͑Δ- ॻࣜઃఆܥͷϝιουʹ໋໊نଇ͕͔͋ͬͯΓ͍͢- .xlsx͕ѻ͑ͯɺಡΈࠐΈɺॻ͖ࠐΈ͕Ͱ͖Δͷ͜Ε͚ͩ‣🥲- σϑΥϧτͷϑΥϯτ͕ઃఆͰ͖ͣɺߦ͝ͱɾηϧ͝ͱʹࢦఆ͢Δඞཁ͕͋Δ- ܩઢΛҾ͘ͱ͖ɺηϧͷ্ԼࠨӈͦΕͧΕΛݸผʹࢦఆ͢Δඞཁ͕͋Δ- ൣғʹܩઢΛҾ͘ͱ݁ߨॏ͍- ͕ೖ͍ͬͯͳ͍ηϧͷॻࣜΛ͍͡Ζ͏ͱͨ͠ΒౖΒΕΔ
DBYMTY19
DBYMTY20‣😄- Example͕ͱͯॆ࣮͍ͯ͠ΔͷͰಋೖ͍͢͠- ࢦఆൣғʹҰׅͰॻࣜઃఆ͕Ͱ͖Δ- ͕ࣜ͑Δ- ͳΜͱάϥϑ·Ͱ࡞Εͯ͠·͏‣🥲- উखʹྻͷ෯͕ௐ͞Εͯ͠·͏- ݻఆ͢ΔͳΒஞҰࢦఆ͢Δඞཁ͕͋Δ- جຊతʹExcelͷηϧ൪?ͰͷࢦఆʢA1:C1ͳͲ)ʹͳΔ- ߦɾྻͷindex͔ΒͷมϝιουΛ༻ҙ͢Εղܾ͚ͩΕͲ- (༨ஊ)͍͟࡞Ζ͏ͱͨ͠ΒҰےೄͰ͍͔ͳ͍😏
ϕϯνϚʔΫ21‣͍Ζ͍Ζͳૢ࡞ΛଌͬͯΈͨ‣શମతʹrubyXLͪΐͬͱॏΊ͔ͳɻɻ
03ಡΈࠐΈ෦
͔ΜͨΜൺֱද23
ׂѪ24‣σʔλΛಡΈऔΔ͚ͩͳΒͲΕͰͰ͖Δ
SPP25‣σʔλςʔϒϧΛಡΉͷ͕ಘҙͳҹ- streamͰগͣͭ͠ಡΈࠐΉ͜ͱ͕Ͱ͖Δ- গͳ͍ϝϞϦͰେ͖ͳϑΝΠϧ͕ಡΊΔ- csv, matrix, xml, yamlͷม͕Մೳ- ϔομΛ༩֤͑ͯߦΛhashͱͯ͠औಘ͢Δ͜ͱՄೳ
04ผͷՄೳੑ
"84-BNCEBΛͬͯΈΔ27‣.Net Core- Open XML SDK 2.5 for Officeͱ͍͏ެࣜSDK͕͋Δ- ͜ΕΛ͑Microsoft७ਖ਼ͷϥΠϒϥϦͰExcelϑΝΠϧ͕࡞Εͯ͠·͏ʂ- Open XML SDKΛϥοϓͨ͠ClosedXMLͱ͍͏ϥΠϒϥϦ‣Python- openpyxlͱ͍͏ϥΠϒϥϦ͕σϑΝΫτΒ͍͠- ಡΈॻ͖͕Ͱ͖ͯɺάϥϑग़ͤΔDTW KTPOͳͲFYDFM
7#"Λ͏28‣VBAΛॻ͍ͨExcelϑΝΠϧΛ࡞ͬͯ࡞ۀऀʹ͓ͯ͘͠‣γεςϜ͔Β؆୯ͳExcelCSVΛग़ྗͯ͠‣VBA͔ΒͦΕΛಡΈࠐΜͰΒͬͯతͷϑΝΠϧΛ࡞‣࠷ऴखஈʁ- ͰԿͰͰ͖Δʂ
05·ͱΊ
·ͱΊ30‣ಡΈࠐΉ͚ͩͳΒroo‣ϦονͳாථΛθϩ͔Β࡞ΔͳΒcxlsx‣ாථͷςϯϓϨʔτΛಡΈࠐΜͰվมͯ͠ग़ྗ͢ΔͳΒrubyXL‣(Ͳ͏ͯ͠.xlsͳΒspreadsheetʣ‣ඞͣ͠rubyͰΒͳͯ͘ͳΒͳ͍ͱ͍͏͜ͱͳ͍‣ଓ͖WebͰʂ- Qiita: https://qiita.com/Kta-M/items/53083a17b7f0c3645c24- Github : https://github.com/Kta-M/excel_gems
͝ਗ਼ௌ͍͖ͨͩ͋Γ͕ͱ͏͍͟͝·ͨ͠Thank You8FBSF)JSJOHIUUQTSFDSVJUGVTJDDPKQ