「プログラミング」の編集履歴(バックアップ)一覧はこちら
「プログラミング」(2013/02/28 (木) 13:49:27) の最新版変更点
追加された行は緑色になります。
削除された行は赤色になります。
<div class="line number4 index3 alt1" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
■excelで緯度経度から住所を取得することができる。</div>
<div class="line number4 index3 alt1" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code> </div>
<div class="line number5 index4 alt2" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code><code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">Dim</code>
<code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">
緯度</code> <code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">
As</code> <code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">
Single</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">,
経度</code> <code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">
As</code> <code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">
Single</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">,
住所</code> <code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">
As</code> <code class="vb keyword" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;font-weight:bold;color:rgb(0,102,153);">
String</code></div>
<div class="line number6 index5 alt1" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code> </div>
<div class="line number7 index6 alt2" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">緯度
= Range(</code><code class="vb string" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#0000FF;">"A2"</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">).Value</code>
<code class="vb comments" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:rgb(0,130,0);">
'A2セルから緯度を取得</code></div>
<div class="line number8 index7 alt1" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">経度
= Range(</code><code class="vb string" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#0000FF;">"B2"</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">).Value</code>
<code class="vb comments" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:rgb(0,130,0);">
'B2セルから経度を取得</code></div>
<div class="line number9 index8 alt2" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code> </div>
<div class="line number10 index9 alt1 highlighted" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:rgb(224,224,224);float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">住所
= ReverseGeoCoding(緯度, 経度)</code> <code class="vb comments" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:rgb(0,130,0);">
'住所へ変換</code></div>
<div class="line number11 index10 alt2" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code> </div>
<div class="line number12 index11 alt1" style="font-size:14px;line-height:15.390625px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;color:rgb(117,117,117);margin:0px;padding:0px 1em;border:0px;vertical-align:baseline;background-image:none;background-color:#FFFFFF;float:none;height:auto;width:auto;">
<code class="vb spaces" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;">
</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">Range(</code><code class="vb string" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#0000FF;">"C2"</code><code class="vb plain" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:#000000;">).Value
= 住所</code> <code class="vb comments" style="margin:0px;padding:0px;border:0px;font-size:1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:1.1em;background-image:none;float:none;height:auto;width:auto;color:rgb(0,130,0);">
'住所をC2セルに表示</code></div>