{"id":11875,"date":"2020-04-25T06:00:00","date_gmt":"2020-04-24T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=11875"},"modified":"2020-04-27T12:53:36","modified_gmt":"2020-04-27T03:53:36","slug":"%e5%8e%9a%e5%8a%b4%e7%9c%81%e3%80%8c%e5%9c%b0%e5%9f%9f%e3%81%94%e3%81%a8%e3%81%ae%e3%81%be%e3%82%93%e5%bb%b6%e3%81%ae%e7%8a%b6%e6%b3%81%e3%81%ab%e9%96%a2%e3%81%99%e3%82%8b%e6%8c%87%e6%a8%99%e7%ad%89","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=11875","title":{"rendered":"\u539a\u52b4\u7701\u300c\u5730\u57df\u3054\u3068\u306e\u307e\u3093\u5ef6\u306e\u72b6\u6cc1\u306b\u95a2\u3059\u308b\u6307\u6a19\u7b49\u300d\u306e PDF \u304b\u3089 Power BI Desktop \u3067\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057 EXCEL \u306e\u30b0\u30e9\u30d5\u306b\u8868\u73fe\u3059\u308b"},"content":{"rendered":"\n

\u3000\u65b0\u578b\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u306e\u30d1\u30f3\u30c7\u30df\u30c3\u30af\u5ba3\u8a00\u4ee5\u964d\uff0cTwitter \u3067\u30d5\u30a9\u30ed\u30fc\u3057\u3066\u3044\u308b\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u81ea\u7136\u3068\u76f8\u4e92\u5354\u8abf\u306e\u52d5\u304d\u304c\u307f\u3089\u308c\u308b\uff0e<\/p>\n

\u539a\u52b4\u7701\u304c\u300c\u5730\u57df\u3054\u3068\u306e\u307e\u3093\u5ef6\u306e\u72b6\u6cc1\u306b\u95a2\u3059\u308b\u6307\u6a19\u7b49\u300d\u306e\u516c\u8868\u3092\u958b\u59cb\u3002
\u90fd\u9053\u5e9c\u770c\u3054\u3068\u306e\u2460\u78ba\u5b9a\u60a3\u8005\u6570\u3001\u2461\u30ea\u30f3\u30af\u304c\u4e0d\u660e\u306a\u60a3\u8005\u6570\u3001\u2462\u76f8\u8ac7\u4ef6\u6570\u3001\u2463PCR\u691c\u67fb\u306e\u5b9f\u65bd\u6570…\u3068\u3001\u5fc5\u8981\u306a\u60c5\u5831\u3092\u4e00\u901a\u308a\u7db2\u7f85\u3057\u3066\u3044\u307e\u3059\u3002
\u304c\u3001\u30d5\u30a1\u30a4\u30eb\u306f\u307e\u3055\u304b\u306ePDF\u5f62\u5f0f\u3002Excel\u304bCSV\u3082\u63d0\u4f9b\u3057\u3066\u304f\u308c\u308c\u3070…https:\/\/t.co\/Ox5rU6m1Xo<\/a><\/p>— \u306b\u3083\u3093\u3053\u305d\u3070 (@ShinagawaJP) 2020\u5e744\u670823\u65e5<\/a><\/blockquote><\/div><\/p>\n

\u3000\u3053\u306e\u30c4\u30a4\u30fc\u30c8\u304b\u3089\u59cb\u307e\u3063\u305f\u4e00\u9023\u306e\u3084\u308a\u3068\u308a\u3067\uff0c\u539a\u52b4\u7701\u306e\u767a\u8868\u3057\u305f PDF \u304b\u3089\u30c6\u30fc\u30d6\u30eb\u3092\u62bd\u51fa\u3059\u308b\u304f\u3060\u308a\u306b\u6ce8\u76ee\u3057\u305f\uff0e<\/p>\n

\u5931\u793c\u3057\u307e\u3059\u3002\u4eca\u3001\u30de\u30af\u30ed\u30bd\u30d5\u30c8 Power BI \u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u3092\u4f7f\u7528\u3057\u305f\u3068\u3053\u308d\u7121\u4e8bPDF\u3092\u8aad\u307f\u8fbc\u3081\u307e\u3057\u305f\u3002\u307e\u305f\u3001\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3068\u3044\u3046\u6a5f\u80fd\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u30af\u30ed\u30b9\u96c6\u8a08\u8868\u3092\u6dfb\u4ed8\u306e\u3088\u3046\u306a\u96c6\u8a08\u7528\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u52a0\u5de5\u3067\u304d\u307e\u3059\u3002 pic.twitter.com\/FEV0SBSito<\/a><\/p>— Akira Takao (@modernexcel7) 2020\u5e744\u670823\u65e5<\/a><\/blockquote><\/div><\/p>\n

\u3000\u4eca\u56de\u306f\u3053\u3053\u3092\u753b\u50cf\u3064\u304d\u3067\u5b9f\u65bd\u3057\u3066\u307f\u305f\uff0e<\/p>\n

<\/p>\n

PDF \u3078\u306e\u63a5\u7d9a<\/h2>\n

\u3000\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306f\u5730\u57df\u3054\u3068\u306e\u307e\u3093\u5ef6\u306e\u72b6\u6cc1\u306b\u95a2\u3059\u308b\u6307\u6a19\u7b49\u306e\u516c\u8868\u306b\u3064\u3044\u3066<\/a>\u3067\u3042\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u540d\u306f 2020 \u5e74 4 \u6708 24 \u65e5\u6642\u70b9\u3067 000624135 \u3068\u306a\u3063\u3066\u3044\u308b\uff0e<\/p>\n

EXCEL \u306e Power Query \u3067\u306f PDF \u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044<\/h3>\n

\u3000PDF \u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u305f\u304f\u3066\u3082\uff0cEXCEL \u306e Power Query \u304b\u3089\u3067\u306f\u3067\u304d\u306a\u3044\uff0e\u305d\u306e\u305f\u3081 Power BI Desktop \u3092\u4f7f\u3046\u5fc5\u8981\u304c\u3042\u308b\uff0e<\/p>\n

\u3000Power BI Desktop \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u3064\u3044\u3066\u306f\u3053\u3061\u3089<\/a>\u3092\u53c2\u7167\u3055\u308c\u305f\u3044\uff0e<\/p>\n

Excel\u3060\u3068\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db\u3068\u3044\u3046\u30e1\u30cb\u30e5\u30fc\u304c\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u307e\u3060PDF\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u3088\u3046\u306a\u306e\u3067\u3001PowerBI\u304b\u3089\u4f5c\u308a\u307e\u3057\u305f\u3002

\u306b\u3083\u3093\u3053\u305d\u3070\u3055\u3093\u306e\u5206\u6790\u3092\u3044\u3064\u3082\u697d\u3057\u307f\u306b\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u304a\u5f79\u306b\u7acb\u3066\u308c\u3070\u5e78\u3044\u3067\u3059\uff01https:\/\/t.co\/DSAWDdKwXO<\/a><\/p>— Akira Takao (@modernexcel7) 2020\u5e744\u670823\u65e5<\/a><\/blockquote><\/div><\/p>\n

Power BI Desktop\u3092\u8d77\u52d5<\/h3>\n
\"Power<\/a>
Power BI Desktop\u8d77\u52d5\u753b\u9762<\/figcaption><\/figure>\n

\u300c\u30db\u30fc\u30e0\u300d\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u300c\u8a73\u7d30\u300d<\/h3>\n

\u3000\u30db\u30fc\u30e0\u30bf\u30d6\u306e\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u3092\u62bc\u4e0b\u3057\u6700\u4e0b\u90e8\u306e\u300c\u8a73\u7d30…\u300d\u3092\u9078\u3076\uff0e<\/p>\n

\"\u300c\u30db\u30fc\u30e0\u300d\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u300c\u8a73\u7d30\u300d\"<\/a>
\u300c\u30db\u30fc\u30e0\u300d\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u300c\u8a73\u7d30\u300d<\/figcaption><\/figure>\n

\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u300cPDF\u300d<\/h3>\n

\u3000\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u304b\u3089\u300cPDF\u300d\u3092\u9078\u3076\u3068\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u6307\u5b9a\u3059\u308b\u3088\u3046\u4fc3\u3055\u308c\u308b\uff0e\u6307\u5b9a\u3057\u3066 OK \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\"\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u300cPDF\u300d\"<\/a>
\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u300d\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u300cPDF\u300d<\/figcaption><\/figure>\n

Table001(Page 1)\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d<\/h3>\n

\u3000\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30ca\u30d3\u30b2\u30fc\u30bf\u30fc\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u958b\u304f\uff0e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u304c 2 \u3064\u3042\u308b\u306e\u3067 Table001(Page 1) \u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\uff0c\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\"Table001(Page<\/a>
Table001(Page 1)\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d<\/figcaption><\/figure>\n

Power Query \u306b\u3088\u308b\u52a0\u5de5<\/h2>\n

\u300c\u5909\u63db\u300d\u300c\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u7528\u300d<\/h3>\n

\u3000\u3053\u3053\u304b\u3089\u30c7\u30fc\u30bf\u306e\u6574\u5f62\u306b\u5165\u308b\uff0e\u4e3b\u306a\u4f5c\u696d\u306f\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3067\u3042\u308b\uff0e\u305d\u306e\u524d\u306b\u30d8\u30c3\u30c0\u30fc\u884c\u3092\u6307\u5b9a\u3059\u308b\uff0e\u300c\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u7528\u300d\u3092\u9078\u3076\uff0e<\/p>\n

\u00a0<\/div>\n
\"\u300c\u5909\u63db\u300d\u300c\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u7528\u300d\"<\/a>
\u300c\u5909\u63db\u300d\u300c\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u7528\u300d<\/figcaption><\/figure>\n

\u300c\u78ba\u5b9a\u65e5\u300d\u5217\u3092\u9078\u629e\u3057\u305f\u307e\u307e\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u300d<\/h3>\n

\u3000\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3059\u3079\u304d\u5217\u306e\u6570\u304c\u4e0d\u5b9a\u306e\u5834\u5408\u306b\u306f\uff0c\u89e3\u9664\u3057\u306a\u3044\u5217\u3092\u6307\u5b9a\u3057\u3066\u304a\u3044\u3066\u300c\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u300d\u3092\u4f7f\u3046\uff0e<\/p>\n

\"\u300c\u78ba\u5b9a\u65e5\u300d\u5217\u3092\u9078\u629e\u3057\u305f\u307e\u307e\u53f3\u30af\u30ea\u30c3\u30af-\u300c\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u300d\"<\/a>
\u300c\u78ba\u5b9a\u65e5\u300d\u5217\u3092\u9078\u629e\u3057\u305f\u307e\u307e\u53f3\u30af\u30ea\u30c3\u30af-\u300c\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u300d<\/figcaption><\/figure>\n

\u3000\u7d50\u679c\u306f\u3053\u3046\u306a\u308b\uff0e\u300c\u5c5e\u6027\u300d\u300c\u5024\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u5217\u304c\u3067\u304d\u308b\uff0e\u300c\u5c5e\u6027\u300d\u5217\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\u306b\u300c\u524d\u65e5\u3068\u306e\u5dee\u300d\u3068\u3044\u3046\u5024\u304c\u898b\u3048\u308b\uff0e\u4eca\u56de\uff0c\u3053\u308c\u306f\u30b0\u30e9\u30d5\u5316\u306e\u90aa\u9b54\u306b\u306a\u308b\u306e\u3067\u524a\u9664\u3057\u305f\u3044\uff0e<\/p>\n

\"\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u5f8c\u300c\u5c5e\u6027\u300d\u300c\u5024\u300d\u3068\u3044\u3046\u5217\u304c\u3067\u304d\u308b\"<\/a>
\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u5f8c\u300c\u5c5e\u6027\u300d\u300c\u5024\u300d\u3068\u3044\u3046\u5217\u304c\u3067\u304d\u308b<\/figcaption><\/figure>\n

\u300c\u5c5e\u6027\u300d\u5217\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u25bc\u3092\u30af\u30ea\u30c3\u30af\u3057\u300c\u30c6\u30ad\u30b9\u30c8 \u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u300c\u6307\u5b9a\u306e\u5024\u3092\u542b\u307e\u306a\u3044\u300d<\/h3>\n

\u3000\u305d\u3053\u3067\u5217\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u4f7f\u3063\u3066\u9664\u5916\u3059\u308b\uff0e\u300c\u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u306e\u3046\u3061\u300c\u6307\u5b9a\u306e\u5024\u3092\u542b\u307e\u306a\u3044\u300d\u3067\u3042\u308b\uff0e<\/p>\n

\"\u300c\u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u3067\u300c\u6307\u5b9a\u306e\u5024\u3092\u542b\u307e\u306a\u3044\u300d\"<\/a>
\u300c\u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u3067\u300c\u6307\u5b9a\u306e\u5024\u3092\u542b\u307e\u306a\u3044\u300d<\/figcaption><\/figure>\n

\u300c\u524d\u65e5\u3068\u306e\u5dee\u300d\u3068\u30bf\u30a4\u30d7\u5165\u529b\u3057\u300cOK\u300d<\/h3>\n

\u3000\u300c\u884c\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u958b\u304f\u306e\u3067\u300e\u524d\u65e5\u3068\u306e\u5dee\u300f\u3068\u30ad\u30fc\u30dc\u30fc\u30c9\u304b\u3089\u30bf\u30a4\u30d7\u5165\u529b\u3057\uff0cOK \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\"\u300c\u884c\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u306b\u300e\u524d\u65e5\u3068\u306e\u5dee\u300f\u3068\u30bf\u30a4\u30d7\u5165\u529b\"<\/a>
\u300c\u884c\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u306b\u300e\u524d\u65e5\u3068\u306e\u5dee\u300f\u3068\u30bf\u30a4\u30d7\u5165\u529b<\/figcaption><\/figure>\n

\u3000\u7d50\u679c\u306f\u3053\u3046\u306a\u308b\uff0e<\/p>\n

\"\u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\u30fc\u306e\u7d50\u679c\"<\/a>
\u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\u30fc\u306e\u7d50\u679c<\/figcaption><\/figure>\n

\u300c\u30db\u30fc\u30e0\u300d\u300c\u9589\u3058\u3066\u9069\u7528\u300d<\/h3>\n

\u3000\u300c\u9589\u3058\u3066\u9069\u7528\u300d\u3059\u308b\uff0e<\/p>\n

\"\u300c\u9589\u3058\u3066\u9069\u7528\u300d\"<\/a>
\u300c\u9589\u3058\u3066\u9069\u7528\u300d<\/figcaption><\/figure>\n

\u30af\u30a8\u30ea\u306e\u8a73\u7d30<\/h3>\n

\u3000\u4e0a\u8a18\u64cd\u4f5c\u306e\u8a18\u9332\u3092\u8a18\u8ff0\u3057\u305f\u30af\u30a8\u30ea\u3067\u3042\u308b\uff0e<\/p>\n

let\n    \u30bd\u30fc\u30b9 = Pdf.Tables(File.Contents(\"C:\\Users\\UserName\\Dropbox\\20200424COVID19\\000624135.pdf\")),\n    Table001 = \u30bd\u30fc\u30b9{[Id=\"Table001\"]}[Data],\n    \u6607\u683c\u3055\u308c\u305f\u30d8\u30c3\u30c0\u30fc\u6570 = Table.PromoteHeaders(Table001, [PromoteAllScalars=true]),\n    \u5909\u66f4\u3055\u308c\u305f\u578b = Table.TransformColumnTypes(\u6607\u683c\u3055\u308c\u305f\u30d8\u30c3\u30c0\u30fc\u6570,{{\"\u78ba\u5b9a\u65e5\", type text}, {\"4\u670811\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee\", Int64.Type}, {\"4\u670812\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_1\", type text}, {\"4\u670813\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_2\", Int64.Type}, {\"4\u670814\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_3\", Int64.Type}, {\"4\u670815\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_4\", Int64.Type}, {\"4\u670816\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_5\", type text}, {\"4\u670817\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_6\", Int64.Type}, {\"4\u670818\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_7\", type text}, {\"4\u670819\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_8\", Int64.Type}, {\"4\u670820\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_9\", Int64.Type}, {\"4\u670821\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_10\", Int64.Type}}),\n    \u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3055\u308c\u305f\u4ed6\u306e\u5217 = Table.UnpivotOtherColumns(\u5909\u66f4\u3055\u308c\u305f\u578b, {\"\u78ba\u5b9a\u65e5\"}, \"\u5c5e\u6027\", \"\u5024\"),\n    \u30d5\u30a3\u30eb\u30bf\u30fc\u3055\u308c\u305f\u884c = Table.SelectRows(\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3055\u308c\u305f\u4ed6\u306e\u5217, each not Text.Contains([\u5c5e\u6027], \"\u524d\u65e5\u3068\u306e\u5dee\"))\nin\n    \u30d5\u30a3\u30eb\u30bf\u30fc\u3055\u308c\u305f\u884c<\/pre>\n
Excel \u3067\u306e\u4f5c\u696d<\/h2>\n
\u5de6\u5074\u306e\u4e09\u3064\u306e\u30a2\u30a4\u30b3\u30f3\u306e\u3046\u3061\u771f\u3093\u4e2d\u306e\u8868\u3092\u30af\u30ea\u30c3\u30af<\/h3>\n
\u3000\u30a6\u30a3\u30f3\u30c9\u30a6\u5de6\u5074\u306b\u3042\u308b\u30a2\u30a4\u30b3\u30f3\u306f\u4e0a\u304b\u3089\u9806\u306b\u30ec\u30dd\u30fc\u30c8\uff0c\u30c7\u30fc\u30bf\uff0c\u30e2\u30c7\u30eb\u3068\u3044\u3046\uff0e\u30a2\u30a4\u30b3\u30f3\u306e\u5f62\u72b6\u304b\u3089\u60f3\u50cf\u3067\u304d\u308b\u304c\uff0c\u305d\u308c\u305e\u308c\u30c7\u30fc\u30bf\u306e\u69cb\u9020\u3092\u8c61\u5fb4\u3057\u3066\u3044\u308b\uff0e\u30ec\u30dd\u30fc\u30c8\u306f EXCEL \u3067\u306f\u30b0\u30e9\u30d5\u306b\u8a72\u5f53\u3059\u308b\u304c\uff0c\u8868\u73fe\u529b\u306f\u6b63\u76f4 Power BI \u306e\u65b9\u304c\u4e0a\u3067\u3042\u308b\uff0e<\/p>\n
\u3000\u4eca\u56de\u306f EXCEL \u3078\u306e\u30c7\u30fc\u30bf\u79fb\u884c\u3092\u76ee\u7684\u3068\u3059\u308b\u305f\u3081\uff0c\u771f\u3093\u4e2d\u306e\u30c7\u30fc\u30bf\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\uff0c\u30c6\u30fc\u30d6\u30eb\u3092\u8868\u793a\u3059\u308b\uff0e<\/p>\n
\"\u5de6\u5074\u306e\u4e09\u3064\u306e\u30a2\u30a4\u30b3\u30f3\u306e\u3046\u3061\u771f\u3093\u4e2d\u306e\u8868\u3092\u30af\u30ea\u30c3\u30af\"<\/a>
\u5de6\u5074\u306e\u4e09\u3064\u306e\u30a2\u30a4\u30b3\u30f3\u306e\u3046\u3061\u771f\u3093\u4e2d\u306e\u8868\u3092\u30af\u30ea\u30c3\u30af<\/figcaption><\/figure>\n
\u53f3\u5074\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u4e2d\u306e\u300eTable001 (Page1 )\u300f\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u30c6\u30fc\u30d6\u30eb\u306e\u30b3\u30d4\u30fc\u300d<\/h3>\n
\u3000\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u3082\uff0c\u53f3\u5074\u306e\u7e26 3 \u3064\u306e\u70b9\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3082\u540c\u3058\u30e1\u30cb\u30e5\u30fc\u304c\u51fa\u73fe\u3059\u308b\u304c\uff0c\u300c\u30c6\u30fc\u30d6\u30eb\u306e\u30b3\u30d4\u30fc\u300d\u3092\u9078\u3076\uff0e\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u306b\u30c7\u30fc\u30bf\u304c\u30b3\u30d4\u30fc\u3055\u308c\u308b\uff0e<\/p>\n
\"\u53f3\u5074\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u4e2d\u306e\u300cTable001<\/a>
\u53f3\u5074\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u4e2d\u306e\u300cTable001 (Page1 )\u300d\u3092\u53f3\u30af\u30ea\u30c3\u30af<\/figcaption><\/figure>\n
Excel \u3078\u8cbc\u308a\u4ed8\u3051<\/h3>\n
\u3000EXCEL \u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u8cbc\u308a\u4ed8\u3051\uff0c\u30c6\u30fc\u30d6\u30eb\u306b\u5909\u63db\u3059\u308b\uff0e\u78ba\u5b9a\u65e5\u304c\u6708\u3068\u65e5\u3057\u304b\u306a\u3044\u305f\u3081\uff0c\u53f3\u96a3\u306e\u30bb\u30eb\u306b<\/p>\n
=\"2020\u5e74\"&[\u78ba\u5b9a\u65e5]<\/pre>\n
\u3068\u30bf\u30a4\u30d7\u3057\uff0c\u3055\u3089\u306b\u53f3\u96a3\u306e\u30bb\u30eb\u306b DATEVALUE \u95a2\u6570\u3092\u9069\u7528\u3057\u3066\u78ba\u5b9f\u306b\u5e74\u6708\u65e5\u3068\u3057\u3066\u78ba\u5b9a\u3059\u308b\uff0e<\/p>\n
\u3000\u4eba\u6570\u304c\u6587\u5b57\u5217\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f<\/p>\n
=[\u5024]*1<\/pre>\n
\u306a\u3069\u3068\u6570\u5f0f\u3092\u4f7f\u3063\u3066\u6570\u5024\u3068\u8a8d\u8b58\u3055\u305b\u308b\uff0e\u5171\u306b\u300c\u5024\u306e\u307f\u8cbc\u308a\u4ed8\u3051\u300d\u3057\u3066\u30bb\u30eb\u306e\u53c2\u7167\u95a2\u4fc2\u3092\u89e3\u6d88\u3057\u3066\u304a\u304f\uff0e<\/p>\n
\u6298\u308c\u7dda\u30b0\u30e9\u30d5\u306e\u8ffd\u52a0<\/h3>\n
\u3000\u65b0\u898f\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3092\u8ffd\u52a0\u3057\uff0c\u7a7a\u767d\u306e\u6298\u308c\u7dda\u30b0\u30e9\u30d5\u3092\u8ffd\u52a0\u4f5c\u6210\u3059\u308b\uff0e<\/p>\n
\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8ffd\u52a0<\/h3>\n
\u3000\u30b0\u30e9\u30d5\u5185\u90e8\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30c7\u30fc\u30bf\u306e\u9078\u629e…\u300d\u3092\u9078\u3073\uff0c\u7cfb\u5217\u3092 47 \u500b\u8ffd\u52a0\u3057\u3066\uff0c\u30c6\u30fc\u30d6\u30eb\u306e\u5404\u90fd\u9053\u5e9c\u770c\u540d\u3092\u300c\u7cfb\u5217\u540d\u300d\u306b\u6307\u5b9a\u3057\uff0c\u78ba\u5b9a\u60a3\u8005\u6570\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u300c\u5024\u300d\u306b\u6307\u5b9a\u3059\u308b\uff0e\u6a2a\u8ef8\u30e9\u30d9\u30eb\u306e\u300c\u7de8\u96c6\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\uff0c\u5168\u56fd\u306e\u300c\u78ba\u5b9a\u65e5\u300d\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n
\"\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8ffd\u52a0\"<\/a>
\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8ffd\u52a0<\/figcaption><\/figure>\n
\u3000\u7e26\u8ef8\u306e\u66f8\u5f0f\u306f\u521d\u671f\u306e\u300c\u7dda\u5f62\u300d\u306e\u307e\u307e\u3067\u306f\u306a\u304f\uff0c\u300c\u5bfe\u6570\u300d\u306b\u3057\u3066\u304a\u304f\uff0e\u3053\u308c\u306b\u306f\u75ab\u5b66\u7684\u7406\u7531\u304c\u3042\u308b\u304c\uff0c\u8a73\u7d30\u306b\u306f\u8e0f\u307f\u8fbc\u307e\u306a\u3044\u3067\u304a\u304f\uff0e<\/p>\n
\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u30b3\u30fc\u30c9<\/h3>\n
\u3000\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u6a19\u6e96\u30e2\u30b8\u30e5\u30fc\u30eb\u306b\u8a18\u8ff0\u3057\uff0cF5 \u3092\u62bc\u4e0b\u3057\u3066\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n
Sub ChartFormat()\nDim mySht1      As Worksheet\nDim myCht       As Chart\nDim mySeries    As Series\nDim myPoint     As Point\nDim myLine      As LineFormat\nDim myAxis      As Axis\n\nSet mySht1 = Worksheets(\"Sheet2\")\nSet myCht = mySht1.ChartObjects(1).Chart\n\nWith myCht\n    For Each mySeries In .SeriesCollection\n        For Each myPoint In mySeries.Points\n            myPoint.Format.Fill.ForeColor.RGB = RGB(255, 255, 255)\n        Next myPoint\n        Set myLine = mySeries.Format.Line\n        With myLine\n            .ForeColor.RGB = RGB(255, 255, 255)\n            .Weight = 0.25\n        End With\n    Next mySeries\n    With .ChartArea\n        .Format.Line.Visible = msoFalse\n        .Format.Fill.ForeColor.ObjectThemeColor = msoThemeColorAccent1\n        .Format.TextFrame2.TextRange.Font.Name = \"TimesNewRoman\"\n        .Format.TextFrame2.TextRange.Font.Fill.ForeColor.RGB = RGB(255, 255, 255)\n    End With\n    Set myAxis = .Axes(xlCategory)\n    With myAxis\n        .Format.Line.Visible = msoFalse\n        .MajorGridlines.Format.Line.Visible = msoFalse\n    End With\n    Set myAxis = .Axes(xlValue)\n    With myAxis\n        .Format.Line.Visible = msoFalse\n        .MajorGridlines.Format.Line.Visible = msoFalse\n    End With\nEnd With\nEnd Sub<\/pre>\n
\u7d50\u679c<\/h2>\n
\u65b0\u578b\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u78ba\u5b9a\u60a3\u8005\u6570\u306e\u63a8\u79fb<\/h3>\n
\u3000\u7d50\u679c\u3092\u793a\u3059\uff0e\u7b46\u8005\u306f\u75ab\u5b66\u304c\u5c02\u9580\u3067\u306f\u306a\u3044\u305f\u3081\uff0c\u8003\u5bdf\u306b\u306f\u8e0f\u307f\u8fbc\u307e\u305a\uff0c\u5c02\u9580\u5bb6\u306b\u59d4\u306d\u308b\uff0e<\/p>\n
\"\u5404\u90fd\u9053\u5e9c\u770c\u306e\u65b0\u578b\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u78ba\u5b9a\u60a3\u8005\u6570\u306e\u63a8\u79fb\"<\/a>
\u5404\u90fd\u9053\u5e9c\u770c\u306e\u65b0\u578b\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u78ba\u5b9a\u60a3\u8005\u6570\u306e\u63a8\u79fb<\/figcaption><\/figure>\n
\u307e\u3068\u3081<\/h2>\n
\u3000\u539a\u52b4\u7701\u306e\u516c\u958b\u3057\u305f PDF \u30d5\u30a1\u30a4\u30eb\u3092\u5143\u306b\u5404\u90fd\u9053\u5e9c\u770c\u306e\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u78ba\u5b9a\u60a3\u8005\u6570\u306e\u63a8\u79fb\u3092\u6298\u308c\u7dda\u30b0\u30e9\u30d5\u306b\u8868\u73fe\u3057\u305f\uff0e<\/p>\n
\u3000PDF \u30d5\u30a1\u30a4\u30eb\u304b\u3089\u306e\u30c7\u30fc\u30bf\u62bd\u51fa\u306b\u306f EXCEL \u306e Power Query \u306f\u672a\u5bfe\u5fdc\u3067\uff0cPower BI Desktop \u304c\u5fc5\u8981\u3067\u3042\u3063\u305f\uff0e\u539a\u52b4\u7701\u306b\u306f csv \u30d5\u30a1\u30a4\u30eb\u307e\u305f\u306f EXCEL \u3067\u30d5\u30a1\u30a4\u30eb\u5f62\u5f0f\u3067\u306e\u30c7\u30fc\u30bf\u516c\u958b\u3092\u6c42\u3081\u305f\u3044\uff0e<\/p>\n
\u3000\u65b9\u6cd5\u306f\u3059\u3067\u306b Akira Takao (@modernexcel7) \u3055\u3093\u304c\u516c\u958b\u3057\u3066\u304f\u308c\u3066\u3044\u308b\uff0e\u7b46\u8005\u306f\u305d\u306e\u65b9\u6cd5\u3092\u753b\u50cf\u3064\u304d\u3067\u89e3\u8aac\u3057\u305f\uff0e<\/p>\n
\u8ffd\u52a0\u60c5\u5831\uff1a\u7a7a\u306e\u30af\u30a8\u30ea<\/h2>\n
\u3000\u3055\u3089\u306b Akira Takao \u3055\u3093\u304b\u3089\u8ffd\u52a0\u60c5\u5831\u304c\u5bc4\u305b\u3089\u308c\u305f\u306e\u3067\u7d39\u4ecb\u3057\u3066\u304a\u304f\uff0e<\/p>\n
Excel\u306ePower Query\u304b\u3089\u76f4\u3067PDF\u306e\u53d6\u308a\u8fbc\u307f\u304c\u3067\u304d\u307e\u3057\u305f\uff01GUI\u306b\u306f\u306a\u3044\u3051\u3069\u3001\u7a7a\u306e\u30af\u30a8\u30ea\u3067\u6253\u3061\u8fbc\u3081\u3070\u3088\u304b\u3063\u305f\u3093\u3067\u3059\u306d\u3002\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3057\u305f\uff01

= Pdf.Tables(File.Contents("C:\\\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\\PDF\u6587\u66f8.pdf")) https:\/\/t.co\/7JvDEyBl3g<\/a><\/p>— Akira Takao (@modernexcel7) 2020\u5e744\u670824\u65e5<\/a><\/blockquote><\/div><\/p>\n
\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u300c\u305d\u306e\u4ed6\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304b\u3089\u300d\u300c\u7a7a\u306e\u30af\u30a8\u30ea\u300d<\/h3>\n
\"\u7a7a\u306e\u30af\u30a8\u30ea\"<\/a>
\u7a7a\u306e\u30af\u30a8\u30ea<\/figcaption><\/figure>\n
\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u306e\u6307\u5b9a<\/h3>\n
\u3000\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u6307\u5b9a\u3059\u308b\u3088\u3046\u4fc3\u3055\u308c\u308b\u306e\u3067\u5165\u529b\u3059\u308b\uff0e<\/p>\n
\"\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u306e\u6307\u5b9a\"<\/a>
\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u306e\u6307\u5b9a<\/figcaption><\/figure>\n
\u3000\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u304c\u6b63\u3057\u3051\u308c\u3070\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30a4\u30b3\u30f3\u304c\u793a\u3055\u308c\u308b\uff0e<\/p>\n
\"\u6b63\u3057\u3044\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u6307\u5b9a\u3057\u305f\u7d50\u679c\"<\/a>
\u6b63\u3057\u3044\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u6307\u5b9a\u3057\u305f\u7d50\u679c<\/figcaption><\/figure>\n
\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u958b\u304f<\/h3>\n
\u3000\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u958b\u304f\u3068\u898b\u6163\u308c\u305f Power Query \u753b\u9762\u3078\u3068\u9077\u79fb\u3059\u308b\uff0e<\/p>\n
\"\u30d5\u30a1\u30a4\u30eb\u30a2\u30a4\u30b3\u30f3\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u958b\u304f\"<\/a>
\u30d5\u30a1\u30a4\u30eb\u30a2\u30a4\u30b3\u30f3\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u958b\u304f<\/figcaption><\/figure>\n
\u8aad\u307f\u8fbc\u307e\u308c\u308b\u30ec\u30b3\u30fc\u30c9<\/h3>\n
\u3000\u8aad\u307f\u8fbc\u307e\u308c\u305f\u306e\u306f 2 \u884c\u306e\u307f\u3060\u304c\uff0cId \u5217\u3092\u3088\u304f\u898b\u308b\u3068 Page001 \u304a\u3088\u3073 Table001 \u3068\u3042\u308b\uff0e\u3053\u3053\u3067\u5fc5\u8981\u306a\u306e\u306f\u30c6\u30fc\u30d6\u30eb\u306e\u65b9\u3067\u3042\u308b\uff0e<\/p>\n
\"2\u884c\u304c\u8aad\u307f\u8fbc\u307e\u308c\u308b\"<\/a>
2\u884c\u304c\u8aad\u307f\u8fbc\u307e\u308c\u308b<\/figcaption><\/figure>\n
\u4e0a\u4f4d1\u884c\u3092\u524a\u9664<\/h3>\n
\u3000\u300c\u4e0a\u4f4d\u306e\u884c\u306e\u524a\u9664\u300d\u3067 Page001 \u3092\u524a\u9664\u3057\u3066\u3044\u304f\uff0e<\/p>\n
\"\u4e0a\u4f4d\u306e\u884c\u306e\u524a\u9664\"<\/a>
\u4e0a\u4f4d\u306e\u884c\u306e\u524a\u9664<\/figcaption><\/figure>\n
\"\u5148\u982d\u304b\u3089\u524a\u9664\u3059\u308b\u884c\u6570\u3092\u6307\u5b9a\"<\/a>
\u5148\u982d\u304b\u3089\u524a\u9664\u3059\u308b\u884c\u6570\u3092\u6307\u5b9a<\/figcaption><\/figure>\n
\u3000\u7d50\u679c\u3068\u3057\u3066 Table001 \u306e\u884c\u304c\u6b8b\u308b\uff0e<\/p>\n
\"2\u884c\u76ee\u3060\u3051\u304c\u6b8b\u308b\"<\/a>
2\u884c\u76ee\u3060\u3051\u304c\u6b8b\u308b<\/figcaption><\/figure>\n
Data \u5217\u3092\u5c55\u958b\u3059\u308b<\/h3>\n
\u3000Data \u3068\u3044\u3046\u540d\u524d\u306e\u5217\u304c\u5c55\u958b\u3067\u304d\u305d\u3046\u306a\u306e\u3067\uff0c\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u307f\u308b\uff0e<\/p>\n
\"\u5c55\u958b\u3059\u308b\u5217\u304c\u30c1\u30a7\u30c3\u30af\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3053\u306e\u307e\u307eOK\"<\/a>
\u5c55\u958b\u3059\u308b\u5217\u304c\u30c1\u30a7\u30c3\u30af\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3053\u306e\u307e\u307eOK<\/figcaption><\/figure>\n
\u3000\u5c55\u958b\u3055\u308c\u305f\u7d50\u679c\u3067\u3042\u308b\uff0e\u3053\u3053\u304b\u3089\u306f\u5b9a\u578b\u7684\u306a\u4f5c\u696d\u306b\u306a\u3063\u3066\u304f\u308b\uff0e<\/p>\n
\"\u5c55\u958b\u3055\u308c\u305f\u72b6\u614b\uff0e\u3053\u3053\u304b\u3089\u52a0\u5de5\u3057\u3066\u3044\u304f\"<\/a>
\u5c55\u958b\u3055\u308c\u305f\u72b6\u614b\uff0e\u3053\u3053\u304b\u3089\u52a0\u5de5\u3057\u3066\u3044\u304f<\/figcaption><\/figure>\n
\u30c7\u30fc\u30bf\u306e\u52a0\u5de5<\/h3>\n
\u3000ID, Name, Kind \u306e3\u5217\u306f\u4e0d\u8981\u306a\u306e\u3067\u524a\u9664\u3059\u308b\uff0e<\/p>\n
\"\u4e0d\u8981\u5217\u3092\u524a\u9664\"<\/a>
\u4e0d\u8981\u5217\u3092\u524a\u9664<\/figcaption><\/figure>\n
\u3000\u300c\u524d\u65e5\u3068\u306e\u5dee\u300d\u3068\u3044\u3046\u5217\u3082\u4e0d\u8981\u306a\u306e\u3067\u524a\u9664\u3059\u308b\uff0e<\/p>\n
\"\u4e0d\u8981\u5217\u306e\u524a\u9664\"<\/a>
\u4e0d\u8981\u5217\u306e\u524a\u9664<\/figcaption><\/figure>\n
\u3000\u3053\u306e\u3042\u305f\u308a\u307e\u3067\u6765\u308b\u3068\u898b\u6163\u308c\u305f\u753b\u9762\u306b\u306a\u3063\u3066\u304f\u308b\uff0e\u300c\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u300d\u3092\u884c\u3046\uff0e<\/p>\n
\"\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\"<\/a>
\u305d\u306e\u4ed6\u306e\u5217\u306e\u30d4\u30dc\u30c3\u30c8\u89e3\u9664<\/figcaption><\/figure>\n
\u3000\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u5f8c\u306e\u72b6\u614b\u3060\u304c\uff0c\u5217\u540d\u304c\u304a\u304b\u3057\u3044\u306e\u3067\u4fee\u6b63\u3057\u3066\u304a\u304f\uff0e<\/p>\n
\"\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u76f4\u5f8c\uff0e\u5217\u540d\u304c\u5909\u3060\"<\/a>
\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u76f4\u5f8c\uff0e\u5217\u540d\u304c\u5909\u3060<\/figcaption><\/figure>\n
\u3000\u6700\u5f8c\u306b\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u3068\u7d50\u679c\u306f\u3053\u3046\u306a\u308b\uff0e<\/p>\n
\"\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\"<\/a>
\u30af\u30a8\u30ea\u3068\u63a5\u7d9a<\/figcaption><\/figure>\n
\u8a73\u7d30\u30af\u30a8\u30ea<\/h3>\n
let\n    \u30bd\u30fc\u30b9 = Pdf.Tables(File.Contents(\"C:\\Users\\UserName\\Dropbox\\20200424COVID19\\000624135.pdf\")),\n    \u524a\u9664\u3055\u308c\u305f\u6700\u521d\u306e\u884c = Table.Skip(\u30bd\u30fc\u30b9,1),\n    #\"\u5c55\u958b\u3055\u308c\u305f Data\" = Table.ExpandTableColumn(\u524a\u9664\u3055\u308c\u305f\u6700\u521d\u306e\u884c, \"Data\", {\"Column1\", \"Column2\", \"Column3\", \"Column4\", \"Column5\", \"Column6\", \"Column7\", \"Column8\", \"Column9\", \"Column10\", \"Column11\", \"Column12\", \"Column13\", \"Column14\", \"Column15\", \"Column16\", \"Column17\", \"Column18\", \"Column19\", \"Column20\", \"Column21\", \"Column22\", \"Column23\"}, {\"Data.Column1\", \"Data.Column2\", \"Data.Column3\", \"Data.Column4\", \"Data.Column5\", \"Data.Column6\", \"Data.Column7\", \"Data.Column8\", \"Data.Column9\", \"Data.Column10\", \"Data.Column11\", \"Data.Column12\", \"Data.Column13\", \"Data.Column14\", \"Data.Column15\", \"Data.Column16\", \"Data.Column17\", \"Data.Column18\", \"Data.Column19\", \"Data.Column20\", \"Data.Column21\", \"Data.Column22\", \"Data.Column23\"}),\n    \u524a\u9664\u3055\u308c\u305f\u5217 = Table.RemoveColumns(#\"\u5c55\u958b\u3055\u308c\u305f Data\",{\"Id\", \"Name\", \"Kind\"}),\n    \u6607\u683c\u3055\u308c\u305f\u30d8\u30c3\u30c0\u30fc\u6570 = Table.PromoteHeaders(\u524a\u9664\u3055\u308c\u305f\u5217, [PromoteAllScalars=true]),\n    \u5909\u66f4\u3055\u308c\u305f\u578b = Table.TransformColumnTypes(\u6607\u683c\u3055\u308c\u305f\u30d8\u30c3\u30c0\u30fc\u6570,{{\"\u78ba\u5b9a\u65e5\", type text}, {\"4\u670811\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee\", Int64.Type}, {\"4\u670812\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_1\", type text}, {\"4\u670813\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_2\", Int64.Type}, {\"4\u670814\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_3\", Int64.Type}, {\"4\u670815\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_4\", Int64.Type}, {\"4\u670816\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_5\", type text}, {\"4\u670817\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_6\", Int64.Type}, {\"4\u670818\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_7\", type text}, {\"4\u670819\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_8\", Int64.Type}, {\"4\u670820\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_9\", Int64.Type}, {\"4\u670821\u65e5\", Int64.Type}, {\"\u524d\u65e5\u3068\u306e\u5dee_10\", Int64.Type}}),\n    \u524a\u9664\u3055\u308c\u305f\u52171 = Table.RemoveColumns(\u5909\u66f4\u3055\u308c\u305f\u578b,{\"\u524d\u65e5\u3068\u306e\u5dee\", \"\u524d\u65e5\u3068\u306e\u5dee_1\", \"\u524d\u65e5\u3068\u306e\u5dee_2\", \"\u524d\u65e5\u3068\u306e\u5dee_3\", \"\u524d\u65e5\u3068\u306e\u5dee_4\", \"\u524d\u65e5\u3068\u306e\u5dee_5\", \"\u524d\u65e5\u3068\u306e\u5dee_6\", \"\u524d\u65e5\u3068\u306e\u5dee_7\", \"\u524d\u65e5\u3068\u306e\u5dee_8\", \"\u524d\u65e5\u3068\u306e\u5dee_9\", \"\u524d\u65e5\u3068\u306e\u5dee_10\"}),\n    \u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3055\u308c\u305f\u4ed6\u306e\u5217 = Table.UnpivotOtherColumns(\u524a\u9664\u3055\u308c\u305f\u52171, {\"\u78ba\u5b9a\u65e5\"}, \"\u5c5e\u6027\", \"\u5024\"),\n    #\"\u540d\u524d\u304c\u5909\u66f4\u3055\u308c\u305f\u5217 \" = Table.RenameColumns(\u30d4\u30dc\u30c3\u30c8\u89e3\u9664\u3055\u308c\u305f\u4ed6\u306e\u5217,{{\"\u78ba\u5b9a\u65e5\", \"\u90fd\u9053\u5e9c\u770c\"}, {\"\u5c5e\u6027\", \"\u78ba\u5b9a\u65e5\"}, {\"\u5024\", \"\u78ba\u5b9a\u60a3\u8005\u6570\"}})\nin\n    #\"\u540d\u524d\u304c\u5909\u66f4\u3055\u308c\u305f\u5217 \"<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u3000\u65b0\u578b\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u306e\u30d1\u30f3\u30c7\u30df\u30c3\u30af\u5ba3\u8a00\u4ee5\u964d\uff0cTwitter \u3067\u30d5\u30a9\u30ed\u30fc\u3057\u3066\u3044\u308b\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u81ea\u7136\u3068\u76f8\u4e92\u5354\u8abf\u306e\u52d5\u304d\u304c\u307f\u3089\u308c\u308b\uff0e \u539a\u52b4\u7701\u304c\u300c\u5730\u57df\u3054\u3068\u306e\u307e\u3093\u5ef6\u306e\u72b6\u6cc1\u306b\u95a2\u3059\u308b\u6307\u6a19\u7b49\u300d\u306e\u516c\u8868\u3092\u958b\u59cb\u3002\u90fd\u9053\u5e9c\u770c\u3054\u3068\u306e\u2460\u78ba\u5b9a\u60a3\u8005\u6570\u3001\u2461\u30ea\u30f3 … <\/p>\n
“\u539a\u52b4\u7701\u300c\u5730\u57df\u3054\u3068\u306e\u307e\u3093\u5ef6\u306e\u72b6\u6cc1\u306b\u95a2\u3059\u308b\u6307\u6a19\u7b49\u300d\u306e PDF \u304b\u3089 Power BI Desktop \u3067\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057 EXCEL \u306e\u30b0\u30e9\u30d5\u306b\u8868\u73fe\u3059\u308b” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":11922,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[5053,8065,8063,8064,4998,4525,5004,4524,8070,2656,3896,8083,265,5412,8071,4992,4991,4892,4883,2775,8068,8060,5631,4905,4528,4899,8044,360,8069,4569,4548,4018,4290,4067,5297,8080,5543,8082,4561,4585,8074,8077,8076,8073,8078,8079,4989,4990,5656,5298,694,8081,5685,4894,4523,8048,8040,8055,3942,2783,4383,1013,5667,437,8051,462,8058,646,5276,4162,4292,1026,4516,4381,7925,5247,2911,4825,5357,8045,1291,4818,663,5356,8049,3553,3901,8072,8050,8039,4393,5178,2764,4354,8067,5529,5432,1794,8052,1027,1022,5431,2497,4940,5258,7924,2781,5063,8041,8059,8043,8042,8047,8066,4402,3442,3654,5064,8053,8057,3915,8056,4439,8054,8046],"class_list":["post-11875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-5053","tag-akira-takao","tag-axesxlcategory","tag-axesxlvalue","tag-axis","tag-chart","tag-chartarea","tag-chartobjects","tag-contents","tag-csv","tag-datevalue","tag-each-not-text-contains","tag-excel","tag-expandtablecolumn","tag-file","tag-fill","tag-font","tag-forecolor","tag-format","tag-id","tag-kind","tag-lineformat","tag-msofalse","tag-msothemecoloraccent1","tag-name","tag-objectthemecolor","tag-pcr","tag-pdf","tag-pdf-tables","tag-point","tag-points","tag-power-bi","tag-power-bi-desktop","tag-power-query","tag-promoteheaders","tag-removecolumns","tag-rgb","tag-selectrows","tag-series","tag-seriescollection","tag-table-expandtablecolumn","tag-table-promoteheaders","tag-table-removecolumns","tag-table-skip","tag-table-transformcolumntypes","tag-table-unpivotothercolumns","tag-textframe2","tag-textrange","tag-timesnewroman","tag-transformcolumntypes","tag-twitter","tag-unpivotothercolumns","tag-visible-2","tag-weight","tag-worksheet","tag-8048","tag-8040","tag-8055","tag-3942","tag-2783","tag-4383","tag-1013","tag-5667","tag-437","tag-8051","tag-462","tag-8058","tag-646","tag-5276","tag-4162","tag-4292","tag-1026","tag-4516","tag-4381","tag-7925","tag-5247","tag-2911","tag-4825","tag-5357","tag-8045","tag-1291","tag-4818","tag-663","tag-5356","tag-8049","tag-3553","tag-3901","tag-8072","tag-8050","tag-8039","tag-4393","tag-5178","tag-2764","tag-4354","tag-8067","tag-5529","tag-5432","tag-1794","tag-8052","tag-1027","tag-1022","tag-5431","tag-2497","tag-4940","tag-5258","tag-7924","tag-2781","tag-5063","tag-8041","tag-8059","tag-8043","tag-8042","tag-8047","tag-8066","tag-4402","tag-3442","tag-3654","tag-5064","tag-8053","tag-8057","tag-3915","tag-8056","tag-4439","tag-8054","tag-8046"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/11875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11875"}],"version-history":[{"count":40,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/11875\/revisions"}],"predecessor-version":[{"id":11952,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/11875\/revisions\/11952"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/11922"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}