{"id":20297,"date":"2019-06-18T08:10:41","date_gmt":"2019-06-17T23:10:41","guid":{"rendered":"https:\/\/agrimo.jp\/wp\/?page_id=20297"},"modified":"2019-06-20T18:56:01","modified_gmt":"2019-06-20T09:56:01","slug":"4-sgmlreader%e3%80%80%ef%bc%88web%e3%82%b9%e3%82%af%e3%83%ac%e3%82%a4%e3%83%94%e3%83%b3%e3%82%b0%e3%83%a9%e3%82%a4%e3%83%96%e3%83%a9%e3%83%aa%ef%bc%89","status":"publish","type":"page","link":"https:\/\/agrimo.jp\/wp\/?page_id=20297","title":{"rendered":"4.SgmlReader\u3000\uff08Web\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u30e9\u30a4\u30d6\u30e9\u30ea\uff09"},"content":{"rendered":"<p>Web\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u30e9\u30a4\u30d6\u30e9\u30ea\uff08SgmlReader\uff09\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p>\u30a2\u30b0\u30ea\u30e2\u306e\u88fd\u54c1\u3067\u306f\u3001\u65e5\u5831\u30c7\u30fc\u30bf\u81ea\u52d5\u53d6\u5f97\u30b7\u30b9\u30c6\u30e0\uff24\uff34\u3001\u691c\u7d22\u30c7\u30fc\u30bf\u81ea\u52d5\u53d6\u5f97\u30b7\u30b9\u30c6\u30e0\uff24\uff34\u3067\u3001Web\u306b\u8868\u793a\u3055\u308c\u305f\u5185\u5bb9\u3092CSV\u30c7\u30fc\u30bf\u3078\u5909\u63db\u3059\u308b\u904e\u7a0b\u3067\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u7528\u9014\u3068\u3057\u3066\u306f\u3001C#\u306eWebBrowser\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3067\u53d6\u5f97\u3055\u308c\u305fHTML\u3092XML\u306b\u30d1\u30fc\u30b9\u3059\u308b\u305f\u3081\u306b\u7528\u3044\u307e\u3059\u3002\u4f55\u6545\u305d\u306e\u3088\u3046\u306a\u3053\u3068\u304c\u5fc5\u8981\u304b\u3068\u3044\u3046\u3068\u3001HTML\u306f\u8a18\u8ff0\u30df\u30b9\u304c\u7d50\u69cb\u3042\u308b\u306e\u3067\u3001\u305d\u306e\u307e\u307eXML\u3068\u3057\u3066\u7528\u3044\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u305b\u3093\u3002\uff08\u30bf\u30b0\u304c\u3061\u3083\u3093\u3068\u9589\u3058\u3066\u3044\u306a\u304b\u3063\u305f\u308a\u3059\u308b\u306e\u3067\u3002\u3002\uff09\u305d\u306e\u305f\u3081\u306b SgmlReader\u306e\u3088\u3046\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u7528\u3044\u3066\u6b63\u78ba\u306aXML\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u306b\u306a\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n<p>XML\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3057\u305f\u5f8c\u306f\u3001LINQ to XML \u3092\u7528\u3044\u3066\u69cb\u6587\u89e3\u6790\u3092\u884c\u3044\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\uff11\uff0e\u65b0\u898f\u306b\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\"><a href=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-20512\" src=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19-300x160.png\" alt=\"\" width=\"300\" height=\"160\" srcset=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19-300x160.png 300w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19-1024x546.png 1024w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19-50x27.png 50w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19-820x437.png 820w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h25_19.png 1362w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\uff12\uff0e\u30d1\u30c3\u30b1\u30fc\u30b8\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u3001\u300cInstall-Package SgmlReader\u300d\u3068\u5165\u529b\u3057\u3066Enter\u30ad\u30fc\u3092\u62bc\u4e0b\u3057\u307e\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\"><a href=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-20513\" src=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50-300x159.png\" alt=\"\" width=\"300\" height=\"159\" srcset=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50-300x159.png 300w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50-1024x544.png 1024w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50-50x27.png 50w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50-820x436.png 820w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h26_50.png 1362w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\uff13\uff0e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u53c2\u7167\u306bDLL\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\"><a href=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-20514\" src=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24-300x160.png\" alt=\"\" width=\"300\" height=\"160\" srcset=\"https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24-300x160.png 300w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24-1024x545.png 1024w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24-50x27.png 50w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24-820x436.png 820w, https:\/\/agrimo.jp\/wp\/wp-content\/uploads\/2019\/06\/2019-06-20_17h27_24.png 1365w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u30b5\u30f3\u30d7\u30eb\u30bd\u30fc\u30b9<\/p>\n<pre class=\"lang:default decode:true  \" title=\"\u30b5\u30f3\u30d7\u30eb\u30bd\u30fc\u30b9\">WebBrowser browser = new WebBrowser();\r\n\r\nTextReader tr = new StringReader(browser.DocumentText);\r\n\r\n\/\/ setup SGMLReader\r\nSgml.SgmlReader sgmlReader = new Sgml.SgmlReader();\r\nsgmlReader.DocType = \"HTML\";\r\nsgmlReader.WhitespaceHandling = WhitespaceHandling.All;\r\nsgmlReader.CaseFolding = Sgml.CaseFolding.ToLower;\r\nsgmlReader.InputStream = tr;\r\n\r\n\/\/HTML\u3092XML\u306b\u5909\u63db\r\nxml = XDocument.Load(sgmlReader);\r\n\r\n\/\/XML\u306e\u540d\u524d\u7a7a\u9593\u3092\u30bb\u30c3\u30c8\r\nns = xml.Root.Name.Namespace;\r\n\r\n\/\/LINQ to XML\r\nvar query = xml\r\n    .Descendants(ns + \"table\")\r\n    .Where(e =&gt; e.Attribute(\"id\") != null &amp;&amp; e.Attribute(\"id\").Value == \"SearchResultList\")\r\n    .ElementAt(num)\r\n    .Descendants(ns + \"tr\")\r\n    .Where(e =&gt; e.Attribute(\"class\") != null &amp;&amp; (e.Attribute(\"class\").Value == \"reinsColor detail-height\"))\r\n    .SelectMany(e =&gt; e.Descendants(ns + \"th\"));\r\n\r\n\/\/\u4ef6\u6570\u30ab\u30a6\u30f3\u30c8\r\nvar qc = query.Count();\r\n\r\n\/\/ \u66f8\u304d\u51fa\u3057\r\nif (qc &gt; 0)\r\n{\r\n    var cnt = 0;\r\n    foreach (var item in query)\r\n    {\r\n        if (++cnt % qc != 0)\r\n        {\r\n            sr1.Write(\"\\\"\" + item.Value.Replace(\"\\r\\n\", \"\").Trim() + \"\\\",\");\r\n        }\r\n        else\r\n        {\r\n            sr1.WriteLine(\"\\\"\" + item.Value.Replace(\"\\r\\n\", \"\").Trim() + \"\\\"\");\r\n        }\r\n    }\r\n}\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Web\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u30e9\u30a4\u30d6\u30e9\u30ea\uff08SgmlReader\uff09\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u30a2\u30b0\u30ea\u30e2\u306e\u88fd\u54c1\u3067\u306f\u3001\u65e5\u5831\u30c7\u30fc [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-20297","page","type-page","status-publish","hentry"],"wppr_data":{"cwp_meta_box_check":"No"},"_links":{"self":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/20297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20297"}],"version-history":[{"count":16,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/20297\/revisions"}],"predecessor-version":[{"id":20527,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/20297\/revisions\/20527"}],"wp:attachment":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}