xlsx出力を Live reloadで（仮）

Niigata.js #1

Transcript

1. XLSXग़ྗΛ
   LIVE RELOADͰʢԾʣ
   Niigata.js #1
   @ooooooo_q
   1
   

   View Slide

2. σʔλग़ྗܥͷ
   ։ൃ
   2
   

   View Slide

3. ϚελܥΛ·ͱΊͯग़ྗ
   Ϣʔβૢ࡞ʹԠͯ͡ग़ྗ݁ՌΛม͑Δ
   ςϯϓϨʔτ͔ΒσʔλͷΠϯϙʔτ
   3
   Α͋͘Δཁ๬
   

   View Slide

4. Α͋͘Δग़ྗܗࣜ
   $47
   ؆୯ʹ࡞ΕΔ
   จࣈίʔυͷѻ͍͕ਏ͍
   YMTɺYNM
   ݹ͍FYDFM޲͚
   YMTY
   YMTΑΓ͸ѻ͍΍͍͢
   4
   

   View Slide

5. 9-49
   0QFO0⒏DF9.-ܗࣜ
   ೥ʹ੍ఆɺ0⒏DFҎ߱
   த਎͸YNMϑΝΠϧʴը૾Λ;JQͰ·ͱΊͨ΋ͷ
   ֦ுࢠΛ[JQʹม׵ͯ͠ɺల։͢Δͱத਎͕ݟΕΔ
   UIJSEQBSUZͰѻΘΕΔ͜ͱ͕લఏͷ΋ͷ
   5
   

   View Slide

6. 9-49ೖ໳
   ࢓༷ॻ͕ެ։͞Ε͍ͯΔ
   ଞͷ0⒏DFΛؚΊͯϖʔδͷQEG
   ೖ໳0⒏DF0QFO9.-
   ಡΈ΍͍͕͢ചͬͯͳ͍
   BNB[POͰͷ࠷௿Ձ͕֨ઍԁ୆͔Β
   6
   

   View Slide

7. 9-49αϯϓϧ
   7
   

   View Slide

8. &91035
   9-49
   8
   

   View Slide

9. Α͘࢖ΘΕΔϥΠϒϥϦ
   +"7"
   "QBDIF10*
   1)1
   1)1&YDFM
   +BWBTDSJQU
   KTYMTY
   9
   

   View Slide

10. αʔόαΠυ74ΫϥΠΞϯταΠυ
    αʔόαΠυ
    طଘͷࢿ࢈͕ଟ͍
    ӡ༻࣌ͷߟྀ఺͕ଟ͍
    ΫϥΠΞϯταΠυ
    طଘͷࢿ࢈͸গͳΊ
    μ΢ϯϩʔυपΓͰϒϥ΢βͷ͕ࠩ͋Δ
    10
    

    View Slide

11. ΫϥΠΞϯταΠυͰͷར఺
    Ϣʔβૢ࡞ʹԠͨ͡ग़ྗม׵͕͠΍͍͢
    ηΩϡϦςΟతͳ҆શੑ
    ௨৴पΓ͕ϘτϧωοΫʹͳΒͳ͍
    อଘ͍ͯ͠ͳ͍σʔλΛѻ͑Δ
    YMTY͸ͭ·ΓɺWJFXͷҰछ
    11
    

    View Slide

12. $-*&/54*%&
    9-49
    12
    

    View Slide

13. ϥΠϒϥϦ
    KTYMTY
    ϝδϟʔͲ͜Ζ
    Կނ͔γʔτΛҰ͔Β࡞Δػೳ͕ͳ͍
    FYDFMKT
    Ϟμϯͳ࡞ΓͷKT
    ʜ
    13
    

    View Slide

14. TRY & ERROR
    ʹΑΔ։ൃ
    14
    

    View Slide

15. ग़ྗ݁ՌΛ֬ೝ͢Δͱ͖
    FYDFM্Ͱ։͍ͯดͯ͡Λ܁Γฦ͢ͷ͸஗͍
    ϒϥ΢β্Ͱ݁ՌΛ֬ೝ͍ͨ͠
    ϥΠϒϥϦϩʔυͰ։ൃΛ͍ͨ͠
    15
    

    View Slide

16. $-*&/54*%&
    9-49
    -*7&3&-0"%
    16
    

    View Slide

17. +"(3*%
    IUUQTLBXBTJNBHJUIVCJPKBHSJE
    17
    

    View Slide

