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