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

できる?エクセルによるかんたんMovable Typeサイト更新

できる?エクセルによるかんたんMovable Typeサイト更新

Kunihiko Miyanaga

November 28, 2015
Tweet

More Decks by Kunihiko Miyanaga

Other Decks in Technology

Transcript

  1. Ͱ͖ΔʁΤΫηϧʹΑΔ
    ͔ΜͨΜ.PWBCMF5ZQF
    αΠτߋ৽
    4IFFU"TTFUϓϥάΠϯͷ঺հ
    .5%%$.FFUVQ50,:0
    ΞΠσΞϚϯζגࣜձࣾ
    ٶӬ๜඙

    View full-size slide

  2. ࣗݾ঺հ
    ˒೥๺ւಓੜ·Ε
    ˒೥ΞΠσΞϚϯζגࣜձࣾઃཱ
    ˒.PWBCMF5ZQFϓϥάΠϯϕϯμʔ
    ˒.5ܞଳରԠϓϥάΠϯέʔλΠΩοτ
    ˒.5ʹΑΔϓϥάΠϯ΍΢ΣϒαΠτΛଟ਺ߏங
    ˒NJZBOBHBUVNCMSDPN
    ˒!NJZBOBHB

    View full-size slide

  3. ΢ΣϒαΠτʹ͸
    දܗࣜͷίϯςϯπ͕
    ͖ͭ΋ͷ

    View full-size slide

  4. ళฮҰཡ
    ྫ͑͹

    View full-size slide

  5. IUUQXXXXFMFEBKQTIPQIBOEMJOHJOEFYQIQ

    View full-size slide

  6. IUUQXXXPCBHJDPKQTIPQTIPQDHJ BE

    View full-size slide

  7. IUUQqFUTXDPNDPMMBCPMJTU

    View full-size slide

  8. εέδϡʔϧҰཡ

    View full-size slide

  9. IUUQXXXOUKKBDHPKQLPLVSJUTVOFYUNPOUIIUNM

    View full-size slide

  10. Ұཡදܗࣜίϯςϯπ
    $.4ͰͲ͏؅ཧ͢Δʁ
    2VFTUJPO

    View full-size slide

  11. ߲໨਺͕ଟ͍ɾ਺͕ଟ͍
    Α͘มߋ͞ΕΔɾݕࡧ͍ͨ͠
    ৄࡉϖʔδ͕͋Δ
    هࣄʹ͠Α͏

    View full-size slide

  12. σʔλ͕গͳ͍
    ΄ͱΜͲมߋ͕ͳ͍
    UBCMFͰϕλॻ͖͠Α͏

    View full-size slide

  13. ಺༰͕೔ʑมಈ͠
    ৘ใͷ઱౓͕େࣄ
    ϦΞϧλΠϜߋ৽͍ͨ͠
    "1*Ͱ֎෦࿈ܞ

    View full-size slide

  14. தؒͷදܗࣜίϯςϯπ
    ਺͸ͦͦ͜͜ɾมߋ΋গͳ͘͸ͳ͍
    ৄࡉϖʔδ͝ͱʹ͋Δ
    Ͳ͏͠Α͏ʁ

    View full-size slide

  15. දܗࣜͷσʔλ͸
    ԿͰड͚औΔʁ
    2VFTUJPO

    View full-size slide


  16. ΤΫηϧ·ͨ͸
    $47ϑΝΠϧ

    View full-size slide

  17. ूதͯ͠࢓ࣄΛ͍ͯ͠Δͱ
    ͜͏͍͏ϝʔϧ͕དྷΔ

    View full-size slide

  18. ΤΫηϧେ޷͖
    χοϙϯਓ

    View full-size slide

  19. ϏδωεϚϯͷ
    ΤΫηϧͷशಘ཰͸
    ඇৗʹߴ͘
    ͋ΒΏΔ৔໘Ͱ׆༻͞Ε͍ͯΔ

    View full-size slide

  20. ΢ΟΩϖσΟΞʹ΋ࡌ͍ͬͯΔ

    View full-size slide

  21. ۀ຿σʔλ͸
    ݩʑΤΫηϧϑΝΠϧͱͯ͠
    อଘɾڞ༗͞Ε͍ͯΔ͜ͱ͕
    ͱͯ΋ଟ͍

    View full-size slide

  22. ΤΫηϧ͸࢖͑Δ͕
    )5.-͸Θ͔Βͳ͍
    ͦΜͳਓʑͷͨΊʹ
    UBCMFλάΛॻ͘ͷ͕
    8FCσβΠφʔͷେࣄͳ࢖໋

    View full-size slide

  23. ͦ͏Ͱ͸ͳ͍

    View full-size slide

  24. ୭Ͱ΋Ͱ͖Δ࡞ۀ͸
    ࣗಈԽͯ͠
    σβΠφʔ͸΋ͬͱ
    Ձ஋ͷ͋ΔఏҊΛʂ

    View full-size slide

  25. Ͱ΋Ͳ͏͢Ε͹ʁ

    View full-size slide

  26. ҆৺͍ͯͩ͘͠͞

    View full-size slide

  27. 4IFFU"TTFU
    GPS
    .PWBCMF5ZQF

    View full-size slide

  28. ΤΫηϧ΍$47ϑΝΠϧΛղੳ͠
    .5λάͰࣗ༝ʹϨΠΞ΢τͰ͖Δ
    ϓϥάΠϯ

    View full-size slide

  29. ಋೖࣄྫ

    View full-size slide

  30. ๭Ո۩ࡶ՟খചϒϥϯυ

    View full-size slide

  31. ΤΫεϙʔτ
    ঎඼σʔλ$47
    &$αΠτ
    ϝʔΧʔ͝ͱʹදࣔ
    ֤ϝʔΧʔ͸هࣄσʔλ

    View full-size slide

  32. ख࡞ۀͰೖΕସ͑Δͷ͸େม͕ͩ
    "1*Λ։ൃ͢Δ΄ͲͰ͸ͳ͍
    ؆қ֎෦࿈ܞͷ
    ஥հσʔλͱͯ͠
    ΤΫηϧ΍$47͸ศར

    View full-size slide

  33. ϑΝΠϧͷΞοϓϩʔυ
    4FOBSJP

    View full-size slide

  34. ςϯϓϨʔτʹΑΔग़ྗ
    4FOBSJP

    View full-size slide

  35. %SPQCPYڞ༗63-ࢀর
    4FOBSJP

    View full-size slide

  36. ϑΝΠϧΛϩʔΧϧͰอଘ͢Δ
    %SPQCPYʹ্͕Δ

    .5ͰϓϨϏϡʔ΍࠶ߏங͢Δ
    ද͕ߋ৽͞ΕΔ

    View full-size slide

  37. ؅ཧը໘্Ͱ
    ฤूՄೳͳද
    &YBNQMF

    View full-size slide

  38. XJUI
    )BOETPOUBCMF
    IUUQIBOETPOUBCMFDPN

    View full-size slide

  39. ςϯϓϨʔτλάͷྫ

    View full-size slide

  40. දͷߦྻΛϧʔϓ͢Δ
    ςϯϓϨʔτλά
    &YBNQMF

    View full-size slide

  41. " # $ % &
    " # $ % &
    " # $ % &
    " # $ % &

    View full-size slide

  42. σʔλ࡞੒ऀ͕ࣗ༝ʹ
    ߲໨Λ௥ՃͰ͖Δ
    ؅ཧ༻ͷྻͳͲදࣔͨ͘͠ͳ͍
    ྻ΋දࣔ͞Εͯ͠·͏

    View full-size slide

  43. ྻ໊Λࢦఆͯ͠
    σʔλϕʔεɾςʔϒϧͷΑ͏ʹ
    ར༻͢Δྫ
    &YBNQMF

    View full-size slide

  44. " # $ % &
    " # $ % &
    " # $ % &
    " # $ % &
    ߦ໨Λ
    ྻ໊ͱ͢Δ
    # % &ྻͷΈࢀর

    View full-size slide

  45. αϒσʔλϕʔεͱͯ͠ͷར༻
    ๯಄ͷ঎඼ϦετͷࣄྫͰ͸
    ͪ͜ΒͷํࣜΛར༻

    View full-size slide

  46. ΤΫεϙʔτ
    ঎඼σʔλ$47
    &$αΠτ
    ϝʔΧʔ͝ͱʹදࣔ
    ֤ϝʔΧʔ͸هࣄσʔλ

    View full-size slide

  47. %BUB"1*Ͱ
    +BWB4DSJQU͔Β
    ׆༻
    &YBNQMF

    View full-size slide

  48. 4IFFU"TTFUϓϥάΠϯ
    ΤΫηϧ΍$47ϑΝΠϧΛղੳ͠.5λάͰ
    ࣗ༝ʹϨΠΞ΢τ͢ΔͨΊͷϓϥάΠϯ

    View full-size slide

  49. SheetAsset
    for Movable Type
    ΤΫηϧϑΝΠϧ͔Β
    ͻͨ͢Βίϐϖ
    ͦΜͳαΠτߋ৽Λ
    ͍ͯ͠·ͤΜ͔ʁ
    ҆৺͍ͯͩ͘͠͞
    ΤΫηϧϑΝΠϧΛ
    ࣗ༝ʹѻ͑ΔϓϥάΠϯ
    ͋Γ·͢Α
    lͱ΋ʹଟ͘ͷاۀͰར༻͞Ε͍ͯΔ.JDSPTPGUš&YDFMšͱ.PWBCMF5ZQFͷ࿈ಈ͕৽ͨͳՁ஋ΛੜΉͱ֬৴͍ͯ͠·͢ɻz
    γοΫεɾΞύʔτגࣜձࣾ୅දऔక໾ݹլૣ
    ೔ؒ׬શແྉ
    ೥ؒϥΠηϯε ԁ
    ˒ όʔδϣϯΞοϓແঈ
    ˒ ςΫχΧϧαϙʔτࠐΈ
    .PWBCMF5ZQFҎ্ʹରԠ
    "EWBODFE"84൛΋ରԠ˗&YDFMϑΝΠϧͷར༻ʹ͸1FSMϞδϡʔ
    ϧ͕ඞཁͰ͢˗%BUB"1ػೳ*͸.5Ҏ্ʹରԠ˗.JDSPTPGUš
    &YDFMš͸.JDSPTPGU $PSQPSBUJPO ͷ঎ඪ·ͨ͸ొ࿥঎ඪͰ͢
    ˗.PWBCMF5ZQF͸4JY"QBSU -UEͷ঎ඪ·ͨ͸ొ࿥঎ඪͰ͢
    Ξοϓϩʔυ͞Εͨ
    ΤΫηϧϑΝΠϧ΍
    $47ϑΝΠϧΛղੳ
    ΞΠςϜͷछྨʹΤΫηϧϑΝ
    Πϧ YMTͱYMTYϑΝΠϧ྆ํ
    ʹରԠ
    ͱ$47ϑΝΠϧ͕௥Ճ
    ͞Ε·͢ɻը૾ϑΝΠϧͳͲͱ
    ಉ͡Α͏ʹ.PWBCMF5ZQFʹϑΝ
    ΠϧΛΞοϓϩʔυ͢Δ͚ͩͰɺ
    .PWBCMF 5ZQF͕ͦͷ಺༰ʹ΋
    ΞΫηεͰ͖ΔΑ͏ʹͳΓ·͢ɻ
    ςϯϓϨʔτͰ
    ϑΝΠϧͷ಺༰ʹΞΫηε
    ࣗ༝ʹϨΠΞ΢τ
    ΤΫηϧϑΝΠϧ΍$47ϑΝΠ
    ϧͷ಺༰͸ɺςϯϓϨʔτ͔Β
    ࣗ༝ʹΞΫηε͕Ͱ͖·͢ɻ঎
    ඼ҰཡɺࢪઃҰཡͳͲɺ΢Σϒ
    αΠτʹ͸ඞͣͱ͍͍͍ͬͯ΄
    ͲݱΕΔදܗࣜͷίϯςϯπΛɺ
    ͦͷݩσʔλΛ؅ཧ͍ͯ͠Δ
    ϑΝΠϧ͔ΒμΠϨΫτʹੜ੒
    Ͱ͖·͢ɻ
    %BUB"1*ʹରԠ
    +40/σʔλʹΑͬͯ
    ϞόΠϧΞϓϦ΋αϙʔτ
    . P W B C M F 5Z Q F ͷ ৽ ػ ೳ
    %BUB"1*΋͔ͬ͠Γαϙʔτɻ
    ख࣋ͪͷϑΝΠϧΛͦͷ··؆
    қ"1*ͱͯ͠ެ։Ͱ͖·͢ɻ৽
    ͨʹσʔλϕʔε΍γεςϜΛ
    ߏங͢Δ͜ͱͳ͘ɺ+BWB4DSJQU
    ͸΋ͪΖΜɺϞόΠϧΞϓϦΛ
    ͸͡Ίͱ͢ΔϚϧνσόΠεʹ
    ৘ใΛల։ՄೳͰ͢ɻ
    %SPQCPY΍
    $PQZDPNͳͲͷ
    ΦϯϥΠϯετϨʔδରԠ
    ΦϯϥΠϯετϨʔδαʔϏε
    ͔Βڞ༗͞Ε͍ͯΔΤΫηϧϑΝ
    Πϧ΍$47ϑΝΠϧʹ΋ΞΫη
    εͰ͖·͢ɻྫ͑͹ʮϩʔΧϧ
    ͰϑΝΠϧΛอଘͯ͠.5্Ͱ
    ϓϨϏϡʔɾ࠶ߏஙʯɺͨͬͨ
    ͦΕ͚ͩͷૢ࡞ͰɺαΠτΛߋ
    ৽Ͱ͖ͯ͠·͏ϫʔΫϑϩʔ΋
    ߏஙͰ͖·͢ɻ
    IUUQTXXXJEFBNBOTDPNNUTIFFUBTTFU
    ৽ػೳଓʑ։ൃதʂࠓ͙͢ʮTIFFUBTTFUʯͰݕࡧʂ

    View full-size slide

  50. ೔ؒ׬શແྉ
    ॳظඅ༻ෆཁ
    ೥ֹϥΠηϯε
    ԁ

    View full-size slide

  51. γοΫεɾΞύʔτ͔ࣾΒ΋
    ۙ೔ൃച༧ఆʂ

    View full-size slide

  52. ΈΜͳ࢖͑Δ
    ࡞ͬͨਓָ͕Ͱ͖Δ
    .PWBCMF5ZQF

    View full-size slide

  53. JEFBNBOTDPNNUTIFFUBTTFU
    ઈࢍൃചத

    View full-size slide