18. &9$&-+4
    IUUQTHJUIVCDPNHVZPOSPDIFFYDFMKT
    "1*ͷ࢖͍ํ͕$44ʹ͍ۙ
    ϑΝΠϧͷಡΈࠐΈɺग़ྗ͕Ͱ͖Δ
    18
    

    View Slide

19. ཱͪ͸͔ͩΔน
    19
    

    View Slide

20. #3084&3Ͱಈ͔ͨ͢Ίʹ
    FYDFMKT͸OPEFKT޲͚
    ґଘ͢ΔϞδϡʔϧ͕OPEFલఏ
    CVOEMF͢Δͱ͖ʹࣺͯΔ
    GTܦ༝ͰͷϑΝΠϧͷಡΈॻ͖
    MPDBMTUPSBHFΛGTͰѻ͏MPDBMGTΛ࢖͏
    SFRVJSFSFTPMWF
    Ͱύεղܾ͞Ε͍ͯΔ
    ࣄલʹϑΝΠϧΛҠಈͯ͠ஔ׵ͯ͠ʜʜ
    20
    

    View Slide

21. ࣮ԋ
    21
    ؒʹ߹͍·ͤΜͰͨ͠ɻ
    

    View Slide

22. PROBLEM?
    22
    

    View Slide

23. Ͱ͖ͳ͍͜ͱ03೉ͦ͠͏ͳ͜ͱ
    ϚΫϩग़ྗ
    άϥϑͷग़ྗ
    ϑΝΠϧΛղੳ͢Ε͹ग़དྷΔʁ
    ਺े.#͋ΔϑΝΠϧͷಡΈॻ͖
    JOEFYFE%#
    TBGBSJͰͷμ΢ϯϩʔυ࣌ʹϑΝΠϧ໊͕6OLPXO
    4ʹҰ౓Ξοϓϩʔυʁ
    23
    

    View Slide

24. จࣈίʔυ͸ʁ
    9.-தʹVUGͷهࡌ͕͋ΔͷͰ໰୊ͳ͍͸ͣʜʁ
    ݕূதʜ
    24
    

    View Slide

25. ηΩϡϦςΟ
    $47ϚΫϩΠϯδΣΫγϣϯ
    ى͜Δͷ͸$47͚ͩʁ
    $FMMJOKFDUJPO
    AAΛΤεέʔϓ͢Δ
    9.-&YUFSOBM&OUJUZ 99&
    
    9.-ͷղੳͰى͜Δ͜ͱ͕͋Δ
    %PT଱ੑ
    αʔόαΠυͰى͜Γ΍͍͢ʢϥΠϒϥϦͷ໰୊ʣ
    25
    

    View Slide

26. OTHERS
    26
    PDF
    CSV
    JSON GeoJSON
    TopoJSON
    KML Shape File GPX
    iCalendar CalDav WebDav
    LTSV
    docx pptx zip
    

    View Slide

27. σʔλग़ྗͷ͋Ε͜Ε
    (JUIVCҎલͷ࢓༷͸ࢄҳ͍ͯ͠Δ͜ͱ͕ଟ͍ҹ৅
    ϥΠϒϥϦ͸͋Δ͕ɺ࣮ࡍʹ࢖͑Δ͔͸ผ
    ඍົʹཉ͍͠΋ͷͱҧ͏৔߹͕ଟ͍
    (FP+40/Š"OZͳม׵
    .BQCPY͕࡞͍ͬͯΔ͜ͱ͕ଟ͍
    27
    

    View Slide

28. 6/*7&34"-+"7"4$3*15
    ޿ٛͰ͸ ʮϒϥ΢βͱnode྆ํͰಈ͘JavaScriptʯɺڱٛͰ͸
    ʮESͷΈͰॻ͔Εͯɺ͜ͷ࢓༷Λຬͨ͢΋ͷͳΒͲ͜Ͱ΋࣮ߦՄ
    ೳʯͱ͍͏֓೦ΛUniversal JavaScriptͱݺΜͩΓ͠·͢ɻগ͠લ
    ·ͰલऀͷΈΛࢦͯ͠ Isomorphic ͱݺΜͩΓ͍ͯ͠·ͨ͠ɻ
    य़͔Β͸͡ΊΔϞμϯ+BWB4DSJQU&4
    IUUQRJJUBDPNNJ[DIJJUFNT
    CCCGBCC
    28
    

    View Slide

29. 29
    server
    browser
    universal
    JSON
    File
    server
    browser
    universal
    JSON
    File
    

    View Slide

30. UNIVERSAL JAVASCRIPT
    OR
    WEB ASSEMBLY …?
    30
    

    View Slide

31. …
    31
    

    View Slide