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ϑΝΠϧΛ࡞ͬͯ࡞ۀऀʹ഑෍͓ͯ͘͠ ‣γεςϜ͔Β؆୯ͳExcel΍CSVΛग़ྗͯ͠ ‣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