{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[18,3,18,4],[19,3,19,4],[11,3,11,4],[6,3,6,4],[15,3,15,4],[16,3,16,4]]}
[]
[null,"【楽天アフィリエイトを加速する】楽天市場検索結果アフィリエイトリンク作成ツール"]
[null,"注意：利用の際にはマクロを有効にする必要があります。"]
[null,null,null,"配布サイト","http://afi-r.com/",null,null,"▼使い方"]
[]
[null,null,null,null,null,null,null,"・アフィリエイトIDを入力する"]
[null,null,"アフィリエイトID",null,null,null,null,"・商品名などを検索する"]
[null,null,null,"※アフィリエイトIDの確認方法→","http://afi-r.com/ahiid/",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,null,"▼完成コード"]
[null,null,"検索結果へのURL",{"$f":"+IF(D12=\"\",\"\",+D30&D31&D32&+D37&D38&D39&D34)","v":""},null,null,null,"商品名の後に続く文字の設定"]
[null,null,"検索結果完成タグ",{"$f":"+IF(D12=\"\",\"\",+D47&D48&D49&D50&D51)","v":""},null,null,"→","を楽天市場で探す"]
[null,null,null,null,"▼完成コード"]
[null,null,"口コミページヘのリンク",{"$f":"+IF(D12=\"\",\"\",+D30&D31&D32&+D42&D43&D44&D34)","v":""},null,null,null,"商品名の後に続く文字の設定"]
[null,null,"口コミ検索結果完成タグ",{"$f":"+IF(D12=\"\",\"\",+D55&D56&D57&D58&D59)","v":""},null,null,"→","の口コミを楽天市場で探す"]
[]
[]
[null,"※公式サイトの形式を出来る限り再現する形で成形しています。"]
[null,"※ソフトを利用した事によるいかなる損害も一切の責任を負いません。"]
[null,"※こちらのエクセルファイルは再配布不可です。"]
[]
[null,"▼削除すると動きません。"]
[]
[null,null,"数式"]
[null,null,"固定 1","http://hb.afl.rakuten.co.jp/hgc/"]
[null,null,"アフィリエイトID",{"$f":"+D7","v":0}]
[null,null,"固定 2","/?pc="]
[null,null,"URL"]
[null,null,"固定 3","%3fscid%3daf_link_urltxt&amp;m=http%3a%2f%2fm.rakuten.co.jp%2f"]
[]
[null,null,"検索結果"]
[null,null,"固定1","http%3a%2f%2fsearch.rakuten.co.jp%2fsearch%2fmall%2f"]
[null,null,"検索ワード",{"$f":"+urlEnc(\"UTF-8\",D12)","v":""}]
[null,null,"固定2","%2f-%2f"]
[]
[null,null,"口コミページ検索結果"]
[null,null,"固定1","http%3a%2f%2freview.rakuten.co.jp%2fsearch%2f"]
[null,null,"検索ワード",{"$f":"+urlEnc(\"UTF-8\",D12)","v":""}]
[null,null,"固定2","%2f"]
[]
[null,null,"検索結果リンクアドレス"]
[null,null,"固定1","<a href=\""]
[null,null,"アドレス",{"$f":"+D16","v":""}]
[null,null,"固定2",{"$f":"+IF(H14=D61,E61,E62)","v":"\" target=\"_blank\">"}]
[null,null,"テキスト",{"$f":"+D12&H17","v":"を楽天市場で探す"}]
[null,null,"固定3","</a>"]
[]
[]
[null,null,"口コミページ検索結果へのリンクアドレス"]
[null,null,"固定1","<a href=\""]
[null,null,"アドレス",{"$f":"+D19","v":""}]
[null,null,"固定2",{"$f":"+IF(H14=D61,E61,E62)","v":"\" target=\"_blank\">"}]
[null,null,"テキスト",{"$f":"+D12 &H20","v":"の口コミを楽天市場で探す"}]
[null,null,"固定3","</a>"]
[]
[null,null,"選択項目","今のウィンドウで開く","\">"]
[null,null,null,"新しいウィンドウで開く","\" target=\"_blank\">"]