Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up
for free
できる?エクセルによるかんたんMovable Typeサイト更新
Kunihiko Miyanaga
November 28, 2015
Technology
0
420
できる?エクセルによるかんたんMovable Typeサイト更新
Kunihiko Miyanaga
November 28, 2015
Tweet
Share
More Decks by Kunihiko Miyanaga
See All by Kunihiko Miyanaga
miyanaga
0
44
miyanaga
0
580
miyanaga
1
7.1k
miyanaga
0
540
Other Decks in Technology
See All in Technology
conciergeu
0
130
zak3
1
170
yshr1200
0
170
ocise
1
1.8k
songmu
0
150
ihcomega56
1
460
yoshiori
1
1.1k
kanaugust
PRO
0
150
mito201
1
1.1k
you
0
270
iwashi86
53
23k
gamella
3
1.4k
Featured
See All Featured
pedronauck
652
110k
malarkey
119
16k
destraynor
223
47k
holman
461
280k
moore
125
21k
ufuk
56
5.4k
productmarketing
5
710
bkeepers
408
58k
chriscoyier
145
20k
sstephenson
145
12k
jrom
116
7.2k
akmur
252
19k
Transcript
Ͱ͖ΔʁΤΫηϧʹΑΔ ͔ΜͨΜ.PWBCMF5ZQF αΠτߋ৽ 4IFFU"TTFUϓϥάΠϯͷհ .5%%$.FFUVQ50,:0 ΞΠσΞϚϯζגࣜձࣾ ٶӬ
ࣗݾհ ˒ւಓੜ·Ε ˒ΞΠσΞϚϯζגࣜձࣾઃཱ ˒.PWBCMF5ZQFϓϥάΠϯϕϯμʔ ˒.5ܞଳରԠϓϥάΠϯέʔλΠΩοτ ˒.5ʹΑΔϓϥάΠϯΣϒαΠτΛଟߏங ˒NJZBOBHBUVNCMSDPN ˒!NJZBOBHB
ΣϒαΠτʹ දܗࣜͷίϯςϯπ͕ ͖ͭͷ
ళฮҰཡ ྫ͑
IUUQXXXXFMFEBKQTIPQIBOEMJOHJOEFYQIQ
IUUQXXXPCBHJDPKQTIPQTIPQDHJ BE
Ұཡ
IUUQqFUTXDPNDPMMBCPMJTU
εέδϡʔϧҰཡ
IUUQXXXOUKKBDHPKQLPLVSJUTVOFYUNPOUIIUNM
Ұཡදܗࣜίϯςϯπ $.4ͰͲ͏ཧ͢Δʁ 2VFTUJPO
߲͕ଟ͍ɾ͕ଟ͍ Α͘มߋ͞ΕΔɾݕࡧ͍ͨ͠ ৄࡉϖʔδ͕͋Δ هࣄʹ͠Α͏
σʔλ͕গͳ͍ ΄ͱΜͲมߋ͕ͳ͍ UBCMFͰϕλॻ͖͠Α͏
༰͕ʑมಈ͠ ใͷ͕େࣄ ϦΞϧλΠϜߋ৽͍ͨ͠ "1*Ͱ֎෦࿈ܞ
தؒͷදܗࣜίϯςϯπ ͦͦ͜͜ɾมߋগͳ͘ͳ͍ ৄࡉϖʔδ͝ͱʹ͋Δ Ͳ͏͠Α͏ʁ
දܗࣜͷσʔλ ԿͰड͚औΔʁ 2VFTUJPO
None
ΤΫηϧ·ͨ $47ϑΝΠϧ
ूதͯ͠ࣄΛ͍ͯ͠Δͱ ͜͏͍͏ϝʔϧ͕དྷΔ
None
ΤΫηϧେ͖ χοϙϯਓ
ϏδωεϚϯͷ ΤΫηϧͷशಘ ඇৗʹߴ͘ ͋ΒΏΔ໘Ͱ׆༻͞Ε͍ͯΔ
ΟΩϖσΟΞʹࡌ͍ͬͯΔ
ۀσʔλ ݩʑΤΫηϧϑΝΠϧͱͯ͠ อଘɾڞ༗͞Ε͍ͯΔ͜ͱ͕ ͱͯଟ͍
ΤΫηϧ͑Δ͕ )5.-Θ͔Βͳ͍ ͦΜͳਓʑͷͨΊʹ UBCMFλάΛॻ͘ͷ͕ 8FCσβΠφʔͷେࣄͳ໋
ͦ͏Ͱͳ͍
୭ͰͰ͖Δ࡞ۀ ࣗಈԽͯ͠ σβΠφʔͬͱ Ձͷ͋ΔఏҊΛʂ
ͰͲ͏͢Εʁ
҆৺͍ͯͩ͘͠͞
4IFFU"TTFU GPS .PWBCMF5ZQF
ΤΫηϧ$47ϑΝΠϧΛղੳ͠ .5λάͰࣗ༝ʹϨΠΞτͰ͖Δ ϓϥάΠϯ
ಋೖࣄྫ
Ո۩ࡶ՟খചϒϥϯυ
ΤΫεϙʔτ σʔλ$47 &$αΠτ ϝʔΧʔ͝ͱʹදࣔ ֤ϝʔΧʔهࣄσʔλ
ख࡞ۀͰೖΕସ͑Δͷେม͕ͩ "1*Λ։ൃ͢Δ΄ͲͰͳ͍ ؆қ֎෦࿈ܞͷ հσʔλͱͯ͠ ΤΫηϧ$47ศར
σϞ
ϑΝΠϧͷΞοϓϩʔυ 4FOBSJP
None
ςϯϓϨʔτʹΑΔग़ྗ 4FOBSJP
None
%SPQCPYڞ༗63-ࢀর 4FOBSJP
None
ϑΝΠϧΛϩʔΧϧͰอଘ͢Δ %SPQCPYʹ্͕Δ .5ͰϓϨϏϡʔ࠶ߏங͢Δ ද͕ߋ৽͞ΕΔ
None
ཧը໘্Ͱ ฤूՄೳͳද &YBNQMF
XJUI )BOETPOUBCMF IUUQIBOETPOUBCMFDPN
None
ςϯϓϨʔτλάͷྫ
දͷߦྻΛϧʔϓ͢Δ ςϯϓϨʔτλά &YBNQMF
" # $ % & " # $ % &
" # $ % & " # $ % &
<!-- ߦΛϧʔϓ --> <mt:SheetAssetRows> <!-- ྻΛϧʔϓ --> <mt:SheetAssetColumns> <!-- ηϧΛࢀর
--> <mt:SheetAssetCell /> </mt:SheetAssetColumns> </mt:SheetAssetRows>
σʔλ࡞ऀ͕ࣗ༝ʹ ߲ΛՃͰ͖Δ ཧ༻ͷྻͳͲදࣔͨ͘͠ͳ͍ ྻදࣔ͞Εͯ͠·͏
ྻ໊Λࢦఆͯ͠ σʔλϕʔεɾςʔϒϧͷΑ͏ʹ ར༻͢Δྫ &YBNQMF
" # $ % & " # $ % &
" # $ % & " # $ % & ߦΛ ྻ໊ͱ͢Δ # % &ྻͷΈࢀর
<!-- ߦΛϧʔϓ --> <mt:SheetAssetTable> <!-- BྻͷηϧΛࢀর --> <mt:SheetAssetField name=“B”> <!--
DྻͷηϧΛࢀর --> <mt:SheetAssetField name=“D”> <!-- EྻͷηϧΛࢀর --> <mt:SheetAssetField name=“E”> </mt:SheetAssetTable>
αϒσʔλϕʔεͱͯ͠ͷར༻ ಄ͷϦετͷࣄྫͰ ͪ͜ΒͷํࣜΛར༻
ΤΫεϙʔτ σʔλ$47 &$αΠτ ϝʔΧʔ͝ͱʹදࣔ ֤ϝʔΧʔهࣄσʔλ
%BUB"1*Ͱ +BWB4DSJQU͔Β ׆༻ &YBNQMF
None
·ͱΊ
4IFFU"TTFUϓϥάΠϯ ΤΫηϧ$47ϑΝΠϧΛղੳ͠.5λάͰ ࣗ༝ʹϨΠΞτ͢ΔͨΊͷϓϥάΠϯ
SheetAsset for Movable Type ΤΫηϧϑΝΠϧ͔Β ͻͨ͢Βίϐϖ ͦΜͳαΠτߋ৽Λ ͍ͯ͠·ͤΜ͔ʁ ҆৺͍ͯͩ͘͠͞ ΤΫηϧϑΝΠϧΛ
ࣗ༝ʹѻ͑ΔϓϥάΠϯ ͋Γ·͢Α lͱʹଟ͘ͷاۀͰར༻͞Ε͍ͯΔ.JDSPTPGU&YDFMͱ.PWBCMF5ZQFͷ࿈ಈ͕৽ͨͳՁΛੜΉͱ֬৴͍ͯ͠·͢ɻz γοΫεɾΞύʔτגࣜձࣾදऔకݹլૣ ؒશແྉ ؒϥΠηϯε ԁ ˒ όʔδϣϯΞοϓແঈ ˒ ςΫχΧϧαϙʔτࠐΈ .PWBCMF5ZQFҎ্ʹରԠ "EWBODFE"84൛ରԠ˗&YDFMϑΝΠϧͷར༻ʹ1FSMϞδϡʔ ϧ͕ඞཁͰ͢˗%BUB"1ػೳ*.5Ҏ্ʹରԠ˗.JDSPTPGU &YDFM.JDSPTPGU $PSQPSBUJPO ͷඪ·ͨొඪͰ͢ ˗.PWBCMF5ZQF4JY"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ʯͰݕࡧʂ
ؒશແྉ ॳظඅ༻ෆཁ ֹϥΠηϯε ԁ
γοΫεɾΞύʔτ͔ࣾΒ ۙൃച༧ఆʂ
ΈΜͳ͑Δ ࡞ͬͨਓָ͕Ͱ͖Δ .PWBCMF5ZQF
JEFBNBOTDPNNUTIFFUBTTFU ઈࢍൃചத