{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ボタン","店舗情報出力","関数使用サンプル"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ボタン","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"動作させるのに必要なライブラリ"]
[]
[null,null,null,null,null,null,null,null,null,"----"]
[null,null,null,null,null,null,null,null,null,"WinHttp"]
[null,null,null,null,null,null,null,null,null,"Microsoft WinHTTP Services, version 5.1"]
[null,null,null,null,null,null,null,null,null,"C:\\WINDOWS\\system32\\winhttp.dll"]
[null,null,null,null,null,null,null,null,null,"{662901FC-6951-4854-9EB2-D9A2570F2B2E}"]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"----"]
[null,null,null,null,null,null,null,null,null,"MSHTML"]
[null,null,null,null,null,null,null,null,null,"Microsoft HTML Object Library"]
[null,null,null,null,null,null,null,null,null,"C:\\WINDOWS\\system32\\mshtml.tlb"]
[null,null,null,null,null,null,null,null,null,"{3050F1C5-98B5-11CF-BB82-00AA00BDCE0B}"]
[null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"----"]
[null,null,null,null,null,null,null,null,null,"VBScript_RegExp_55"]
[null,null,null,null,null,null,null,null,null,"Microsoft VBScript Regular Expressions 5.5"]
[null,null,null,null,null,null,null,null,null,"C:\\WINDOWS\\System32\\vbscript.dll\\3"]
[null,null,null,null,null,null,null,null,null,"{3F4DACA7-160D-11D2-A8E9-00104B365C9F}"]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,"----"]
[null,null,null,null,null,null,null,null,null,"ADODB"]
[null,null,null,null,null,null,null,null,null,"Microsoft ActiveX Data Objects 2.8 Library"]
[null,null,null,null,null,null,null,null,null,"C:\\Program Files\\Common Files\\System\\ado\\msado15.dll"]
[null,null,null,null,null,null,null,null,null,"{2A75196C-D9EB-4129-B803-931327F72D5C}"]
[null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,"----"]

