{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","DATA"],"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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["ループ処理のいろいろ"]
[]
["サンプル処理"]
[]
["DATAシートのデータを検索して特定の文字列が含まれるセルに色を着ける"]
[]
["検索対象文字列",null,"12","<==DATAシート中の文字列で検索したい文字を入れ、処理ボタン（1～3）を押す"]
[]
[]
[null,null,"ループの種類","特徴"]
[null,null,"For　next","あらかじめループ回数を決めて処理を行う"]
[null,null,null,"ループは回数が来たら終了"]
[null,null,null,"あらかじめデータ・LOOPの数がはっきりしている場合の処理に向いている"]
[null,null,null,"処理コードも比較的簡易になる場合が多いので、とりあえずはFor　nextのLOOPがおすすめ"]
[]
[null,null,"Do While Loop","loopの内部にカウンター等を設置して処理をする"]
[null,null,null,"ループを抜ける条件を設定する必要がある（特定の文字、カウンターの回数等々）"]
[null,null,null,"例　Do While s <= dclmn"]
[null,null,null,"ループの処理回数がわからない場合に用いる。ループを抜ける設定をしっかりしないと無限ループになる。"]
[]
[null,null,"Do Until Loop","Do While Loopとほぼ同じだが、ループを抜ける条件の記述が異なる"]
[null,null,null,"Do While s <= dclmn",null,null,"ｓがdclmnより同じか小さいうちはループする"]
[null,null,null,"Do Until s = dclmn",null,null,"ｓがdclmnと同じになるまでループする"]
[]
["ループ処理のポイント"]
[]
[null,"データー量が多くなってくるとループ処理は遅くなりがちです"]
[null,"検索ならば「Find」メソッド"]
[null,"計算ならば「Application.WorksheetFunction」関数を利用してexcelの元々の関数を利用した方が早く処理出来ます"]
[null,"excel関数","=SUM（）"]
[null,"VBA","Application.WorksheetFunction.sum()"]
[null,null,"※WorksheetFunctionは省略可"]

{"sheet":"DATA","index":1,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["受注番号","受注日","受注先コード","受注先名","郵便番号","住所1","住所2","電話番号","担当部署","担当者","品番","品名","数量","単価","支払い条件","納期","運送業者","備考"]
[20100001,44136,1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A1133","金型部品33",5,12500,"120日為手",44166,"路線便可","納期前倒し不可"]
[20100002,44137,1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ001","保守部品001",250,1530,"120日為手",44166]
[20100003,44138,1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E005","電装部品005",1500,825,"120日為手",44168]
[20100004,44138,1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E007","電装部品007",2500,922,"120日為手",44168]
[20100005,44139,1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E009","電装部品009",1250,1210,"120日為手",44169]
[20100006,44140,1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A3216","金型部品25",150,18000,"120日為手",44170,"白猫便限定"]
[20100007,44140,1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S001","仕上げ材001",480,580,"90日為手",44170]
[20100008,44140,1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S005","仕上げ材005",100,1925,"90日為手",44170,null,"代替品でも可"]
[20100009,44141,1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E007","電装部品007",1100,922,"120日為手",44171]
[20100010,44142,1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E001","電装部品001",3000,1460,"120日為手",44172]
[20100011,44143,1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ001","保守部品001",50,1530,"120日為手",44173]
[20100012,44144,1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ002","保守部品002",100,2230,"120日為手",44174]
[20100013,44144,1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ005","保守部品005",120,1820,"120日為手",44174]
[20100014,44144,1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S005","仕上げ材005",500,1925,"90日為手",44174]
[20100015,44144,1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A1255","金型部品11",65,55400,"120日為手",44174,"白猫便限定","納期前倒し可"]
[20100016,44144,1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A2051","金型部品25",112,32500,"120日為手",44174,"白猫便限定"]
[20100017,44145,1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S005","仕上げ材005",500,1925,"90日為手",44175]
[20100018,44146,1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E001","電装部品001",3000,1460,"120日為手",44176]
[20100019,44147,1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ001","保守部品001",50,1530,"120日為手",44177,null,"場合により数量増"]