{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Main","About"],"not_rendered":{"charts":0,"images":1,"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":"Main","index":0,"n_rows":1001,"n_cols":25,"rows_kept":1001,"cut":false,"hidden":false,"merged":[[0,10,0,15],[19,10,19,12]]}
["No.","Publication No.","Download No.","Re-download No.",null,null,null,null,"Download Folder",null,"D:\\Data\\",null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[{"$f":"ROW()-1","v":1},null,null,null,null,null,null,null,null,null,null,"← Seleniumbasicのインストール先、通常は空欄でOK、記載する際にはドライブ名から\\Seleniumbasicまでフルパスで記入"]
[{"$f":"ROW()-1","v":2},null,null,null,null,null,null,null,"DL form Espacenet",null,1,"　　　0： No、　1： Yes　",null,0,"proxyホスト→",null,"← 通常は空でＯＫ、プロキシ利用環境のときは、ホスト名を入力"]
[3,null,null,null,null,null,null,null,"Browser",null,0,"　0： Chrome 、1： Edge　",null,1,"proxy ポート番号→",null,"← 通常は空でＯＫ、プロキシ利用環境のときは、ポート番号を入力"]
[4,null,null,null,null,null,null,null,null,null,0,"← ブラウザ表示：　0：非表示、1：表示、2：枠外表示"]
[5,null,null,null,null,null,null,null,null,": PDF not found"]
[6,null,null,null,null,null,null,null,null,": Download from Google succeeded"]
[7,null,null,null,null,null,null,null,null,": Download from Espacenet succeeded"]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15,null,null,null,null,{"$f":"About!B2","v":"    Google Patents Downloader (GPD)  ver. 2.80E    Copyright © 2019-2024  I. Sawaki "}]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[{"$f":"ROW()-1","v":66}]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[{"$f":"ROW()-1","v":130}]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[{"$f":"ROW()-1","v":194}]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[{"$f":"ROW()-1","v":258}]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[{"$f":"ROW()-1","v":322}]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[{"$f":"ROW()-1","v":386}]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[{"$f":"ROW()-1","v":450}]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[{"$f":"ROW()-1","v":514}]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[{"$f":"ROW()-1","v":578}]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[{"$f":"ROW()-1","v":642}]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[{"$f":"ROW()-1","v":706}]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[{"$f":"ROW()-1","v":770}]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[{"$f":"ROW()-1","v":834}]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[{"$f":"ROW()-1","v":898}]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[{"$f":"ROW()-1","v":962}]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"About","index":1,"n_rows":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,"    Google Patents Downloader (GPD)  ver. 2.80E    Copyright © 2019-2024  I. Sawaki "]
[null,null,null,null,null,null,null,"　　URL：","https://pe-sawaki.com/tool/gpd"]
[null,null,null,null,null,null,null,"　　Mail ：","cycle.sawaki@nifty.com"]
[]
[null,"※※ インストラクション　※※"]
[null,1,"K1に、公報をダウンロードするフォルダ名を入力（絶対パスで記入）"]
[null,2,"B列に、公報番号を入力する（貼りつける）（最大1000公報）"]
[null,3,"Auto ボタンをクリックすると、pdf公報のダウンロードが順番に行われる"]
[null,null,"　Google Patentsで見つからないものは赤色、pdf公報がないものはオレンジ色表示される"]
[null,4,"赤色やオレンジ色になった公報は、ダウンロード番号を見直す"]
[null,null,"　Google Patents ボタンをクリックし、Google Patentsサイトで、適当な公報番号を探す"]
[null,null,"　再取得に適当な番号があれば、その公報番号を同じ行のD列（再ダウンロード番号）に記入する"]
[null,5,"Manual ボタンをクリックすると、D列に記載したpdf公報がダウンロードされる"]
[null,6,"Clearボタンをクリックすると、B～D列のデータが消去される（pdf公報は削除されない）"]
[]
[null,"★★","このバージョンでは、Google Patents にPDF公報が無い場合、EspacenetからPDF公報をダウンロードします。"]
[null,null,"Espacenetへのアクセスには、Google Chrome またはMicrosoft Edge を使用するので、以下の3点を要確認"]
[]
[null,null,"　①ブラウザとしGoogle Chrome または Microsoft Edge がインストールされていること"]
[]
[null,null,"　②ブラウザをExcelから操作するためのドライバー（Seleniumbasic）のインストールが必要"]
[null,null,"　　　以下のURLにアクセス"]
[null,null,"　　　https://florentbr.github.io/SeleniumBasic/"]
[null,null,"　　　このページの、Download欄の 「Release page」をクリック"]
[null,null,"　　　Assets欄の「SeleniumBasic-2.0.9.0.exe」をクリック"]
[null,null,"　　　ダウンロードしたファイルを実行して、SeleniumBasicをインストールする"]
[null,null,"　　　参考：　http://kensyou-d.info/selenium.html　　ここではChromeドライバまたはEdgeドライバのインストールは不要"]
[]
[null,null,"　③Seleniumbasicの動作に必要な .NET Framework 3.5 のインストールが必要"]
[null,null,"　　　以前は多くのPCにインストール済みでしたが、最近のPCの場合には、以下のURLの記載を参考にして"]
[null,null,"　　　.NET Framework 3.5 がインストールされているかどうかをチェックし、インストールされていない場合"]
[null,null,"　　　インストールしてください"]
[null,null,"　　　https://office-hack.com/windows/windows10-netframework/"]
[]
[null,null,"　　※ ブラウザの操作には、別途、ブラウザのバージョンと合わせた最新のchromedriver.exeまたはedgedriver.exe"]
[null,null,"　　　　が必要がです、本ツール（GPD)では、自動的に最新のドライバファイルをダウンロードしてインストールする"]
[null,null,"　　　　ので、ユーザー側での操作は不要"]
[null,null,"　　　　　　＊自動でドライバの更新ができない場合、セルK2にSeleniumbasicのフォルダ名を"]
[null,null,"　　　　　　　 記入すると、自動更新がうまくいくことがある"]
[null,null,"　　　　（Webdriver Manager を使用：開発者のyamato1413氏に感謝）"]
[null,null,"　　　　https://qiita.com/yamato1413/items/4b982aee46f28358fd39"]
[]
[null,"☆☆","Microsoftのセキュリティ強化に伴って、Excelマクロが無効となっている場合の対応"]
[null,null,"　　①ファイルをローカルドライブ、ネットワーク共有、クラウド共有等に保存"]
[null,null,"　　②エクスプローラー を開き、ファイルを保存したフォルダーに移動"]
[null,null,"　　③ファイルを右クリックし、コンテキスト メニュー から [プロパティ ] を選択"]
[null,null,"　　④[全般] タブの 下部 に、[セキュリティ] のセクションが表示されるので、"]
[null,null,"　　　 [ブロック解除 ] チェック ボックスをオン にして、[OK] を選択"]
[null,null,"　　　参考：　https://forest.watch.impress.co.jp/docs/news/1386850.html"]
[]
[]
[null,"☆☆ 公報番号のフォーマット ☆☆"]
[null,"        JP","公開：特開2017-123456、特開平08-123456、特開昭61-123456、JP2017-123456"]
[null,null,"公表：特表2017-523456、特表平08-523456、特表昭61-523456、JP2017-523456"]
[null,null,"再表：再表2017-123456、WO17/123456、WO2017/123456、JPWO2017-123456"]
[null,null,"登録：特許05671234、JP05671234"]
[]
[null,"　　　　US","公開：US2017-123456、US2017123456"]
[null,null,"登録：US1234567、US12345678"]
[]
[null,"        WO","公開：WO2017-123456A、WO2017123456A"]
[]
[null,"　　　　EP","公開：EP1234567A"]
[null,null,"登録：EP1234567B"]
[]
[null,"        CN","公開：CN123456789A"]
[null,null,"登録：CN123456789B"]
[null,null,"実案：CN123456789U"]
[]
[null,"        KR","公開：KR2017-0123456、KR2017-0123456A、KR20170123456、KR20170123456A"]
[null,null,"登録：KR1234567、KR1234567B、KR101234567、KR101234567B"]
[]
[null,"        RU","公開：RU2017-123456A、RU2017123456A"]
[null,null,"登録：RU1234567C"]
[]
[null,"Ver 1.00","2019-06-10","完成版"]
[null,"Ver 1.01","2019-06-18","公報番号中のスペースを削除"]
[null,"Ver 1.10","2019-08-13","再表公報は、\"JPWO\"で始まる公報を取得"]
[null,"Ver 1.20","2019-08-20","Google Patents に公報が収録されていない場合の、Google側の挙動変更に対応"]
[null,"Ver 1.30","2019-09-16","ファイルサイズの大きい公報に対応し、スピードアップのために処理アルゴリズムを大幅変更"]
[null,"Ver 1.40","2020-07-09","PC機種によって動作しないケースがあることに対応"]
[null,"Ver 1.50","2020-09-15","KR特許に対応"]
[null,"Ver 1.60","2021-02-09","公報番号中の全角英数字、半角英小文字を半角大文字に変換"]
[null,"Ver 1.70","2021-03-16","ネットワーク環境によってはアクセスできない場合に一部対応"]
[null,"Ver 1.80","2021-04-01","Google Patents へのアクセス方法の一部見直し"]
[null,"Ver 1.90","2021-04-14","Google Patents へのアクセスが失敗したとき、VB標準のWebBrowserコントロールで再トライ"]
[null,"Ver 2.00","2021-04-20","WO公報のうち、日本で再公表されているものは再公表公報をダウンロードする機能を組み込み"]
[null,"Ver 2.10","2021-04-23","PDFをダウンロードしたフォルダを開く機能を追加"]
[null,"Ver 2.20","2022-05-31","取得エラー後の公報取得に失敗するバグ修正"]
[null,"Ver 2.21","2022-08-10","日本特許の\"特許第abcdefg号\"に対応"]
[null,"Ver 2.30E","2023-03-14","Google Patentsで入手できなかった公報をEspacenetから入手 （Seleniumbasic使用）"]
[null,"Ver 2.40E","2023-05-02","公報番号変換処理のエラー修正、Espacenetからのダウンロード処理一部見直し"]
[null,"Ver 2.50E","2023-07-25","chromedriverの自動更新処理のアップデート"]
[null,"Ver 2.60E","2023-10-10","Espacenetのロボット操作判定の厳格化に対応、プロキシ環境への対応（非公式）"]
[null,"Ver 2.70E","2023-11-09","chromedriverの自動更新処理のバグ修正"]
[null,"Ver 2.80E","2024-03-19","chromedriverのダウンロードサイトURL変更に対応"]