{"id":6650,"date":"2013-01-11T07:49:12","date_gmt":"2013-01-10T22:49:12","guid":{"rendered":"http:\/\/oichinote.com\/plus\/?p=6650"},"modified":"2013-01-11T07:49:12","modified_gmt":"2013-01-10T22:49:12","slug":"make-a-html-table-with-excel","status":"publish","type":"post","link":"https:\/\/oichinote.com\/plus\/2013\/01\/make-a-html-table-with-excel.html","title":{"rendered":"Excel\u3067\u7c21\u5358\u306bHTML\u306etable\u3092\u4f5c\u308b"},"content":{"rendered":"

\u79c1\u306f\u3001WordPress\u3092\u4f7f\u3063\u305f\u30d6\u30ed\u30b0\u306e\u4e2d\u3067\u3001\u8868\u3092\u591a\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

WordPress\u3067\u8868\u3092\u4f5c\u308b\u305f\u3081\u306eplug-in\u3092\u63a2\u3057\u307e\u3057\u305f\u304c\u3001\u3042\u307e\u308a\u826f\u3055\u305d\u3046\u306a\u7269\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n

\u305d\u308c\u3067\u3001\u56f0\u3063\u305f\u3042\u3052\u304f\u3001Microsoft Excel\u3092\u4f7f\u3063\u3066\u3001\u751f\u306eHTML\u3092\u5410\u304d\u51fa\u3057\u3001\u305d\u308c\u3092WordPress\u306b\u8cbc\u4ed8\u3051\u308b\u4e8b\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n

\u3053\u306e\u65b9\u6cd5\u304c\u3001\u601d\u3044\u306e\u307b\u304b\u5feb\u9069\u3067\u3001\u8868\u3092\u4f5c\u308b\u306e\u304c\u975e\u5e38\u306b\u697d\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n

\u6b21\u306e\u8868\u3092\u4f5c\u308a\u305f\u3044\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n
\u54c1\u540d<\/th>\n\u500b\u6570<\/th>\n<\/tr>\n
\u30a4\u30c1\u30b4<\/td>\n10<\/td>\n<\/tr>\n
\u306b\u3093\u3058\u3093<\/td>\n1<\/td>\n<\/tr>\n
\u30b5\u30f3\u30c0\u30eb<\/td>\n2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u3053\u306e\u8868\u306f\u3001\u6b21\u306e\u624b\u9806\u3067\u4f5c\u308c\u307e\u3059\u3002<\/p>\n

    \n
  1. Excel\u3067\u666e\u901a\u306e\u8868\u3092\u4f5c\u308b<\/li>\n
  2. table\u306e\u8981\u7d20\u30bf\u30b0\u3068\u5bfe\u5fdc\u3055\u305b\u308b<\/li>\n
  3. \u5404\u8981\u7d20\u30bf\u30b0\u3092\u7d50\u5408<\/li>\n
  4. WordPress\u306b\u8cbc\u4ed8\u3051<\/li>\n<\/ol>\n

    \u3067\u306f\u3001\u9806\u3092\u8ffd\u3063\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n

    \u7528\u610f\u3059\u308b\u3082\u306e<\/h3>\n

    \u79c1\u306fExcel\u3092\u4f7f\u3044\u307e\u3057\u305f\u304c\u3001\u540c\u7b49\u306e\u6a5f\u80fd\u3092\u6301\u3064\u8868\u8a08\u7b97\u30bd\u30d5\u30c8\u306a\u3089\u3001\u4f55\u3067\u3082\u826f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

    \u4f7f\u3046\u6a5f\u80fd(\u95a2\u6570)\u306f\u3001\u6587\u5b57\u5217\u306e\u7d50\u5408\u7a0b\u5ea6\u3067\u3059\u3002<\/p>\n[amazonjs asin=\"B004478OOY\" locale=\"JP\"]\n

    1. Excel\u3067\u666e\u901a\u306e\u8868\u3092\u4f5c\u308b<\/h3>\n

    \u307e\u305a\u3001\u6700\u7d42\u7684\u306b\u4f5c\u308a\u305f\u3044\u8868\u3092Excel\u3067\u4f5c\u308a\u307e\u3059\u3002<\/p>\n

    \"\u30aa\u30ea\u30b8\u30ca\u30eb\u8868\"<\/p>\n

    \u5b9f\u306f\u3001\u3053\u306e\u307e\u307e\u3067\u306ftable\u306e\u30bf\u30b0\u3092\u57cb\u3081\u8fbc\u3080\u6642\u306b\u4e0d\u4fbf\u306a\u306e\u3067\u3001\u4e0a\u4e0b\u306b2\u884c\u305a\u3064\u9699\u9593\u3092\u7a7a\u3051\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n

    \"\u4f59\u88d5\u3092\u8ffd\u52a0\u3057\u305f\u8868\"<\/p>\n

    \u3053\u3053\u307e\u3067\u304c\u3001\u751f\u306e\u8868\u306e\u6e96\u5099\u3067\u3059\u3002<\/p>\n

    2. table\u306e\u8981\u7d20\u30bf\u30b0\u3068\u5bfe\u5fdc\u3055\u305b\u308b<\/h3>\n

    \u6b21\u304c\u3001\u3053\u306e\u65b9\u6cd5\u306e\u809d\u3067\u3059\u3002<\/p>\n

    \u6b21\u306e\u69d8\u306b\u3001\u8868\u306e\u5404\u8981\u7d20\u3092\u3001HTML\u306etable\u30bf\u30b0\u306b\u5bfe\u5fdc\u3055\u305b\u307e\u3059\u3002(\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u62e1\u5927\u3057\u307e\u3059)<\/p>\n

    \"\u8868\u306e\u8981\u7d20\u30bf\u30b0\"<\/a><\/p>\n

    \u3053\u306e\u6642\u3001<table>\u3084<tr>\u30bf\u30b0\u7b49\u3001\u5fc5\u8981\u306a\u7269\u3092\u8868\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n

    \u5b9f\u969b\u306b\u3001Excel\u306b\u5165\u529b\u3059\u308b\u5f0f\u3068\u3057\u3066\u306f\u3001\u6b21\u306e\u69d8\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n\n\n\n\n
    <table border="1"><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <tbody><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <tr><\/td>\n="<th>"&A3&"<\/th>"<\/td>\n="<th>"&B3&"<\/th>"<\/td>\n<\/tr><\/td>\n<\/tr>\n
    <tr><\/td>\n="<td style="&CHAR(34)&"text-align: center;"&CHAR(34)&">"&A4&"<\/td>"<\/td>\n="<td style="&CHAR(34)&"text-align: center;"&CHAR(34)&">"&B4&"<\/td>"<\/td>\n<\/tr><\/td>\n<\/tr>\n
    <tr><\/td>\n="<td style="&CHAR(34)&"text-align: center;"&CHAR(34)&">"&A5&"<\/td>"<\/td>\n="<td style="&CHAR(34)&"text-align: center;"&CHAR(34)&">"&B5&"<\/td>"<\/td>\n<\/tr><\/td>\n<\/tr>\n
    <tr><\/td>\n="<td style="&CHAR(34)&"text-align: center;"&CHAR(34)&">"&A6&"<\/td>"<\/td>\n="<td style="&CHAR(34)&"text-align: center;"&CHAR(34)&">"&B6&"<\/td>"<\/td>\n<\/tr><\/td>\n<\/tr>\n
    <\/tbody><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <\/table><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    3. \u5404\u8981\u7d20\u30bf\u30b0\u3092\u7d50\u5408<\/h3>\n

    \u3053\u3046\u3057\u3066\u4f5c\u3063\u305f\u5404\u8981\u7d20\u30bf\u30b0\u3092\u3001Excel\u306econcatinate<\/p>\n

    \"\u5404\u8981\u7d20\u30bf\u30b0\u306e\u7d50\u5408\"<\/p>\n

    \u5b9f\u969b\u306b\u3001Excel\u306b\u5165\u529b\u3059\u308b\u5f0f\u3068\u3057\u3066\u306f\u3001\u6b21\u306e\u69d8\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n\n\n\n\n
    =CONCATENATE(E1,F1,G1,H1)<\/td>\n<\/tr>\n
    =CONCATENATE(E2,F2,G2,H2)<\/td>\n<\/tr>\n
    =CONCATENATE(E3,F3,G3,H3)<\/td>\n<\/tr>\n
    =CONCATENATE(E4,F4,G4,H4)<\/td>\n<\/tr>\n
    =CONCATENATE(E5,F5,G5,H5)<\/td>\n<\/tr>\n
    =CONCATENATE(E6,F6,G6,H6)<\/td>\n<\/tr>\n
    =CONCATENATE(E7,F7,G7,H7)<\/td>\n<\/tr>\n
    =CONCATENATE(E8,F8,G8,H8)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u3059\u308b\u3068\u3001\u6b21\u306e\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

    \"\u7d50\u5408\u7d50\u679c\"<\/p>\n

    4. WordPress\u306b\u8cbc\u4ed8\u3051<\/h3>\n

    \u3053\u306e\u3001J1\u301cJ8\u3092\u30b3\u30d4\u30fc\u3057\u3066\u3001WordPress\u306b\u8cbc\u4ed8\u3051\u307e\u3059\u3002<\/p>\n

    \u3053\u306e\u6642\u3001\u300c\u30c6\u30ad\u30b9\u30c8\u300d\u30e2\u30fc\u30c9\u306b\u5207\u308a\u66ff\u3048\u3066\u304a\u304d\u3001\u751f\u306eHTML\u3092\u66f8\u304d\u8fbc\u3081\u308b\u69d8\u306b\u304a\u304d\u307e\u3059\u3002<\/p>\n

    \"\u30c6\u30ad\u30b9\u30c8\u30e2\u30fc\u30c9\"<\/p>\n

    \u3053\u308c\u3067\u3001\u5b8c\u6210\u3067\u3059\u3002<\/p>\n\n\n\n\n\n\n
    \u54c1\u540d<\/th>\n\u500b\u6570<\/th>\n<\/tr>\n
    \u30a4\u30c1\u30b4<\/td>\n10<\/td>\n<\/tr>\n
    \u306b\u3093\u3058\u3093<\/td>\n1<\/td>\n<\/tr>\n
    \u30b5\u30f3\u30c0\u30eb<\/td>\n2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u3053\u306e\u65b9\u6cd5\u3092\u4f7f\u3048\u3070\u3001\u8272\u3005\u5fdc\u7528\u304c\u5229\u304f\u3068\u601d\u3046\u306e\u3067\u3001\u8a66\u3057\u3066\u307f\u3066\u4e0b\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u79c1\u306f\u3001WordPress\u3092\u4f7f\u3063\u305f\u30d6\u30ed\u30b0\u306e\u4e2d\u3067\u3001\u8868\u3092\u591a\u7528\u3057\u3066\u3044\u307e\u3059\u3002 WordPress\u3067\u8868\u3092\u4f5c\u308b\u305f\u3081\u306eplug-in\u3092\u63a2\u3057\u307e\u3057\u305f\u304c\u3001\u3042\u307e\u308a\u826f\u3055\u305d\u3046\u306a\u7269\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002 \u305d\u308c\u3067\u3001\u56f0\u3063\u305f\u3042\u3052\u304f\u3001Microsoft Exc […]<\/p>\n","protected":false},"author":1,"featured_media":6655,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u65b0\u3057\u3044\u8a18\u4e8b\u300eExcel\u3067\u7c21\u5358\u306bHTML\u306etable\u3092\u4f5c\u308b\u300f\u3092\u6295\u7a3f\u3057\u307e\u3057\u305f\u3002\u8aad\u3093\u3067\u3044\u305f\u3060\u3051\u308b\u3068\u5b09\u3057\u3044\u3067\u3059\u3002","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9,33,5],"tags":[],"class_list":["post-6650","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-webblog-cocolog","category-wordpress","category-computer"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/oichinote.com\/plus\/files\/2013\/01\/20130111table1.png","jetpack-related-posts":[{"id":14089,"url":"https:\/\/oichinote.com\/plus\/2015\/01\/display-seat-map-with-prize.html","url_meta":{"origin":6650,"position":0},"title":"\u5ea7\u5e2d\u8868\u306b\u5408\u308f\u305b\u3066\u5f53\u9078\u5546\u54c1\u3092\u8868\u793a\u3059\u308b","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2015\u5e741\u670828\u65e5","format":false,"excerpt":"\u6b21\u306e\u8a18\u4e8b\u3067\u3001\u30db\u30fc\u30eb\u306e\u5ea7\u5e2d\u8868\u3068\u5f53\u9078\u5546\u54c1\u306e\u7d10\u4ed8\u3051\u3092\u3057\u3066\u3001\u8868\u793a\u3057\u3066\u3044\u307e\u3059\u3002 \u7b2c18\u56de\u30de\u30ca\u30ab\u30ca\u30d5\u30a1\u30f3\u306e\u96c6\u3044i\u2026","rel":"","context":"Mac","block_context":{"text":"Mac","link":"https:\/\/oichinote.com\/plus\/category\/mac"},"img":{"alt_text":"\u5ea7\u5e2d\u8868\u3068\u5546\u54c1\u540d\u306e\u5bfe\u5fdc\u8868(\u30a8\u30e9\u30fc\u6d88\u53bb)","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2015\/01\/20150128seat-map.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":9836,"url":"https:\/\/oichinote.com\/plus\/2013\/10\/bought-numbers-of-ios-edition.html","url_meta":{"origin":6650,"position":1},"title":"iOS\u7248Numbers\u3092\u8cb7\u3044\u307e\u3057\u305f","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2013\u5e7410\u670817\u65e5","format":false,"excerpt":"\u5642\u3067\u306f\u3001\u5186\u5b89\u306e\u5f71\u97ff\u3067\u3001iOS\u30a2\u30d7\u30ea\u304c\u5024\u4e0a\u3052\u3055\u308c\u308b\u3068\u304b...\u3002 Pricing in Japanese\u2026","rel":"","context":"iPad\/iPod\/iPhone","block_context":{"text":"iPad\/iPod\/iPhone","link":"https:\/\/oichinote.com\/plus\/category\/ipad-ipod-iphone"},"img":{"alt_text":"Numbers","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2013\/10\/20131017numbers.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2018,"url":"https:\/\/oichinote.com\/plus\/2011\/07\/vba-9c75.html","url_meta":{"origin":6650,"position":2},"title":"VBA\u3067\u4e88\u544a\u7121\u304f\u7d42\u4e86\u3059\u308b\u30d0\u30b0\u306b\u60a9\u307e\u3055\u308c\u307e\u3057\u305f[\u8ffd\u8a18\u3042\u308a]","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2011\u5e747\u670815\u65e5","format":false,"excerpt":"Excel\u306eVBA(Visual Basic)\u3067\u3001\u983c\u307e\u308c\u305f\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u3063\u3066\u3044\u307e\u3057\u305f\u3002\u79c1\u306f\u3001Exce\u2026","rel":"","context":"\u30d1\u30bd\u30b3\u30f3\u30fb\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8","block_context":{"text":"\u30d1\u30bd\u30b3\u30f3\u30fb\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8","link":"https:\/\/oichinote.com\/plus\/category\/computer"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16793,"url":"https:\/\/oichinote.com\/plus\/2016\/01\/flets-azukel.html","url_meta":{"origin":6650,"position":3},"title":"\u30d5\u30ec\u30c3\u30c4\u3042\u305a\u3051\u301c\u308b\u3067Office365","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2016\u5e741\u670821\u65e5","format":false,"excerpt":"\u30d5\u30ec\u30c3\u30c4\u3042\u305a\u3051\u301c\u308b\u3092\u5951\u7d04\u3057\u307e\u3057\u305f\u3002Office365\u304c\u6708350\u5186\u3067\u4f7f\u3048\u308b\u3068\u8a00\u3046\u306e\u3067\u3002\u4f7f\u3048\u308bOffic\u2026","rel":"","context":"\u30d1\u30bd\u30b3\u30f3\u30fb\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8","block_context":{"text":"\u30d1\u30bd\u30b3\u30f3\u30fb\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8","link":"https:\/\/oichinote.com\/plus\/category\/computer"},"img":{"alt_text":"Web\u7248Excel\u30a8\u30e9\u30fc","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2016\/01\/20160121flets-excel.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":6703,"url":"https:\/\/oichinote.com\/plus\/2013\/01\/comparison-of-multi-function-printers-that-can-print-to-cd-label.html","url_meta":{"origin":6650,"position":4},"title":"\u30ec\u30fc\u30d9\u30eb\u5370\u5237\u3067\u304d\u308b\u8907\u5408\u6a5f\u306e\u6bd4\u8f03","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2013\u5e741\u670813\u65e5","format":false,"excerpt":"\u975e\u5e38\u306b\u91cd\u5b9d\u3057\u3066\u3044\u305f\u30d7\u30ea\u30f3\u30bf\/FAX\/\u30b9\u30ad\u30e3\u30ca\u8907\u5408\u6a5f\u3001\u30d2\u30e5\u30fc\u30ec\u30c3\u30c8\u30d1\u30c3\u30ab\u30fc\u30c9Photosmart C3\u2026","rel":"","context":"iPad\/iPod\/iPhone","block_context":{"text":"iPad\/iPod\/iPhone","link":"https:\/\/oichinote.com\/plus\/category\/ipad-ipod-iphone"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":124,"url":"https:\/\/oichinote.com\/plus\/2006\/05\/nexttrain_7fb3.html","url_meta":{"origin":6650,"position":5},"title":"NextTrain\u7528\u30c7\u30fc\u30bf\u4f5c\u6210","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2006\u5e745\u67086\u65e5","format":false,"excerpt":"\u4ee5\u524d\u3001NextTrain \u306e\u8a18\u4e8b\u3092\u66f8\u3044\u305f\u3002NextTrain\u3068\u306f\u3001\u6642\u523b\u8868\u30a2\u30d7\u30ea\u306e\u4e00\u7a2e\u3067\u3001\u6b21\u306b\u767a\u8eca\u3059\u308b\u2026","rel":"","context":"\u985e\u4f3c\u6295\u7a3f","block_context":{"text":"\u985e\u4f3c\u6295\u7a3f","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts\/6650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/comments?post=6650"}],"version-history":[{"count":32,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts\/6650\/revisions"}],"predecessor-version":[{"id":6689,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts\/6650\/revisions\/6689"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/media\/6655"}],"wp:attachment":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/media?parent=6650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/categories?post=6650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/tags?post=6650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}