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

xlsx出力を Live reloadで(仮)

xlsx出力を Live reloadで(仮)

Niigata.js #1

ooooooo_q

April 23, 2016
Tweet

More Decks by ooooooo_q

Other Decks in Technology

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