{"sheet":"店舗情報出力","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["店番:794","自由が丘支店","じゆうがおか","〒152-0035　東京都目黒区自由が丘１−３０−３","03-5729-3811 　土曜　03-5729-3688 ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA590229/"]
["母店:794 自由が丘支店","ATMコーナー　九品仏駅前",null,"東京都世田谷区奥沢８−３１−６",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA608823/"]
["母店:794 自由が丘支店","ATMコーナー　田園調布駅東口",null,"東京都大田区田園調布２−６２−２０",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592059/"]
["母店:794 自由が丘支店","ATMコーナー　東急大岡山駅",null,"東京都大田区北千束３−２７−１",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA753536/"]
["母店:794 自由が丘支店","ATMコーナー　東急奥沢駅",null,"東京都世田谷区奥沢３−４７−１７",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA841473/"]
["母店:794 自由が丘支店","ATMコーナー　東急自由が丘駅",null,"東京都目黒区自由が丘１−９−８",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA807719/"]
["母店:794 自由が丘支店","ATMコーナー　東急多摩川駅",null,"東京都大田区田園調布１−５３−８",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA804739/"]
["母店:794 自由が丘支店","ATMコーナー　沼部駅前",null,"東京都大田区田園調布本町２９−２",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590741/"]
["母店:794 自由が丘支店","ATMコーナー　雪が谷大塚駅前",null,"東京都大田区南雪谷２−２−１４",null,"http://sasp.mapion.co.jp//b/bk_mufg/info/BA591249/"]

{"sheet":"関数使用サンプル","index":2,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"使える関数",null,"※数式の計算方法が自動になっていれば、店番のセルの変更や関数のコピペで動的に値を取得します"]
[null,null,"getshopname()","店名を取得"]
[null,null,"getshopaddress()","店舗住所を取得"]
[null,null,"getshoptel()","店舗電話番号を取得"]
[null,null,"getshopfurigana()","店舗名振り仮名を取得"]
[null,null,"getshopurl","店舗URLを取得（店舗検索WEBの詳細情報）"]
[]
[null,null,"渡す店番について",null,"※セルの書式設定が数値でも作動します"]
[null,null,"3桁の数字の場合",null,"そのまま店舗情報を検索して返します。該当する店舗がない場合には空文字列を返します"]
[null,null,"0で始まる4桁の数字の場合",null,"下3桁で店舗情報を検索して返します"]
[null,null,"1桁または2桁の数字の場合",null,"先頭を0埋めして3桁にして店舗情報を検索して返します"]
[null,null,"0以外の数字で始まる4桁の場合",null,"実店舗以外の情報取得はまだ実装していません。空文字列を返します"]
[null,null,"上記以外の場合",null,"空文字列を返します"]
[]
[]
[null,null,"店番入力セル",null,"店名","郵便番号","住所","電話番号","店名振り仮名","店舗URL"]
[null,null,null,"関数","=getshopname()","=getshopzipcode()","=getshopaddress()","=getshoptel()","=getshopfurigana()","=getshopurl()"]
[null,null,"700",null,{"$f":"getshopname(C20)","v":"三軒茶屋支店"},{"$f":"getshopzipcode(C20)","v":"154-0024"},{"$f":"getshopaddress(C20)","v":"東京都世田谷区三軒茶屋２−１１−１７"},{"$f":"getshoptel(C20)","v":"03-3413-7211 "},{"$f":"getshopfurigana(C20)","v":"さんげんぢゃや"},{"$f":"getshopurl(C20)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590468/"}]
[null,null,"001",null,"本店",{"$f":"getshopzipcode(C21)","v":"100-8388"},{"$f":"getshopaddress(C21)","v":"東京都千代田区丸の内２−７−１"},{"$f":"getshoptel(C21)","v":"03-3240-1111 "},{"$f":"getshopfurigana(C21)","v":"ほんてん"},{"$f":"getshopurl(C21)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA591940/"}]
[null,null,"002",null,"丸の内支店","100-8388",{"$f":"getshopaddress(C22)","v":"東京都千代田区丸の内２−７−１"},{"$f":"getshoptel(C22)","v":"03-3212-1551 "},{"$f":"getshopfurigana(C22)","v":"まるのうち"},{"$f":"getshopurl(C22)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA591945/"}]
[null,null,"003",null,"瓦町支店","541-0048",{"$f":"getshopaddress(C23)","v":"大阪府大阪市中央区瓦町２−１−１"},{"$f":"getshoptel(C23)","v":"06-6203-6293 "},{"$f":"getshopfurigana(C23)","v":"かわらまち"},{"$f":"getshopurl(C23)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590122/"}]
[null,null,"004",null,"船場支店","541-0056",{"$f":"getshopaddress(C24)","v":"大阪府大阪市中央区久太郎町２−１−３０"},{"$f":"getshoptel(C24)","v":"06-6262-0007 "},{"$f":"getshopfurigana(C24)","v":"せんば"},{"$f":"getshopurl(C24)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590123/"}]
[null,null,"005",null,"大阪営業部","541-8530",{"$f":"getshopaddress(C25)","v":"大阪府大阪市中央区伏見町３−５−６"},{"$f":"getshoptel(C25)","v":"06-6206-8111 "},{"$f":"getshopfurigana(C25)","v":"おおさかえいぎょうぶ"},{"$f":"getshopurl(C25)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590166/"}]
[null,null,null,null,"","",{"$f":"getshopaddress(C26)","v":""},{"$f":"getshoptel(C26)","v":""},{"$f":"getshopfurigana(C26)","v":""},{"$f":"getshopurl(C26)","v":""}]
[null,null,"3",null,"瓦町支店","541-0048",{"$f":"getshopaddress(C27)","v":"大阪府大阪市中央区瓦町２−１−１"},{"$f":"getshoptel(C27)","v":"06-6203-6293 "},{"$f":"getshopfurigana(C27)","v":"かわらまち"},{"$f":"getshopurl(C27)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590122/"}]
[null,null,"20",null,"日本橋支店","103-0021",{"$f":"getshopaddress(C28)","v":"東京都中央区日本橋本石町１−３−２"},{"$f":"getshoptel(C28)","v":"03-3272-5151 "},{"$f":"getshopfurigana(C28)","v":"にほんばし"},{"$f":"getshopurl(C28)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA591961/"}]
[null,null,"0111",null,"都立大学駅前支店","152-0022",{"$f":"getshopaddress(C29)","v":"東京都目黒区柿の木坂１−３０−８"},{"$f":"getshoptel(C29)","v":"03-3718-5181 "},{"$f":"getshopfurigana(C29)","v":"とりつだいがくえきまえ"},{"$f":"getshopurl(C29)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592061/"}]
[null,null,"0112",null,"宇治大久保支店","611-0031",{"$f":"getshopaddress(C30)","v":"京都府宇治市広野町茶屋裏１８−１"},{"$f":"getshoptel(C30)","v":"0774-44-5311 "},{"$f":"getshopfurigana(C30)","v":"うじおおくぼ"},{"$f":"getshopurl(C30)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA590221/"}]
[null,null,"0113",null,{"$f":"getshopname(C31)","v":""},"",{"$f":"getshopaddress(C31)","v":""},{"$f":"getshoptel(C31)","v":""},{"$f":"getshopfurigana(C31)","v":""},{"$f":"getshopurl(C31)","v":""}]
[null,null,"0114",null,"尾西支店","494-0008","愛知県一宮市東五城字備前８−１","0586-62-7221 ","びさい","http://sasp.mapion.co.jp//b/bk_mufg/info/BA590441/"]
[null,null,"0115",null,"大森支店","143-0023","東京都大田区山王２−３−１０","03-3771-0161 ","おおもり","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592062/"]
[null,null,"0116",null,"池上支店","146-0082","東京都大田区池上４−３２−１１","03-3751-2145 ","いけがみ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592066/"]
[null,null,"0117",null,"蒲田支店","144-0052",{"$f":"getshopaddress(C35)","v":"東京都大田区蒲田５−１２−６"},{"$f":"getshoptel(C35)","v":"03-3732-2231 "},{"$f":"getshopfurigana(C35)","v":"かまた"},{"$f":"getshopurl(C35)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592068/"}]
[null,null,"0118",null,"羽田支店","144-0032",{"$f":"getshopaddress(C36)","v":"東京都大田区北糀谷１−１２−５"},{"$f":"getshoptel(C36)","v":"03-3741-1115 "},{"$f":"getshopfurigana(C36)","v":"はねだ"},{"$f":"getshopurl(C36)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592072/"}]
[null,null,"0119",null,"長原支店","145-0064",{"$f":"getshopaddress(C37)","v":"東京都大田区上池台１−９−１"},{"$f":"getshoptel(C37)","v":"03-3720-0171 "},{"$f":"getshopfurigana(C37)","v":"ながはら"},{"$f":"getshopurl(C37)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592075/"}]
[null,null,"0120",null,{"$f":"getshopname(C38)","v":""},"",{"$f":"getshopaddress(C38)","v":""},{"$f":"getshoptel(C38)","v":""},{"$f":"getshopfurigana(C38)","v":""},{"$f":"getshopurl(C38)","v":""}]
[null,null,"0121",null,"南浦和支店","336-0017",{"$f":"getshopaddress(C39)","v":"埼玉県さいたま市南区南浦和２−３９−１８"},"048-883-3451 ","みなみうらわ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592076/"]
[null,null,"0122",null,"","",{"$f":"getshopaddress(C40)","v":""},"","",""]
[null,null,"0123",null,"横浜中山支店","226-0013",{"$f":"getshopaddress(C41)","v":"神奈川県横浜市緑区寺山町８９−２"},"045-933-2541 ","よこはまなかやま","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592080/"]
[null,null,"0124",null,"東戸塚支店","244-0801",{"$f":"getshopaddress(C42)","v":"神奈川県横浜市戸塚区品濃町５４９−２"},"045-826-1331 ","ひがしとつか","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592082/"]
[null,null,"0125",null,"練馬平和台支店","179-0085",{"$f":"getshopaddress(C43)","v":"東京都練馬区早宮２−１７−３３"},{"$f":"getshoptel(C43)","v":"03-5399-3271 "},{"$f":"getshopfurigana(C43)","v":"ねりまへいわだい"},{"$f":"getshopurl(C43)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592083/"}]
[null,null,"0126",null,{"$f":"getshopname(C44)","v":"昭島支店"},"196-0015",{"$f":"getshopaddress(C44)","v":"東京都昭島市昭和町５−９−１"},{"$f":"getshoptel(C44)","v":"042-542-1601 "},{"$f":"getshopfurigana(C44)","v":"あきしま"},{"$f":"getshopurl(C44)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592084/"}]
[null,null,"0127",null,{"$f":"getshopname(C45)","v":"下北沢支店"},"155-0031",{"$f":"getshopaddress(C45)","v":"東京都世田谷区北沢１−３９−９"},{"$f":"getshoptel(C45)","v":"03-5453-0931 "},{"$f":"getshopfurigana(C45)","v":"しもきたざわ"},{"$f":"getshopurl(C45)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592085/"}]
[null,null,"0128",null,"久我山駅前支店","168-0082","東京都杉並区久我山５−７−１７","03-5370-3101 ","くがやまえきまえ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592087/"]
[null,null,"0129",null,"田園調布駅前出張所","145-0071","東京都大田区田園調布３−２５−１５","03-3722-8211 ","でんえんちょうふえきまえ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592088/"]
[null,null,"0130",null,"世田谷支店","154-0024","東京都世田谷区三軒茶屋２−１１−１７","03-3411-0181 ","せたがや","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592089/"]
[null,null,"0131",null,"玉川支店","158-0094","東京都世田谷区玉川２−２４−５","03-3700-7131 　土曜　03-3708-0317 ","たまがわ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592091/"]
[null,null,"0132",null,"成城支店","157-0066","東京都世田谷区成城６−１５−１","03-3482-4311 ","せいじょう","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592094/"]
[null,null,"0133",null,"表参道支店","107-0061","東京都港区北青山３−６−１","03-3499-0871 ","おもてさんどう","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592097/"]
[null,null,"0134",null,"橿原支店","634-0078","奈良県橿原市八木町１−８−２２","0744-22-5252 ","かしはら","http://sasp.mapion.co.jp//b/bk_mufg/info/BA590145/"]
[null,null,"0135",null,"渋谷支店","150-8967","東京都渋谷区道玄坂１−３−２","03-3463-1811 ","しぶや","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592100/"]
[null,null,"0136",null,"恵比寿支店","150-0021","東京都渋谷区恵比寿西１−８−６","03-3463-3211 ","えびす","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592102/"]
[null,null,"0137",null,{"$f":"getshopname(C55)","v":"代々木上原支店"},{"$f":"getshopzipcode(C55)","v":"151-0066"},{"$f":"getshopaddress(C55)","v":"東京都渋谷区西原３−８−５"},{"$f":"getshoptel(C55)","v":"03-3467-2321 "},{"$f":"getshopfurigana(C55)","v":"よよぎうえはら"},{"$f":"getshopurl(C55)","v":"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592105/"}]
[null,null,"0138",null,"笹塚支店","151-0073","東京都渋谷区笹塚１−５５−２","03-3376-5141 ","ささづか","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592107/"]
[null,null,"0139",null,"","","","","",""]
[null,null,"0140",null,"学芸大学駅前支店","152-0004","東京都目黒区鷹番２−１９−２４","03-5721-6751 ","がくげいだいがくえきまえ","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592110/"]
[null,null,"0141",null,"","","","","",""]
[null,null,"0142",null,"大泉学園支店","178-0063","東京都練馬区東大泉４−２−１２","03-5387-1801 ","おおいずみがくえん","http://sasp.mapion.co.jp//b/bk_mufg/info/BA592111/"]
[null,null,"0143",null,"四貫島支店","554-0014","大阪府大阪市此花区四貫島２−１−２","06-6468-1301 ","しかんじま","http://sasp.mapion.co.jp//b/bk_mufg/info/BA590148/"]
[null,null,"0144",null,"関西中央支店","541-8530","大阪府大阪市中央区伏見町３−５−６","","かんさいちゅうおう","http://sasp.mapion.co.jp//b/bk_mufg/info/BA591883/"]
[null,null,"0145",null,"阪急梅田北支店","530-0012","大阪府大阪市北区芝田１−１−３","06-6372-7101 ","はんきゅううめだきた","http://sasp.mapion.co.jp//b/bk_mufg/info/BA590078/"]
[null,null,"0146",null,"あかね支店","100-0005","東京都千代田区丸の内２−７−２","","あかね","http://sasp.mapion.co.jp//b/bk_mufg/info/BA591884/"]
[null,null,"0147",null,"新東京支店","100-0005","東京都千代田区丸の内２−７−２","","しんとうきょう","http://sasp.mapion.co.jp//b/bk_mufg/info/BA591877/"]
[null,null,"0148",null,"竹橋支店","100-0005","東京都千代田区丸の内２−７−２","","たけばし","http://sasp.mapion.co.jp//b/bk_mufg/info/BA591878/"]
[null,null,"228",null,{"$f":"getshopname(C67)","v":"町田支店"},{"$f":"getshopzipcode(C67)","v":"194-8558"},{"$f":"getshopaddress(C67)","v":"東京都町田市原町田６−１１−１９"},{"$f":"getshoptel(C67)","v":"042-722-5033 　土曜　042-722-5143 "},{"$f":"getshopfurigana(C67)","v":"まちだ"},"http://sasp.mapion.co.jp//b/bk_mufg/info/BA592212/"]