Ctrl |
IO |
要素 |
TYPE |
変数 |
XPath |
入力オプション |
Fixed |
列 |
行 |
入力値 |
出力値 |
結果 |
詳細 |
メモ |
FOR |
|
|
|
|
|
カウンター:^i、開始値:1、終了値:26、STEP:1 |
|
|
|
|
|
|
|
^i:入力シートの行 |
|
IN |
検索画面 |
URL |
|
|
URL:https://www.jisc.go.jp/app/jis/general/GnrJISSearch.htmlSSearch.html |
|
|
|
|
|
|
|
|
|
IN |
検索欄 |
TEXT |
|
//input[@id="label-f01"] |
入力前クリア |
|
A |
^i |
|
|
|
|
|
|
IN |
一覧表示 |
BUTTON |
|
//form[@name="FORM2"]//div/input |
オン値:CLICK |
TRUE |
|
|
CLICK |
|
|
|
|
IF |
|
|
LABEL |
|
//th[contains(text(),'規格番号')] |
条件:表示 |
|
|
|
|
|
|
|
|
|
OUT |
件数取得 |
LABEL |
|
//div[@class="page-navi"]//p |
|
TRUE |
|
|
|
|
|
|
|
|
IN |
|
STR:LAST-VALUE |
|
|
変数名:^cnt |
|
|
|
|
|
|
|
|
|
OUT |
|
STR:INSTR |
|
|
文字(元):^cnt、数値(新):^len、文言:件中 |
|
|
|
|
|
|
|
|
|
IN |
|
STR:LEFT |
[文字数:^len] |
|
^cnt=LEFT(^cnt, ^len-1) |
|
|
|
|
|
|
|
|
|
OUT |
件数出力 |
STR:OUTPUT |
|
|
変数名:^cnt |
|
B |
^i |
|
|
|
|
|
|
IN |
|
STR:SUBSTITUTE |
|
|
変数名:^str1、セルで指定 |
|
A |
^i |
|
|
|
|
|
|
OUT |
ヘッダー |
TABLE |
[シート名:^str1] |
//table[@class="table-databese1"]/thead |
出力先:新規シート、シート名:JIS_^str1 |
|
A |
1 |
|
|
|
|
|
|
IN |
^row宣言 |
NUM:SUBSTITUTE |
|
|
変数名:^row、代入式:2 |
|
|
|
|
|
|
|
^row:出力シートの行 |
|
IN |
^URL宣言 |
STR:SUBSTITUTE |
|
|
変数名:^URL、代入式: |
|
|
|
|
|
|
|
|
WHILE |
|
|
URL |
[文言:^URL] |
|
条件:文言不一致、文言:^URL |
|
|
|
|
|
|
|
|
|
OUT |
|
URL |
|
|
|
TRUE |
|
|
|
|
|
|
|
|
IN |
^URL代入 |
STR:LAST-VALUE |
|
|
変数名:^URL |
|
|
|
|
|
|
|
^URL:ブラウザのURL |
|
IN |
|
STR:RIGHT |
|
|
^page=RIGHT(^URL, 8) |
|
|
|
|
|
|
|
|
IF |
|
|
VAR-STR |
|
|
条件:文言一致、変数名:^page、文言:pageNo=1 |
|
|
|
|
|
|
|
|
BREAK |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
END-IF |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OUT |
結果欄 |
TABLE |
[シート名:^str1] |
//table[@class="table-databese1"]/tbody |
出力先:新規シート、シート名:JIS_^str1 |
|
A |
^row |
|
|
|
|
|
|
OUT |
表の行数取得 |
FIND-ELEMENT |
|
//table[@class="table-databese1"]/tbody/tr |
|
TRUE |
|
|
|
|
|
|
|
|
IN |
^add代入 |
NUM:LAST-VALUE |
|
|
変数名:^add |
|
|
|
|
|
|
|
^add:表の行数 |
|
IN |
|
NUM:SUBSTITUTE |
[代入式:^add] |
|
変数名:^row、代入式:^row+^add |
|
|
|
|
|
|
|
Excel行を進める |
|
IN |
次へ |
BUTTON |
|
//a[contains(text(),'次へ')] |
オン値:CLICK |
TRUE |
|
|
CLICK |
|
|
|
|
WEND |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ELSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OUT |
エラーMSG |
LABEL |
|
//div[@class="message_"] |
|
|
B |
^i |
|
|
|
|
エラー画面 |
END-IF |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NEXT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|