{"id":4228,"date":"2019-12-24T13:06:19","date_gmt":"2019-12-24T04:06:19","guid":{"rendered":"https:\/\/salesp.jp\/spmanual\/?p=4228"},"modified":"2023-12-18T14:37:30","modified_gmt":"2023-12-18T05:37:30","slug":"excel","status":"publish","type":"post","link":"https:\/\/salesp.jp\/spmanual\/excel\/","title":{"rendered":"Excel(Windows)\u3068\u306e\u81ea\u52d5\u9023\u643a"},"content":{"rendered":"\r\n<div id=\"contents\" style=\"text-align: left;\">\r\n<h1 style=\"text-align: left;\"><span style=\"font-size: 18px;\">Excel\uff08Windows\uff09\u3068 Sales Performer \u306e\u81ea\u52d5\u9023\u643a<\/span><\/h1>\r\n<p><a name=\"up\"><\/a> <a name=\"1_0\"><\/a><\/p>\r\n<p style=\"text-align: left;\"><img loading=\"lazy\" class=\"size-full wp-image-4971 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver.png\" alt=\"\" width=\"1280\" height=\"720\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver.png 1280w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-300x169.png 300w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-1024x576.png 1024w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-768x432.png 768w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-320x180.png 320w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-530x298.png 530w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-565x318.png 565w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-710x399.png 710w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelver-725x408.png 725w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/p>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 211px;\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 13%; height: 37px; border-color: #ebeff2; background-color: #ebeff2;\"><span style=\"color: #0066cc;\"><strong>\u30e1\u30fc\u30eb\u9023\u52d5<\/strong><\/span><\/td>\r\n<td style=\"width: 36%; height: 37px; border-color: #fff; background-color: #fff;\">\u00a0<\/td>\r\n<td style=\"width: 2%; height: 37px; border-color: #ffffff; background-color: #ffffff;\">\u00a0<\/td>\r\n<td style=\"width: 13%; height: 37px; border-color: #ebeff2; background-color: #ebeff2;\"><span style=\"color: #0066cc;\"><strong>FTP\u9023\u52d5<\/strong><\/span><\/td>\r\n<td style=\"width: 36%; height: 37px; border-color: #fff; background-color: #fff;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 97px;\">\r\n<td style=\"width: 13%; height: 97px; border-color: #ebeff2; background-color: #ebeff2;\">\u30e1\u30ea\u30c3\u30c8\u3000\uff1a<\/td>\r\n<td style=\"width: 36%; text-align: left; height: 97px; border-color: #ebeff2; background-color: #ebeff2;\">Gmail\u306e\u9001\u4fe1\u6e08\u30d5\u30a9\u30eb\u30c0\u306bCSV\u30d5\u30a1\u30a4\u30eb\u304c\u84c4\u7a4d\u3055\u308c\u308b\u305f\u3081\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u3057\u3066\u5fdc\u7528\u53ef<\/td>\r\n<td style=\"width: 2%; height: 97px; border-color: #ffffff; background-color: #ffffff;\">\u00a0<\/td>\r\n<td style=\"width: 13%; height: 97px; border-color: #ebeff2; background-color: #ebeff2;\">\u30e1\u30ea\u30c3\u30c8\u3000\uff1a<\/td>\r\n<td style=\"width: 36%; text-align: left; height: 97px; border-color: #ebeff2; background-color: #ebeff2;\">\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u5c0e\u5165\u3057\u3066\u3044\u3066\u3082\u3001Excel\u9023\u52d5\u3092\u5b9f\u88c5\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd<br \/><span style=\"color: #ff0000;\">\u203bFTPS(explicit)\u901a\u4fe1\u3068\u306a\u308a\u307e\u3059<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 77px;\">\r\n<td style=\"width: 13%; height: 77px; border-color: #ebeff2; background-color: #ebeff2;\">\u30c7\u30e1\u30ea\u30c3\u30c8\uff1a<\/td>\r\n<td style=\"width: 36%; text-align: left; height: 77px; border-color: #ebeff2; background-color: #ebeff2;\">Google\u793e\u306b\u3088\u308b\u4ed5\u69d8\u5909\u66f4\u306b\u3088\u308a\u3001Apps Script\u304b\u3089\u306e\u30e1\u30fc\u30eb\u9001\u4fe1\u304c\u4e0d\u53ef\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b<\/td>\r\n<td style=\"width: 2%; height: 77px; border-color: #ffffff; background-color: #ffffff;\">\u00a0<\/td>\r\n<td style=\"width: 13%; height: 77px; border-color: #ebeff2; background-color: #ebeff2;\">\u30c7\u30e1\u30ea\u30c3\u30c8\uff1a<\/td>\r\n<td style=\"width: 36%; text-align: left; height: 77px; border-color: #ebeff2; background-color: #ebeff2;\">Gmail\u306e\u3088\u3046\u306b\u9001\u4fe1\u6e08\u30d5\u30a9\u30eb\u30c0\u304c\u7121\u3044\u305f\u3081\u3001CSV\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u4fdd\u5b58\u3067\u304d\u306a\u3044<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<div id=\"contents\">\r\n<h3>Excel\u9023\u52d5\u3092\u3054\u691c\u8a0e\u3055\u308c\u3066\u3044\u308b\u969b\u306f\u3001\u304a\u6c17\u8efd\u306b\u5f0a\u793e\u307e\u3067\u304a\u554f\u3044\u5408\u305b\u304f\u3060\u3055\u3044<br \/>\u8a2d\u5b9a\u3092\u304a\u624b\u4f1d\u3044\u3055\u305b\u3066\u9802\u304d\u307e\u3059<br \/><br \/>TEL 0120-958-172 (\u5e73\u65e59:00\uff5e18:00)<\/h3>\r\n<\/div>\r\n<h2 style=\"text-align: left;\">[FTP\u9023\u52d5]Excel\u81ea\u52d5\u9023\u643a<\/h2>\r\n<p style=\"text-align: center;\"><span style=\"font-size: 18px; color: #0066cc;\"><strong>\u624b\u9806\u6982\u8981<\/strong><\/span><\/p>\r\n<table style=\"border-collapse: collapse; width: 101.166%; height: 50px;\">\r\n<tbody>\r\n<tr style=\"height: 86px;\">\r\n<td style=\"width: 100%; height: 50px; background-color: #f8f8f8; text-align: left;\"><br \/>\r\n<ol>\r\n<li><span style=\"font-size: 14px;\"><span style=\"color: #ff0000;\">\u9023\u643a\u5bfe\u8c61Excel<\/span>\u306b\u65b0\u898f\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3001Excel\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\"><span style=\"color: #ff0000;\">\u65b0\u305f\u306aExcel<\/span>\u3092\u4f5c\u6210\u3057\u3001<span style=\"color: #ff0000;\">\u5bfe\u8c61Excel<\/span>\u3067\u96c6\u8a08\u3057\u305f\u5024\uff08\u30bb\u30eb\uff09\u3092\u300c=\u300d\u3067\u7d50\u3073\u4ed8\u3051\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\"><span style=\"color: #ff0000;\">2\u3067\u4f5c\u6210\u3057\u305fExcel<\/span>\u306b\u3001\u81ea\u52d5\u3067CSV\u5f62\u5f0f\u306b\u5909\u63db\u4fdd\u5b58\u3059\u308bVBA\uff08\u30de\u30af\u30ed\uff09\u3092\u4f5c\u6210\u3057\u3001\u4fdd\u5b58<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3067\u3001<span style=\"color: #ff0000;\">3\u306eExcel<\/span>\u3092\u81ea\u52d5\u3067\u958b\u304f\u8a2d\u5b9a\u3092\u884c\u3044\u3001<span style=\"color: #ff0000;\">CSV<\/span>\u3092\u81ea\u52d5\u751f\u6210\u3055\u305b\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">PC\u30a2\u30d7\u30ea\u300c<span style=\"color: #ff0000;\">FFFTP<\/span>\u300d\u3092\u81ea\u52d5\u8d77\u52d5\u3055\u305b\u308b\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3067\u3001<span style=\"color: #ff0000;\">FFFTP<\/span>\u306e\u30d0\u30c3\u30c1\u3092\u5b9f\u884c\u3055\u305b\u3001<span style=\"color: #ff0000;\">FTP\u9023\u643a<\/span>\u3092\u884c\u3046<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">Excel\u3068Sales Performer\u304c\u81ea\u52d5\u9023\u643a\u3055\u308c\u308b<\/span><\/li>\r\n<\/ol>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<span style=\"color: #0066cc;\"><strong><span style=\"font-size: 18px;\">\u5404\u624b\u9806\u8a73\u7d30\u8aac\u660e<br \/><\/span><\/strong><\/span><\/div>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff11.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\u9023\u643a\u5bfe\u8c61Excel\u306b\u65b0\u898f\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3001<\/span><br \/><span style=\"font-size: 18px; color: #0066cc;\">Excel\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><span style=\"font-size: 14px;\">Excel\u95a2\u6570\u300cSUMIF\u300d\u300cCOUTIF\u300d\u306a\u3069\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3001<br \/><span style=\"text-align: center;\">\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u300c\u6708\u6b21\u300d\u300c\u65e5\u6b21\u300d\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b<br \/><span style=\"color: #ff0000;\">\u203b\u65e2\u306b\u4f5c\u6210\u3055\u308c\u3066\u3044\u308c\u3070\u4e0d\u8981<\/span><\/span><\/span><\/p>\r\n<table style=\"border-collapse: collapse; width: 88.3671%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 100%; background-color: #e3f2fd;\"><span style=\"font-size: 14px;\">\u95a2\u6570\u8a08\u7b97\u3092\u4f7f\u3063\u305f\u96c6\u8a08\u306f\u3001\u3053\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3067<span style=\"text-decoration: underline;\">\u5b8c\u7d50<\/span>\u3057\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308b<br \/><br \/><\/span><span style=\"font-size: 14px;\">\u5f8c\u306b\u8ee2\u8a18\u3055\u305b\u308bCSV\u5909\u63db\u7528\u306e<span style=\"color: #0b559d;\"><strong>\u300c CSV\u30a4\u30f3\u30dd\u30fc\u30c8.xlsm \u300d<\/strong><\/span>\u3067\u306f\u3001<br \/>\u96c6\u8a08\u7d50\u679c\u306e\u30bb\u30eb\uff08\u5024\uff09\u3092<\/span><span style=\"font-size: 14px;\">\u300c<span style=\"text-decoration: underline;\">=(\u30a4\u30b3\u30fc\u30eb)\u300d\u3067\u7d10\u4ed8\u3051\u8868\u793a\u3055\u305b\u308b\u305f\u3081<\/span><\/span><span style=\"font-size: 14px;\"><br \/><br \/>\u203b\u5f8c\u306b\u4f5c\u6210\u3059\u308bCSV\u306e\u751f\u6210\u6642\u306b\u9023\u643a\u5bfe\u8c61Excel\u304c\u7acb\u3061\u4e0a\u304c\u3063\u3066\u306a\u3044\u3068\u3001<br \/><\/span><span style=\"font-size: 14px;\">\u3000<span style=\"text-decoration: underline;\">\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u3057\u307e\u3046\u305f\u3081<\/span><\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff12.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\u65b0\u305f\u306aExcel\u3092\u4f5c\u6210\u3057\u3001\u5bfe\u8c61Excel\u3067\u96c6\u8a08\u3057\u305f\u5024\uff08\u30bb\u30eb\uff09\u3092\u300c=\u300d\u3067\u7d50\u3073\u4ed8\u3051\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<div style=\"text-align: center;\">\r\n<ul style=\"text-align: left;\">\r\n<li><span style=\"font-size: 12px;\">\u3053\u306e\u6642\u70b9\u3067\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u3001CSV\u30d5\u30a1\u30a4\u30eb(.csv)\u3067\u306a\u304f\u3001<span style=\"color: #000000;\">Excel\u30d5\u30a1\u30a4\u30eb\uff08<span style=\"color: #ff0000;\">.xlsx<\/span>\uff09\u3067<\/span>\u3059\u3002<\/span><\/li>\r\n<li><span style=\"font-size: 12px;\">\u30ec\u30a4\u30a2\u30a6\u30c8\u306fSales Performer\u306eCSV\u8aad\u307f\u8fbc\u307f\u7528\u30ec\u30a4\u30a2\u30a6\u30c8\u3067\u4f5c\u6210\u3057\u3001A\u5217\u3068B\u5217\u306f\u4e88\u3081\u5165\u308c\u3066\u304a\u304f<\/span><\/li>\r\n<li><span style=\"font-size: 12px;\">\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u3001\u9023\u643a\u5bfe\u8c61Excel\u3067\u96c6\u8a08\u3057\u305f\u5024\u3092\u300c=\u300d\u3067\u7d10\u4ed8\u3051\u3001\u5024\u3092\u8868\u793a\u3055\u305b\u308b<\/span><\/li>\r\n<\/ul>\r\n<span style=\"font-size: 14px;\"><br \/><span style=\"color: #0066cc;\">CSV\u8aad\u307f\u8fbc\u307f\u7528\u30ec\u30a4\u30a2\u30a6\u30c8<\/span><\/span><br \/><span style=\"font-size: 10px; color: #0066cc;\">(\u7070\u8272\u30bb\u30eb\u306fExcel\u306e\u5217\/\u884c\u3092\u793a\u3057\u3066\u3044\u307e\u3059)<\/span><\/div>\r\n<div style=\"text-align: left;\"><br \/>\r\n<table style=\"border-collapse: collapse; width: 99%; height: 40px;\">\r\n<tbody>\r\n<tr style=\"height: 10px;\">\r\n<td style=\"width: 3%; height: 10px; background-color: #ebeff2;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">A<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">B<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">C<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">D<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">E<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">F<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">G<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">H<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 10px;\">\r\n<td style=\"width: 3%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">1<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">No.<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">\u30e1\u30f3\u30d0\u30fc<\/span><\/td>\r\n<td style=\"height: 10px; width: 12%;\" width=\"72\" height=\"25\"><span style=\"font-size: 10px;\">\u57fa\u672c\u52171<\/span><\/td>\r\n<td style=\"height: 10px; width: 12%;\" width=\"72\" height=\"25\"><span style=\"font-size: 10px;\">\u57fa\u672c\u52172<\/span><\/td>\r\n<td style=\"height: 10px; width: 12%;\" width=\"72\" height=\"25\"><span style=\"font-size: 10px;\">\u57fa\u672c\u52173<\/span><\/td>\r\n<td style=\"height: 10px; width: 12%;\" width=\"72\" height=\"25\"><span style=\"font-size: 10px;\">\u57fa\u672c\u52174<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">\u53d7\u6ce8\u65e5<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">\u5099\u8003<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 10px;\">\r\n<td style=\"width: 3%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">2<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">1<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">\u7530\u4e2d<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 10px;\">\r\n<td style=\"width: 3%; height: 10px; background-color: #ebeff2; text-align: center;\"><span style=\"font-size: 10px;\">3<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">2<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\"><span style=\"font-size: 10px;\">\u5409\u7530<\/span><\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<td style=\"width: 12%; height: 10px;\">\u00a0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n<div>\r\n<table style=\"border-collapse: collapse; width: 93.3706%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 100%; background-color: #f8f8f8;\"><span style=\"font-size: 12px;\">\uff21\u5217\u3000No.\u3000\u3000\u00a0 \uff1a \u5bfe\u8c61\u30e1\u30f3\u30d0\u30fc\u306eNo.\u3092\u5165\u529b\u3057\u307e\u3059(<a href=\"https:\/\/salesp.jp\/spmanual\/setting-member\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u30e1\u30f3\u30d0\u30fc\u8a2d\u5b9a<\/a>\u753b\u9762\u3067\u3082\u78ba\u8a8d\u3067\u304d\u307e\u3059)<\/span><br \/><span style=\"font-size: 12px;\">\uff22\u5217\u3000\u30e1\u30f3\u30d0\u30fc \uff1a \u5bfe\u8c61\u30e1\u30f3\u30d0\u30fc\u306e\u540d\u524d\u3092\u767b\u9332\u3057\u307e\u3059<\/span><br \/><span style=\"font-size: 12px;\">\uff23\u5217\u3000\u57fa\u672c\u52171\u00a0 \uff1a Sales Performer\u306e\u30b0\u30e9\u30d5\u5217\uff11\u3067\u8868\u793a\u3055\u305b\u308b\u5024\u3092\u300c=\u300d\u3067\u7d10\u4ed8\u3051\u307e\u3059<\/span><br \/><span style=\"font-size: 12px;\">\uff24\u5217\u3000\u57fa\u672c\u52172\u00a0 \uff1a Sales Performer\u306e\u30b0\u30e9\u30d5\u5217\uff12\u3067\u8868\u793a\u3055\u305b\u308b\u5024\u3092\u300c=\u300d\u3067\u7d10\u4ed8\u3051\u307e\u3059<\/span><br \/><span style=\"font-size: 12px;\">\uff25\u5217\u3000\u57fa\u672c\u52173\u00a0 \uff1a Sales Performer\u306e\u30b0\u30e9\u30d5\u5217\uff13\u3067\u8868\u793a\u3055\u305b\u308b\u5024\u3092\u300c=\u300d\u3067\u7d10\u4ed8\u3051\u307e\u3059<\/span><br \/><span style=\"font-size: 12px;\">\uff26\u5217\u3000\u57fa\u672c\u52174\u00a0 \uff1a Sales Performer\u306e\u30b0\u30e9\u30d5\u5217\uff14\u3067\u8868\u793a\u3055\u305b\u308b\u5024\u3092\u300c=\u300d\u3067\u7d10\u4ed8\u3051\u307e\u3059<\/span><br \/><span style=\"font-size: 12px;\">\uff27\u5217\u3000\u53d7\u6ce8\u65e5\u3000 \uff1a \u8a08\u4e0a\u65e5\u3092\u30bb\u30eb\u66f8\u5f0f<span style=\"color: #000000; background-color: #e3f2fd;\">\u300cyyyy\/mm\/dd\u300d<\/span>\u5f62\u5f0f\u3067\u5165\u529b\u3057\u307e\u3059<\/span><br \/><span style=\"font-size: 12px;\">\uff28\u5217\u3000\u5099\u8003\u3000\u3000 \uff1a \u81ea\u52d5\u9023\u643a\u3055\u308c\u305f\u5165\u529b\u3067\u3042\u308b\u6587\u8a00\u3092\u8a18\u8f09\u3057\u307e\u3059(Excel\u9023\u643a\u306a\u3069)<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.244%; height: 10px;\">\r\n<tbody>\r\n<tr style=\"height: 10px;\">\r\n<td style=\"width: 100%; height: 10px; background-color: #e3f2fd; border-color: #e3f2fd;\" colspan=\"2\">\r\n<p><span style=\"font-size: 14px;\">\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3067\u306f\u3001\u9023\u643a\u5bfe\u8c61Excel\u3092\u300c=\u300d\u3067\u7d10\u4ed8\u3051\u305f\u5024\u3092\u4f7f\u7528\u3057\u3066\u3001<br \/>\u96c6\u8a08\u8a08\u7b97\u3092\u884c\u3063\u3066\u306f\u306a\u3089\u306a\u3044<br \/><\/span><span style=\"font-size: 14px;\"><br \/>\u9023\u643a\u5bfe\u8c61Excel\u304c\u7acb\u3061\u4e0a\u304c\u3063\u3066\u3044\u308b\u3068\u304d\u306f\u6b63\u5e38\u306b\u53c2\u7167\u8a08\u7b97\u3055\u308c\u308b\u304c\u3001<br \/>\u9023\u643a\u5bfe\u8c61Excel\u304c<span style=\"text-decoration: underline;\">\u7acb\u3061\u4e0a\u304c\u3063\u3066\u3044\u306a\u3044\u5834\u5408<\/span>\u3001\u53c2\u7167\u4e0d\u80fd\u30a8\u30e9\u30fc\u8868\u793a\u306b\u306a\u3063\u3066\u3057\u307e\u3046<br \/><br \/><br \/><\/span><span style=\"font-size: 14px;\">A\uff5eH\u5217\u306e\u30bb\u30eb\u66f8\u5f0f\u306f\u3001\u4e0b\u8a18\u306b\u6cbf\u3063\u3066\u8a2d\u5b9a\u3092\u884c\u3046<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr style=\"height: 10px;\">\r\n<td style=\"width: 52.7912%; height: 10px; background-color: #e3f2fd; border-color: #e3f2fd;\">\r\n<p style=\"text-align: left;\"><span style=\"font-size: 14px;\">\uff21\u5217\uff1a\u6a19\u6e96 <span style=\"background-color: #ffff99; font-size: 12px;\"><span style=\"font-size: 10px;\">\u203b\u793e\u54e1ID\u3067\u9023\u643a\u3092\u884c\u3046\u5834\u5408\u306f\u300c\u6587\u5b57\u5217\u300d<\/span><\/span><br \/>\uff22\u5217\uff1a\u6a19\u6e96<br \/>\uff23\u5217\uff1a\u6a19\u6e96<br \/>\uff24\u5217\uff1a\u6a19\u6e96<br \/>\uff25\u5217\uff1a\u6a19\u6e96<br \/>\uff26\u5217\uff1a\u6a19\u6e96<br \/>\uff27\u5217\uff1a\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9 <span style=\"background-color: #ffff99; font-size: 12px;\"><span style=\"font-size: 10px;\">\u203byyyy\/m\/d or yyyy\/mm\/dd<\/span><\/span><br \/>\uff28\u5217\uff1a\u6a19\u6e96<\/span><\/p>\r\n<\/td>\r\n<td style=\"width: 47.2088%; height: 10px; background-color: #e3f2fd; border-color: #e3f2fd;\">\r\n<p><span style=\"font-size: 14px;\"><img loading=\"lazy\" class=\"size-medium wp-image-4494 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-284x300.gif\" alt=\"\" width=\"284\" height=\"300\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-284x300.gif 284w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-502x530.gif 502w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>\u6700\u5f8c\u306b\u3001[Excel]\uff0d[\u30c7\u30fc\u30bf]\uff0d[\u30af\u30a8\u30ea\u3068\u63a5\u7d9a]\uff0d[\u30ea\u30f3\u30af\u306e\u7de8\u96c6]\uff0d[\u8d77\u52d5\u6642\u306e\u78ba\u8a8d]\u3092\u958b\u304d\u3001<br \/>\u300c\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3057\u306a\u3044\u3067\u3001\u30ea\u30f3\u30af\u306e\u81ea\u52d5\u66f4\u65b0\u3092\u884c\u306a\u3046\u300d\u3092\u9078\u629e\u3057\u3066\u4fdd\u5b58<br \/><span style=\"color: #ff0000; background-color: #ffff99;\">\u203b[\u30c7\u30fc\u30bf]\u30bf\u30d6\u306b[\u30ea\u30f3\u30af\u306e\u7de8\u96c6]\u30dc\u30bf\u30f3\u304c\u9078\u629e\u3067\u304d\u306a\u3044\u5834\u5408<\/span><br \/><br \/><span style=\"color: #ff0000;\">\u9023\u643a\u5bfe\u8c61Excel\u3068\u300c=\u300d\u3092\u4f7f\u7528\u3057\u305f\u7d10\u4ed8\u3051\u304c\u884c\u3048\u3066\u3044\u306a\u3044\u306a\u3069\u3001<\/span><br \/><span style=\"color: #ff0000;\">\u5916\u90e8\u30d5\u30a1\u30a4\u30eb\u3068\u306e\u30ea\u30f3\u30af\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u539f\u56e0<\/span><br \/><img loading=\"lazy\" class=\"size-full wp-image-4587 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting6.gif\" alt=\"\" width=\"554\" height=\"478\" \/><br \/><br \/><\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff13.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">2\u3067\u4f5c\u6210\u3057\u305fExcel\u306b\u3001\u81ea\u52d5\u3067CSV\u5f62\u5f0f\u306b\u5909\u63db\u4fdd\u5b58\u3059\u308bVBA\uff08\u30de\u30af\u30ed\uff09\u3092\u4f5c\u6210\u3057\u3001\u4fdd\u5b58<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2460 \u30de\u30af\u30ed\u304c\u4f7f\u7528\u3067\u304d\u308b\u72b6\u614b\u306b\u3059\u308b\u00a0<\/span><\/strong><br \/>[Excel]\uff0d[\u30d5\u30a1\u30a4\u30eb]\uff0d[\u30aa\u30d7\u30b7\u30e7\u30f3]\uff0d[\u30ea\u30dc\u30f3\u306e\u30e6\u30fc\u30b6\u30fc\u8a2d\u5b9a]\u3067\u3001<br \/>[\u958b\u767a]\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001[OK]\u3092\u62bc\u3059<br \/><img loading=\"lazy\" class=\"size-full wp-image-4532 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting2.gif\" alt=\"\" width=\"934\" height=\"676\" \/><\/p>\r\n<p><br \/><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2461 Visual Basic\u306b\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u3066\u4fdd\u5b58 <\/span><\/strong><br \/>[Excel]\uff0d[\u958b\u767a]\uff0d[\u30de\u30af\u30ed\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3]\u3092\u958b\u304d\u3001<br \/>[\u3059\u3079\u3066\u306e\u30de\u30af\u30ed\u3092\u6709\u52b9\u306b\u3059\u308b]\u3092\u9078\u629e\u80a2\u3001[OK]\u3092\u62bc\u3059<br \/><img loading=\"lazy\" class=\"size-full wp-image-4537 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting3.gif\" alt=\"\" width=\"819\" height=\"577\" \/><br \/><br \/><br \/>[\u958b\u767a]\uff0d[Visual Basic]\u3092\u958b\u304f<br \/><img loading=\"lazy\" class=\"size-full wp-image-4540 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting4.gif\" alt=\"\" width=\"659\" height=\"154\" \/><\/p>\r\n<p><br \/>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e[ThisWorkBook]\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3001<br \/>\u4e0b\u8a18\u306e\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u308b<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-luxe-blocks-syntaxhighlighter line-numbers language-basic\">&lt;code class=&quot;language-basic&quot;&gt;Private Sub Workbook_Open()\r\n    Dim myPATH As String\r\n    Dim myFileName As String\r\n    Dim myLooP As Long\r\n    myPATH = &quot;C:\\Documents\\csv\\&quot; &#039;\u4fdd\u5b58\u5148\u30d5\u30a9\u30eb\u30c0\r\n    Application.DisplayAlerts = False &#039;\u78ba\u8a8d\u30e1\u30c3\u30bb\u30fc\u30b8OFF\r\n    For myLooP = 1 To ActiveWorkbook.Sheets.Count\r\n    &#039; myFileName = myPATH &amp;amp; Sheets(myLooP).Name &amp;amp; &quot;.csv&quot; &#039;\u30b7\u30fc\u30c8\u540d\u3092\u4fdd\u5b58\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u3059\u308b\u5834\u5408\r\n    &#039; myFileName = myPATH &amp;amp; &quot;20180000&quot; &amp;amp; &quot;.csv&quot; &#039;2018\u5e74\u3092\u4fdd\u5b58\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u3059\u308b\u5834\u5408\r\n    myFileName = myPATH &amp;amp; Format(Date, &quot;yyyymmdd&quot;) &amp;amp; &quot;.csv&quot; &#039;\u4eca\u65e5\u306e\u65e5\u4ed8\u3092\u4fdd\u5b58\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u3059\u308b\u5834\u5408\r\n    ActiveWorkbook.Sheets(myLooP).Copy\r\n    ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlCSV\r\n    ActiveWindow.Close\r\n    Next myLooP\r\n    Application.DisplayAlerts = True &#039;\u78ba\u8a8d\u30e1\u30c3\u30bb\u30fc\u30b8ON\r\n    Application.Wait Now + TimeValue(&quot;00:00:10&quot;) &#039;\u6307\u5b9a\u79d2\u6570\u30bf\u30a4\u30de\u30fc\u3067\u5f85\u3061\r\n    Application.Quit  &#039;\u30d7\u30ed\u30b0\u30e9\u30e0\u7d42\u4e86\r\n    ActiveWorkbook.Close savechanges:=False &#039;\u4fdd\u5b58\u78ba\u8a8d\u3092\u3057\u306a\u3044\r\nEnd Sub&lt;\/code&gt;<\/pre>\r\n\r\n\r\n\r\n<table style=\"width: 100%; height: 148px;\" width=\"212\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 21.8673%; border-color: #ffffff; height: 37px;\"><span style=\"background-color: #ffff99;\">\u25a0\u30b3\u30fc\u30c9\u89e3\u8aac<\/span><\/td>\r\n<td style=\"width: 78.0099%; border-color: #ffffff; height: 37px;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 21.8673%; border-color: #ffffff; height: 37px;\" width=\"140\">\u3000myPATH<\/td>\r\n<td style=\"width: 78.0099%; border-color: #ffffff; height: 37px;\" width=\"72\">\uff1a \u201c\u201d\u5185\u306b\u3001\u81ea\u52d5\u5909\u63db\u3057\u305fcsv\u30d5\u30a1\u30a4\u30eb\u3092\u4fdd\u5b58\u3059\u308b\u30d5\u30a9\u30eb\u30c0\u3092\u6307\u5b9a<\/td>\r\n<\/tr>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 21.8673%; border-color: #ffffff; height: 37px;\">\u3000myFileName<\/td>\r\n<td style=\"width: 78.0099%; border-color: #ffffff; height: 37px;\">\uff1a \uff13\u884c\u306e\u3046\u3061\u3001\u5148\u982d\u306b\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3(\u2018)\u304c\u5165\u3063\u3066\u3044\u308b\u884c\u304c\u7121\u52b9\u306b\u306a\u308b<\/td>\r\n<\/tr>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 21.8673%; border-color: #ffffff; height: 37px;\">\u3000Application.Wait<\/td>\r\n<td style=\"width: 78.0099%; border-color: #ffffff; height: 37px;\">\uff1a \u4e0a\u8a18\u4f8b\u3067\u306f\u81ea\u52d5\u5909\u63db\u4fdd\u5b58\u3068\u30d7\u30ed\u30b0\u30e9\u30e0\u7d42\u4e86\u306e\u9593\u306710\u79d2\u5f85\u305f\u305b\u3066\u3044\u308b<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>\u30b3\u30fc\u30c9\u306e\u8cbc\u4ed8\u3051\u7d42\u4e86\u5f8c\u3001[\u540d\u524d\u3092\u4ed8\u3051\u3066\u4fdd\u5b58]\u3092\u5b9f\u884c\u3057\u3001<br \/><span style=\"text-decoration: underline;\"><span style=\"background-color: #ffff99;\">[Excel \u30de\u30af\u30ed\u6709\u52b9\u30d6\u30c3\u30af(*.xlsm)]<\/span><\/span>\u3092\u9078\u629e\u3057\u3066\u4fdd\u5b58\u3059\u308b<br \/><img loading=\"lazy\" class=\"size-full wp-image-4574 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting5.gif\" alt=\"\" width=\"276\" height=\"139\" \/><\/p>\r\n<table style=\"border-collapse: collapse; width: 86.6179%; height: 20px;\">\r\n<tbody>\r\n<tr style=\"height: 20px;\">\r\n<td style=\"width: 100%; background-color: #e3f2fd; border-color: #e3f2fd; height: 107px;\">\r\n<p><span style=\"font-size: 14px;\">VBA\u8a2d\u5b9a\/\u4fdd\u5b58\u5f8c\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u3068<\/span><span style=\"font-size: 14px;\"><br \/>\u00a0\u81ea\u52d5\u7684\u306b\u30b3\u30fc\u30c9\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u304c\u3001<br \/>\u00a0\u8907\u6570\u306eExcel\u304c\u958b\u304b\u308c\u3066\u3044\u305f\u5834\u5408\u3001<br \/><\/span><span style=\"font-size: 14px;\"><span style=\"background-color: #ffff99;\">\u00a0\u5168\u3066\u306eExcel\u304c\u4fdd\u5b58\u3055\u308c\u306a\u3044\u307e\u307e\u3001<br \/>\u00a0\u5f37\u5236\u7d42\u4e86\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u00a0<\/span><br \/><br \/>\u00a0\u9014\u4e2d\u3067\u30de\u30af\u30ed\u3092\u30b9\u30c8\u30c3\u30d7\u3055\u305b\u308b\u5834\u5408\u3001<br \/>\u00a0[ CTRL ] + [ Pause ]\u3067\u30de\u30af\u30ed\u3092\u505c\u6b62\u3055\u305b\u3001<br \/>\u00a0[ \u30c7\u30d0\u30c3\u30b0 ]\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u4e2d\u65ad\u3055\u305b\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff14.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3067\u30013\u306eExcel\u3092\u81ea\u52d5\u3067\u958b\u304f\u8a2d\u5b9a\u3092\u884c\u3044\u3001CSV\u3092\u81ea\u52d5\u751f\u6210\u3055\u305b\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n[Windows\u306e\u30b9\u30bf\u30fc\u30c8]\uff0d[\u30d7\u30ed\u30b0\u30e9\u30e0\u4e00\u89a7\uff08W\u884c\uff09]\uff0d[Windows\u7ba1\u7406\u30c4\u30fc\u30eb]\uff0d[\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9]\u3092\u8d77\u52d5\u3057\u3001[\u64cd\u4f5c]\uff0d[\u30bf\u30b9\u30af\u306e\u4f5c\u6210]\u3067\u30c0\u30a4\u30a2\u30ed\u30b0\u3092\u958b\u304f<br \/><img loading=\"lazy\" class=\"size-full wp-image-4627 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting7.gif\" alt=\"\" width=\"819\" height=\"565\" \/><br \/><br \/><\/p>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 536px;\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 29.6069%; background-color: #f2f2f2; border-color: #f2f2f2; height: 37px; text-align: left;\"><span style=\"color: #0066cc; font-size: 16px;\"><strong>\u3000[\u5168\u822c]\u30bf\u30d6<\/strong><\/span><\/td>\r\n<td style=\"width: 70.3931%; background-color: #ffffff; border-color: #ffffff; height: 37px;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 499px;\">\r\n<td style=\"width: 100%; background-color: #f2f2f2; border-color: #f2f2f2; height: 499px;\" colspan=\"2\">\u540d\u524d\uff1a\u4f8b\uff09 SP-CSV\u5909\u63db<br \/><br \/>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30aa\u30d7\u30b7\u30e7\u30f3\uff1a\u300c\u30e6\u30fc\u30b6\u30fc\u304c\u30ed\u30b0\u30aa\u30f3\u3057\u3066\u3044\u308b\u3068\u304d\u306e\u307f\u5b9f\u884c\u3059\u308b\u300d<br \/><br \/><img loading=\"lazy\" class=\"size-full wp-image-4629 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting8.gif\" alt=\"\" width=\"536\" height=\"386\" \/><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 700px;\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 30.0982%; border-color: #f2f2f2; background-color: #f2f2f2; height: 37px; text-align: left;\"><span style=\"color: #0066cc;\"><strong>\u00a0\u3000<span style=\"font-size: 16px;\">[\u30c8\u30ea\u30ac\u30fc]\u30bf\u30d6\uff0d[\u65b0\u898f]<\/span><\/strong><\/span><\/td>\r\n<td style=\"width: 69.9018%; border-color: #fff; background-color: #fff; height: 37px;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 663px;\">\r\n<td style=\"width: 100%; border-color: #f2f2f2; background-color: #f2f2f2; height: 663px;\" colspan=\"2\">\u8a2d\u5b9a\uff1a\uff11\u56de<br \/><br \/>\u7e70\u308a\u8fd4\u3057\u9593\u9694\uff1a5\u5206\u9593\u306a\u3069\u4efb\u610f\u306e\u81ea\u52d5\u51e6\u7406\u9593\u9694\u3092\u9078\u629e<br \/>\u3000\u3000\u3000\u3000\u3000\u3000\u3000<span style=\"color: #ff0000;\">\u203b\u30c1\u30a7\u30c3\u30af\u6bb5\u968e\u3067\u306f5\u5206\u3092\u63a8\u5968<\/span><br \/><br \/>\u7d99\u7d9a\u6642\u9593\uff1a\u7121\u5236\u9650<br \/><img loading=\"lazy\" class=\"size-full wp-image-4645 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting9.gif\" alt=\"\" width=\"595\" height=\"510\" \/><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 47px;\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 30.0982%; border-color: #f2f2f2; background-color: #f2f2f2; height: 37px; text-align: left;\"><span style=\"color: #0066cc; font-size: 16px;\"><strong>\u3000[\u64cd\u4f5c]\u30bf\u30d6\uff0d[\u65b0\u898f]<\/strong><\/span><\/td>\r\n<td style=\"width: 69.9018%; border-color: #fff; background-color: #fff; height: 37px;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 50px;\">\r\n<td style=\"width: 100%; border-color: #f2f2f2; background-color: #f2f2f2; height: 10px;\" colspan=\"2\">\r\n<p>\u30d7\u30ed\u30b0\u30e9\u30e0\/\u30b9\u30af\u30ea\u30d7\u30c8\uff1a[\u53c2\u7167]\u30dc\u30bf\u30f3\u3067EXCEL.EXE\u3092\u63a2\u3057\u3066\u9078\u629e<br \/><br \/>\u4f8b\uff1a<span style=\"color: #ff0000;\">&#8220;<\/span>C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE<span style=\"color: #ff0000;\">&#8220;<\/span><br \/><span style=\"color: #ff0000;\">\u203b \u6587\u5b57\u5217\u306e\u524d\u5f8c\u306b\u300c&#8221;\u300d\u3092\u5165\u308c\u3001\u4e0a\u8a18\u3068\u540c\u3058\u3088\u3046\u306a\u72b6\u614b\u306b\u3059\u308b<\/span><\/p>\r\n<p>\u5f15\u6570\u306e\u8ffd\u52a0\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\uff1aSP-CSV.xlsm\u30d5\u30a1\u30a4\u30eb\u306e\u914d\u7f6e\u5834\u6240\u3000\uff0b\u3000\/e\u3000\u3092\u8a18\u8f09<br \/><span style=\"color: #ff0000;\">\u203b \u4f8b\uff09C:\\Documents\\csv\\sp-csv.xlsm \/e<\/span><br \/><span style=\"color: #ff0000;\">\u203b\u300c\/e\u300d\u306e\u524d\u306b\u3001\u5fc5\u305a\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u5165\u308c\u3066\u4e0b\u3055\u3044<\/span><\/p>\r\n<p>\u7e70\u308a\u8fd4\u3057\u9593\u9694\uff1a5\u5206\u9593\u306a\u3069\u4efb\u610f\u306e\u81ea\u52d5\u51e6\u7406\u9593\u9694\u3092\u9078\u629e<br \/>\u3000\u3000\u3000\u3000\u3000\u3000\u3000<span style=\"color: #ff0000;\">\u203b\u30c1\u30a7\u30c3\u30af\u6bb5\u968e\u3067\u306f5\u5206\u3092\u63a8\u5968<\/span><\/p>\r\n<p>\u7d99\u7d9a\u6642\u9593\uff1a\u7121\u5236\u9650<\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff15.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">FFFTP\u304b\u3089Sales Performer\u306eFTP\u30b5\u30fc\u30d0\u30fc\u306b\u30df\u30e9\u30fc\u30ea\u30f3\u30b0\u3055\u305b\u308b\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><span style=\"color: #000000; background-color: #ffff99;\"><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2460\u30d5\u30ea\u30fc\u30bd\u30d5\u30c8\u300cFFFTP\u300d\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u00a0<\/span><\/strong><\/span><br \/><a href=\"https:\/\/forest.watch.impress.co.jp\/library\/software\/ffftp\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/forest.watch.impress.co.jp\/library\/software\/ffftp\/<\/a><br \/><br \/><span style=\"color: #000000; background-color: #ffff99;\"><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2461FFFTP\u306e\u8a2d\u5b9a <\/span><\/strong><\/span><br \/>[\u30db\u30b9\u30c8\u4e00\u89a7]\u3067[\u65b0\u898f\u30db\u30b9\u30c8]\u3092\u9078\u629e<br \/><img loading=\"lazy\" class=\"size-full wp-image-4646 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting10.gif\" alt=\"\" width=\"769\" height=\"502\" \/><br \/><br \/>\u4e0b\u8a18\u306e\u8a2d\u5b9a\u3092\u884c\u3046<br \/><br \/>\u2460\u30db\u30b9\u30c8\u306e\u8a2d\u5b9a\u540d\u3000\u3000\u3000\u3000\uff1a\u4efb\u610f\u540d\u79f0\u3067OK\u3067\u3059\u304c\u3001\u30a2\u30ab\u30a6\u30f3\u30c8\u540d\u306b\u3059\u308b\u3068\u308f\u304b\u308a\u3084\u3059\u3044<br \/>\u2461\u30db\u30b9\u30c8\u540d\uff08\u30a2\u30c9\u30ec\u30b9\uff09\u3000\uff1aSales Performer[\u30c7\u30fc\u30bf\u9023\u52d5\u8a2d\u5b9a]-[FTP\u30b5\u30fc\u30d0\u30fc]\u306b\u8a18\u8f09\u306e\u30a2\u30c9\u30ec\u30b9<br \/>\u2462\u30e6\u30fc\u30b6\u30fc\u540d\u3000\u3000\u3000\u3000\u3000\u3000\uff1aSales Performer[\u30c7\u30fc\u30bf\u9023\u52d5\u8a2d\u5b9a]-[FTP\u30b5\u30fc\u30d0\u30fcID PW]\u306b\u8a18\u8f09\u306eID<br \/>\u2463\u30d1\u30b9\u30ef\u30fc\u30c9\u3000\u3000\u3000\u3000\u3000\u3000\uff1aSales Performer[\u30c7\u30fc\u30bf\u9023\u52d5\u8a2d\u5b9a]-[FTP\u30b5\u30fc\u30d0\u30fcID PW]\u306b\u8a18\u8f09\u306ePW<br \/>\u2464\u30ed\u30fc\u30ab\u30eb\u306e\u521d\u671f\u30d5\u30a9\u30eb\u30c0\uff1aVisual Basic \u30b3\u30fc\u30c9\u3067\u6307\u5b9a\u3057\u305f\u3001CSV\u5909\u63db\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30a9\u30eb\u30c0<br \/>\u2465[\u6697\u53f7\u5316\u30bf\u30d6]\uff0d[FTPS(Explicit)\u3067\u63a5\u7d9a]\u306e\u307f\u9078\u629e<br \/><span style=\"color: #ff0000;\">\u3000\u203b\u30c7\u30fc\u30bf\u3092\u6697\u53f7\u5316\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u64cd\u4f5c\u3067\u3059<\/span><\/p>\r\n<table style=\"border-collapse: collapse; width: 100%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 50%; border-color: #ffffff;\"><img loading=\"lazy\" class=\"size-full wp-image-4656 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting11.gif\" alt=\"\" width=\"387\" height=\"356\" \/><\/td>\r\n<td style=\"width: 50%; border-color: #ffffff;\"><img loading=\"lazy\" class=\"size-full wp-image-4657 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting12.gif\" alt=\"\" width=\"397\" height=\"364\" \/><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><span style=\"color: #000000; background-color: #ffff99;\"><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2463\u63a5\u7d9a\u30c6\u30b9\u30c8\u00a0<\/span><\/strong><\/span><br \/>\u30db\u30b9\u30c8\u4e00\u89a7\u304b\u3089\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f\u30db\u30b9\u30c8\u540d\u3092\u9078\u629e\u3057[\u63a5\u7d9a]\u3092\u30af\u30ea\u30c3\u30af<br \/>\u300c\u30d5\u30a1\u30a4\u30eb\u4e00\u89a7\u306e\u53d6\u5f97\u306f\u6b63\u5e38\u7d42\u4e86\u3057\u307e\u3057\u305f\u300d\u3068\u8868\u793a\u3055\u308c\u308c\u3070\u6b63\u5e38\u63a5\u7d9aOK<br \/><img loading=\"lazy\" class=\"size-full wp-image-4660 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting13.gif\" alt=\"\" width=\"408\" height=\"294\" \/><br \/><br \/><br \/><span style=\"color: #000000; background-color: #ffff99;\"><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2464\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30a2\u30a4\u30b3\u30f3\u4f5c\u6210\u00a0<\/span><\/strong><\/span><br \/>\u30d5\u30ea\u30fc\u30bd\u30d5\u30c8\u300cFFFTP\u300d\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30a2\u30a4\u30b3\u30f3\u306e\u4f5c\u6210\u5f8c\u3001<br \/>\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u30ea\u30f3\u30af\u5148\u3092\u4e0b\u8a18\u3078\u5909\u66f4\u3059\u308b<br \/><br \/>&#8220;C:\\Program Files (x86)\\ffftp\\ffftp.exe&#8221; <span style=\"color: #ff0000;\">-s &#8220;17sp0&#8221; -f -q -m<\/span><br \/>\u203b\u4e0a\u8a18\u8d64\u6587\u5b57\uff08\u300c-s\u300d\u306e\u524d\u306b\u3042\u308b\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3082\u542b\u3080\uff09\u3092\u8ffd\u8a18\u3057\u307e\u3059<br \/><img loading=\"lazy\" class=\"size-full wp-image-4665 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting14.gif\" alt=\"\" width=\"417\" height=\"576\" \/><\/p>\r\n<p><br \/><br \/><span style=\"color: #000000; background-color: #ffff99;\"><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2465\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308b <\/span><\/strong><\/span><br \/>Windows\u306e\u30e1\u30e2\u5e33\u3092\u958b\u304d\u3001\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092\u8a18\u8f09\u3057\u305f\u5f8c\u3001<br \/>\u30d5\u30a1\u30a4\u30eb\u540d\u300cexcel2csv.bat\u300d\u3067\u4fdd\u5b58\u3059\u308b<\/p>\r\n\r\n\r\n\r\n<p><span style=\"background-color: #ffcc00;\">call C:************************ \\FFFTP.lnk<\/span><\/p>\r\n<p><span style=\"background-color: #ffcc00;\">start \/w C:************************ \\FFFTP.lnk<\/span><\/p>\r\n\r\n<p>\u203b\u300ccall C:************************ \\FFFTP.lnk\u300d\u306f\u3001\u4e0a\u8a18\u3067\u4f5c\u6210\u3057\u305f\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30a2\u30a4\u30b3\u30f3\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u3092\u8a2d\u5b9a\u3059\u308b<br \/><br \/><\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff16.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3067\u3001FFFTP\u306e\u30d0\u30c3\u30c1\u3092\u5b9f\u884c\u3055\u305b\u3001FTP\u9023\u643a\u3092\u884c\u3046<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><img loading=\"lazy\" class=\"size-full wp-image-4675 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting15.gif\" alt=\"\" width=\"476\" height=\"517\" \/><br \/><br \/><br \/>\u300c\uff14.Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3067\u30013\u306eExcel\u3092\u81ea\u52d5\u3067\u958b\u304f\u8a2d\u5b9a\u3092\u884c\u3044\u3001CSV\u3092\u81ea\u52d5\u751f\u6210\u3055\u305b\u308b\u300d\u3068\u540c\u69d8\u3001\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3092\u8a2d\u5b9a\u3059\u308b<br \/>\u203bSales Performer\u306e\u300c\u5916\u90e8\u9023\u643a\u8a2d\u5b9a\u300d\u3067\u3001\u30c7\u30fc\u30bf\u9023\u52d5\u9593\u9694\u3092\uff15\u5206\u304a\u304d\u306b\u8a2d\u5b9a\u3057\u305f\u5834\u5408\u3001\u300c10\u664205\u5206\u300111\u664215\u5206\u300d\u306a\u3069\u3001<span style=\"text-decoration: underline;\"><span style=\"color: #ff0000; text-decoration: underline;\">5(\u5206)\u306e\u500d\u6570\u3067\u8d77\u52d5<\/span><\/span>\u3059\u308b\u3088\u3046\u306b\u8a2d\u5b9a<\/p>\r\n<table style=\"border-collapse: collapse; width: 88.3671%; height: 107px;\">\r\n<tbody>\r\n<tr style=\"height: 20px;\">\r\n<td style=\"width: 100%; background-color: #e3f2fd; border-color: #e3f2fd; height: 107px;\">\r\n<p>\u300c\u64cd\u4f5c\u30bf\u30d6\u300d\u306e\u307f\u3001\u4e0a\u8a18\u753b\u50cf\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3092\u884c\u3046<\/p>\r\n<p>\u30d7\u30ed\u30b0\u30e9\u30e0\/\u30b9\u30af\u30ea\u30d7\u30c8\uff1abat\u30d5\u30a1\u30a4\u30eb\u306e\u914d\u7f6e\u5834\u6240<br \/><span style=\"text-decoration: underline;\">\u203bbat\u30d5\u30a1\u30a4\u30eb\u306b\u95a2\u3057\u3066\u306f\u3001 \u6587\u5b57\u5217\u524d\u5f8c\u306e\u300c&#8221;\u300d\u306f\u4e0d\u8981<\/span><\/p>\r\n<p>\u958b\u59cb(\u30aa\u30d7\u30b7\u30e7\u30f3)\uff1a\u4e0a\u8a18bat\u30d5\u30a1\u30a4\u30eb\u306e<strong>\u300c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u300d<\/strong>\u3092\u5165\u529b<br \/>\u203b\u4f8b(\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u306b\u3042\u308b\u5834\u5408)\uff1aC:\\Users\\PC\u306e\u30e6\u30fc\u30b6\u30fc\u540d\\Desktop<\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff17.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">Excel\u3068Sales Performer\u304c\u81ea\u52d5\u9023\u643a\u3055\u308c\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>\u5ff5\u306e\u305f\u3081\u3001\u5404\u7a2e\u30b0\u30e9\u30d5\u753b\u9762\u3084\u3001Sales Performer\u306e\uff3b\u8a2d\u5b9a\uff3d\uff0d\uff3b\u64cd\u4f5c\u30ed\u30b0\uff3d\u3067\u9023\u643a\u52d5\u4f5c\u304c\u53cd\u6620\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<div id=\"contents\" style=\"text-align: center;\">\r\n<h2 style=\"text-align: left;\">[\u30e1\u30fc\u30eb\u9023\u52d5]Excel\u81ea\u52d5\u9023\u643a<\/h2>\r\n<p style=\"text-align: center;\"><span style=\"font-size: 18px; color: #0066cc;\"><strong>\u624b\u9806\u6982\u8981<\/strong><\/span><\/p>\r\n<table style=\"border-collapse: collapse; width: 101.166%; height: 50px;\">\r\n<tbody>\r\n<tr style=\"height: 86px;\">\r\n<td style=\"width: 100%; height: 50px; background-color: #f8f8f8; text-align: left;\"><br \/>\r\n<ol>\r\n<li><span style=\"font-size: 14px;\"><span style=\"color: #ff0000;\">\u9023\u643a\u5bfe\u8c61Excel<\/span>\u306b\u65b0\u898f\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3001Excel\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">CSV\u9023\u52d5\u7528\u306eGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u65b0\u898f\u4f5c\u6210\u3059\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\"><img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"15\" height=\"15\" \/>\u30c9\u30e9\u30a4\u30d6\u5185\u306b\u9023\u643a\u7528\u30d5\u30a9\u30eb\u30c0\u3092\u4f5c\u6210\u3059\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\"><img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"15\" height=\"15\" \/>\u30c9\u30e9\u30a4\u30d6\u306ePC\u7248\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\"><span style=\"color: #000000;\">SEVENTEEN\u63d0\u4f9b\u306eE<\/span>xcel\u30de\u30af\u30ed<span style=\"color: #ff0000;\">\u300cExcel\u9023\u52d5.xlsm\u300d<\/span>\u3092\u7de8\u96c6\u3059\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3092\u4f7f\u7528\u3057\u3001Excel\u30de\u30af\u30ed\u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u6307\u5b9a\u306e\u6642\u9593\u9593\u9694\u3067\u5b9f\u884c\u3055\u305b\u308b<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">\u4e0a\u8a18\u300c2\u300d\u3067\u7528\u610f\u3057\u305fGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u300cApps Script\u300d\u8a2d\u5b9a\u3092\u884c\u3046<\/span><\/li>\r\n<li><span style=\"font-size: 14px;\">Excel\u3068Sales Performer\u304c\u81ea\u52d5\u9023\u643a\u3055\u308c\u308b<\/span><\/li>\r\n<\/ol>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<span style=\"color: #0066cc;\"><strong><span style=\"font-size: 18px;\"><br \/>\u5404\u624b\u9806\u8a73\u7d30\u8aac\u660e<br \/><br \/><\/span><\/strong><\/span><\/div>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff11.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\u9023\u643a\u5bfe\u8c61Excel\u306b\u65b0\u898f\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3001<\/span><br \/><span style=\"font-size: 18px; color: #0066cc;\">Excel\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><span style=\"font-size: 14px;\">Excel\u95a2\u6570\u300cSUMIF\u300d\u300cCOUTIF\u300d\u306a\u3069\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3001<br \/><span style=\"text-align: center;\">\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u300c\u6708\u6b21\u300d\u300c\u65e5\u6b21\u300d\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b<br \/><span style=\"color: #ff0000;\">\u203b\u65e2\u306b\u4f5c\u6210\u3055\u308c\u3066\u3044\u308c\u3070\u4e0d\u8981<\/span><\/span><\/span><\/p>\r\n<table style=\"border-collapse: collapse; width: 88.3671%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 100%; background-color: #e3f2fd; border-color: #e3f2fd;\"><span style=\"font-size: 14px;\">\u95a2\u6570\u8a08\u7b97\u3092\u4f7f\u3063\u305f\u96c6\u8a08\u306f\u3001\u3053\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3067<span style=\"text-decoration: underline;\">\u5b8c\u7d50<\/span>\u3057\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308b<br \/><br \/><\/span><span style=\"font-size: 14px;\">\u5f8c\u306b\u8ee2\u8a18\u3055\u305b\u308bCSV\u5909\u63db\u7528\u306e<span style=\"color: #0b559d;\"><strong>\u300c CSV\u30a4\u30f3\u30dd\u30fc\u30c8.xlsm \u300d<\/strong><\/span>\u3067\u306f\u3001<br \/>\u96c6\u8a08\u7d50\u679c\u306e\u30bb\u30eb\uff08\u5024\uff09\u3092<\/span><strong><span style=\"font-size: 14px;\">\u300c<span style=\"text-decoration: underline;\">=(\u30a4\u30b3\u30fc\u30eb)\u300d\u3067\u7d10\u4ed8\u3051\u8868\u793a\u3055\u305b\u308b\u305f\u3081<\/span><\/span><\/strong><span style=\"font-size: 14px;\"><br \/><br \/>\u203b\u5f8c\u306b\u4f5c\u6210\u3059\u308bCSV\u306e\u751f\u6210\u6642\u306b\u9023\u643a\u5bfe\u8c61Excel\u304c\u7acb\u3061\u4e0a\u304c\u3063\u3066\u306a\u3044\u3068\u3001<br \/><\/span><span style=\"font-size: 14px;\">\u3000<strong><span style=\"text-decoration: underline;\">\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u3057\u307e\u3046<\/span><\/strong><\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 88.2882%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff12.<\/span><\/td>\r\n<td style=\"width: 86.4612%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">CSV\u9023\u52d5\u7528\u306eGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u65b0\u898f\u4f5c\u6210\u3059\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><span style=\"color: #000000;\">\u4f5c\u6210\u5f8c\u3001\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\/Password\u3092\u5931\u5ff5\u3057\u306a\u3044\u3088\u3046\u3001<\/span><span style=\"color: #000000;\">\u30e1\u30e2\u5e33\u306a\u3069\u3067\u4fdd\u5b58\u3059\u308b<br \/><\/span>\u65e2\u306b\u53d6\u5f97\u3055\u308c\u3066\u3044\u308b\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3082\u554f\u984c\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068\u306e\u9023\u643a\u3092\u3054\u5e0c\u671b\u306e\u5834\u5408\u3001\u4f5c\u6210\u3057\u305fGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u306e\u8a2d\u5b9a\u64cd\u4f5c\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059<\/p>\r\n<p>\u203b\u65b0\u898f\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210\u65b9\u6cd5\u306f<a href=\"https:\/\/www.google.com\/search?q=Google%E3%82%A2%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88+%E6%96%B0%E8%A6%8F%E4%BD%9C%E6%88%90\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a>\u3092\u3054\u89a7\u304f\u3060\u3055\u3044<\/p>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 88.542%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">3.<\/span><\/td>\r\n<td style=\"width: 86.7152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\"><img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"35\" height=\"35\" \/> \u30c9\u30e9\u30a4\u30d6\u5185\u306b\u9023\u643a\u7528\u30d5\u30a9\u30eb\u30c0\u3092\u4f5c\u6210\u3059\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"20\" height=\"20\" \/>\u30c9\u30e9\u30a4\u30d6\u300c\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\u300d\u3067\u3001\u9023\u643a\u7528\u30d5\u30a9\u30eb\u30c0\u3092\u4f5c\u6210\u3059\u308b<br \/>\u203b\u53f3\u30af\u30ea\u30c3\u30af\u300c\u65b0\u3057\u3044\u30d5\u30a9\u30eb\u30c0\u30fc\u65b0\u3057\u3044\u30d5\u30a9\u30eb\u30c0\u306e\u540d\u524d\u4f5c\u6210\u300d\u3067\u4f5c\u6210\u53ef\u80fd\u3067\u3059<\/p>\r\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-10626\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-01.jpg\" alt=\"\" width=\"500\" height=\"235\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-01.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-01-300x141.jpg 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">4.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\"><img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"35\" height=\"35\" \/> \u30c9\u30e9\u30a4\u30d6\u306ePC\u7248\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>\u4e0b\u8a18\u306e\u624b\u9806\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u884c\u3046<\/p>\r\n<table style=\"border-collapse: collapse; width: 100%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 100%; background-color: #f2f2f2;\"><span style=\"font-size: 14px;\">[\uff11]\u00a0 <img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"18\" height=\"18\" \/>\u30c9\u30e9\u30a4\u30d6\u3092\u958b\u304f<\/span><br \/><span style=\"font-size: 14px;\">[\uff12]\u00a0 \u8a2d\u5b9a\u30af\u30ea\u30c3\u30af<\/span><br \/><span style=\"font-size: 14px;\">[\uff13]\u00a0 \u30d1\u30bd\u30b3\u30f3\u7248 <img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"18\" height=\"18\" \/>\u30c9\u30e9\u30a4\u30d6\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span><br \/><span style=\"font-size: 14px;\">[\uff14]\u00a0 \u5225\u30bf\u30d6\u3067\u753b\u9762\u8868\u793a<\/span><br \/><span style=\"font-size: 14px;\">[\uff15]\u300c\u30d1\u30bd\u30b3\u30f3\u7248\u30c9\u30e9\u30a4\u30d6\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u3092\u30af\u30ea\u30c3\u30af<\/span><br \/><span style=\"font-size: 14px;\">[\uff16]\u300cGoogleDriveSetup.exe\u300d\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u308b<\/span><br \/><span style=\"font-size: 14px;\">[\uff17]\u00a0 \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u5b8c\u4e86\u5f8c\u3001\u300c\u958b\u304f\u300d\u3092\u9078\u629e<\/span><br \/><span style=\"font-size: 14px;\">[\uff18]\u00a0 \u3053\u306e\u30a2\u30d7\u30ea\u304c\u30c7\u30d0\u30a4\u30b9\u306b\u5909\u66f4\u3092\u52a0\u3048\u308b\u3053\u3068\u3092\u8a31\u53ef\u3057\u307e\u3059\u304b\uff1f\u2192\u300c\u306f\u3044\u300d\u3092\u9078\u629e<\/span><br \/><span style=\"font-size: 14px;\">[\uff19]\u00a0 \u30c9\u30e9\u30a4\u30d6\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u304b\uff1f\u2192\u300c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u300d\u3092\u9078\u629e<\/span><br \/><span style=\"font-size: 14px;\">[10]\u300c\u30d6\u30e9\u30a6\u30b6\u300d\u3067\u30ed\u30b0\u30a4\u30f3\u3092\u30af\u30ea\u30c3\u30af<\/span><br \/><span style=\"font-size: 14px;\">[11]\u00a0 CSV\u9023\u52d5\u7528\u306eGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u9078\u629e\u3057\u3066\u30ed\u30b0\u30a4\u30f3<strong><span style=\"color: #ff0000;\">\u203b\u8a2d\u5b9a\u5f8c\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u5909\u66f4\u306f\u4e0d\u53ef<\/span><\/strong><\/span><br \/><span style=\"font-size: 14px;\">[12]\u300cGoogle Docs\u300d\u300cGoogle Sheets\u300d\u300cGoogle Sides\u300d\u304c\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u8868\u793a\u3055\u308c\u308b\uff08\u524a\u9664\u53ef\uff09<\/span><br \/><span style=\"font-size: 14px;\">[13]\u00a0 PC\u4e0a\u306b\u3042\u308b\u9069\u5f53\u306a\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u304f\uff08\u3069\u306e\u30d5\u30a9\u30eb\u30c0\u3067\u3082\u53ef\uff09<\/span><br \/><span style=\"font-size: 14px;\">[14]\u00a0 \u30d5\u30a9\u30eb\u30c0\u753b\u9762\u5de6\u306e\u30b5\u30a4\u30c9\u30d1\u30cd\u30eb\u304b\u3089\u300cPC\u300d\u3092\u9078\u629e<\/span><br \/><span style=\"font-size: 14px;\">[15]\u300c\u30c7\u30d0\u30a4\u30b9\u3068\u30c9\u30e9\u30a4\u30d6\uff0dGoogle Drive(G:)\u300d\u3092\u9078\u629e<\/span><br \/><span style=\"font-size: 14px;\">[16]\u00a0 \u30a2\u30a4\u30b3\u30f3\u300c\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\u300d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3092\u4f5c\u6210(S)\u300d\u3092\u9078\u629e<\/span><br \/><span style=\"font-size: 14px;\">[17]\u00a0 \u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u306b\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30a2\u30a4\u30b3\u30f3\u3092\u4f5c\u6210\u3059\u308b\u2192\u64cd\u4f5c\u5b8c\u4e86<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff15.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">SEVENTEEN\u63d0\u4f9b\u306eExcel\u30de\u30af\u30ed\u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u7de8\u96c6\u3059\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2460 Excel\u30de\u30af\u30ed\u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u53d6\u5f97\u3059\u308b\u00a0<\/span><\/strong><\/p>\r\n<div id=\"contents\">\r\n<h3>Excel\u30de\u30af\u30ed\u306e\u63d0\u4f9b\u3092\u3054\u5e0c\u671b\u306e\u5834\u5408\u306f\u3001\u304a\u6c17\u8efd\u306b\u5f0a\u793e\u307e\u3067\u304a\u554f\u3044\u5408\u305b\u304f\u3060\u3055\u3044\u3002<br \/><br \/>TEL 0120-958-172 (\u5e73\u65e59:00\uff5e18:00)<\/h3>\r\n<\/div>\r\n<p><br \/><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2461 Shift\u30ad\u30fc\u3092\u4f7f\u7528\u3057\u3066\u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u7acb\u3061\u4e0a\u3052\u308b\u00a0<\/span><\/strong><br \/><br \/>\u3053\u306eExcel\u30de\u30af\u30ed\u306f\u3001\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3067\u958b\u304f\u3068\u7de8\u96c6\u4f5c\u696d\u304c\u3067\u304d\u306a\u3044\u70ba\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u64cd\u4f5c\u3059\u308b<\/p>\r\n<ol>\r\n<li>Windows\u30b9\u30bf\u30fc\u30c8\u30dc\u30bf\u30f3\u7b49\u304b\u3089\u65b0\u898fExcel\u3092\u7acb\u3061\u4e0a\u3052\u308b<\/li>\r\n<li>Excel\u753b\u9762\u5de6\u4e0a\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u300c\u958b\u304f\u300d\u3092\u30af\u30ea\u30c3\u30af<\/li>\r\n<li>\u753b\u9762\u4e2d\u592e\u90e8\u306b\u8868\u793a\u3055\u308c\u305f\u9805\u76ee\u300c\u53c2\u7167\u300d\u3092\u30af\u30ea\u30c3\u30af<\/li>\r\n<li>\u5148\u307b\u3069\u4fdd\u5b58\u3057\u305f\u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u4e00\u5ea6\u30af\u30ea\u30c3\u30af\u3057\u3001<br \/>\u30d5\u30a1\u30a4\u30eb\u5168\u4f53\u306b\u8272\u304c\u4ed8\u3044\u305f\u3089\u3001Shift\u30ad\u30fc\u3092\u62bc\u3057\u306a\u304c\u3089\u958b\u304f\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af<\/li>\r\n<\/ol>\r\n<p><img loading=\"lazy\" class=\"size-full wp-image-4726 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting17.gif\" alt=\"\" width=\"1277\" height=\"334\" \/><\/p>\r\n<p>&nbsp;<\/p>\r\n<p><strong><span style=\"font-size: 18px; background-color: #ffff99;\">\u2462 \u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u7de8\u96c6\u3057\u3001\u30de\u30af\u30ed\u52d5\u4f5c\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b<\/span><\/strong><br \/><br \/><span style=\"font-size: 18px;\"><strong>\uff65\u300c\u96c6\u8a08\u300d\u30b7\u30fc\u30c8\u306e\u7de8\u96c6<\/strong><\/span><br \/>\u300cJ\u5217\u300d\u300cK\u5217\u300d\u306b\u3001Sales Performer\u306e\u300c\u30e1\u30f3\u30d0\u30fc\u8a2d\u5b9a\u300d\u3067\u767b\u9332\u3057\u305f\u30e1\u30f3\u30d0\u30fc\u540d\u3068No.\u3092\u5165\u529b\u3059\u308b<br \/><br \/>\u305d\u306e\u5f8c\u3001\u300c1.\u9023\u643a\u5bfe\u8c61Excel\u306b\u65b0\u898f\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3001Excel\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30e1\u30f3\u30d0\u30fc\u5404\u81ea\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u300d\u3067\u65b0\u898f\u4f5c\u6210\u3057\u305f\u30b7\u30fc\u30c8\u60c5\u5831\u3092\u6d3b\u7528\u3057\u3001\u300cB\u5217\uff5eH\u5217\u300d\u307e\u3067\u306e\u5404\u6240\u30bb\u30eb\uff08\u5024\uff09\u3092\u300c=(\u30a4\u30b3\u30fc\u30eb)\u300d\u3067\u7d10\u4ed8\u3051\u8868\u793a\u3055\u305b\u308b<br \/><img loading=\"lazy\" class=\"size-full wp-image-4742 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting18.gif\" alt=\"\" width=\"769\" height=\"607\" \/><br \/><strong><span style=\"color: #ff0000;\">\u203bA\u5217\u306f\u30e1\u30f3\u30d0\u30fcNo\u304c\u81ea\u52d5\u3067\u8868\u793a\u3055\u308c\u308b\u305f\u3081\u3001\u7de8\u96c6\u306f\u4e0d\u8981<\/span><\/strong><\/p>\r\n<p>&nbsp;<\/p>\r\n<p><strong><span style=\"font-size: 18px;\">\uff65\u300cCSV\u300d\u30b7\u30fc\u30c8\u306e\u7de8\u96c6<\/span><\/strong><br \/>\u300cA\u5217\uff5eH\u5217\u300d\u306e1001\u884c\u76ee\u307e\u3067\u3001\u300c\u96c6\u8a08\u300d\u30b7\u30fc\u30c8\u306e\u30bb\u30eb\u3068\u7d10\u4ed8\u3051\uff08\u5024\u304c\u7121\u3044\u5834\u5408\u306f\u7a7a\u6b04\u8868\u793a\u3055\u305b\u308bExcel\u95a2\u6570\u3092\u4f7f\u7528\uff09\u3092\u884c\u3046<\/p>\r\n<p><br \/><img loading=\"lazy\" class=\"size-full wp-image-4748 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting19.gif\" alt=\"\" width=\"769\" height=\"607\" \/><br \/><br \/><br \/><span style=\"font-size: 18px;\"><strong>\uff65\u300cVBA(\u30de\u30af\u30ed)\u300d\u306e\u7de8\u96c6<\/strong><\/span><\/p>\r\n<p>Excel\u30de\u30af\u30ed\u3092\u5229\u7528\u3067\u304d\u308b\u72b6\u614b\u306b\u3059\u308b\u305f\u3081\u3001\u4e0b\u8a18\u306e\u64cd\u4f5c\u3092\u884c\u3046<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.166%; height: 50px;\">\r\n<tbody>\r\n<tr style=\"height: 86px;\">\r\n<td style=\"width: 100%; height: 50px; background-color: #f8f8f8; text-align: left;\"><br \/>\r\n<ol>\r\n<li>[Excel]\uff0d[\u958b\u767a]\uff0d[\u30de\u30af\u30ed\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3]\u3092\u958b\u304d\u3001[\u3059\u3079\u3066\u306e\u30de\u30af\u30ed\u3092\u6709\u52b9\u306b\u3059\u308b]\u3092\u9078\u629e\u3057\u3001[OK]\u3092\u62bc\u3059<br \/><br \/><img loading=\"lazy\" class=\"wp-image-4760 size-full alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting20.gif\" alt=\"\" width=\"2246\" height=\"904\" \/><br \/><br \/><br \/><\/li>\r\n<li>[\u958b\u767a]\uff0d[\u30de\u30af\u30ed\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3]\u3092\u958b\u304d\u3001[\u3059\u3079\u3066\u306e\u30de\u30af\u30ed\u3092\u6709\u52b9\u306b\u3059\u308b]\u3092\u9078\u3073\u3001\u300cOK\u300d\u3092\u62bc\u3059<br \/><br \/><img loading=\"lazy\" class=\"size-full wp-image-4762 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting21.gif\" alt=\"\" width=\"1874\" height=\"532\" \/><br \/><br \/>\u3000<\/li>\r\n<li>\u300c\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u6709\u52b9\u5316\u300d\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u305b\u306a\u3044\u3088\u3046\u306b\u3059\u308b<br \/><br \/>\u30d5\u30a1\u30a4\u30eb \u21d2 \u30aa\u30d7\u30b7\u30e7\u30f3 \u21d2\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30bb\u30f3\u30bf\u30fc\u3092\u958b\u304d\u3001\u300c\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30bb\u30f3\u30bf\u30fc\u306e\u8a2d\u5b9a\u300d\u3092\u62bc\u3059<br \/><img loading=\"lazy\" class=\"size-full wp-image-4771 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting22.gif\" alt=\"\" width=\"750\" height=\"323\" \/><br \/><br \/><br \/>\u305d\u306e\u5f8c\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u30d0\u30fc\u306e\u300c\u30d6\u30ed\u30c3\u30af\u3055\u308c\u305f\u5185\u5bb9\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u8868\u793a\u3057\u306a\u3044\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u300cOK\u300d\u3092\u62bc\u3059<br \/><img loading=\"lazy\" class=\"size-full wp-image-4773 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting23.gif\" alt=\"\" width=\"800\" height=\"356\" \/><br \/><br \/><br \/><\/li>\r\n<li>\u5916\u90e8\u30b3\u30f3\u30c6\u30f3\u30c4\uff0d\u3059\u3079\u3066\u306e\u30d6\u30c3\u30af\u30ea\u30f3\u30af\u306e\u81ea\u52d5\u66f4\u65b0\u3092\u6709\u52b9\u306b\u3059\u308b\uff08\u63a8\u5968\u3057\u307e\u305b\u3093\uff09\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u300cOK\u300d\u3092\u62bc\u3059<img loading=\"lazy\" class=\"size-full wp-image-4774 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting24.gif\" alt=\"\" width=\"1179\" height=\"626\" \/><br \/><br \/><\/li>\r\n<\/ol>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<hr \/>\r\n<p><br \/>\u4e0a\u8a18\u306e\u64cd\u4f5c\u3067VBA(\u30de\u30af\u30ed)\u304c\u4f7f\u7528\u3067\u304d\u308b\u72b6\u614b\u306b\u306a\u3063\u305f\u70ba\u3001VBA\u306e\u8a2d\u5b9a\u3092\u884c\u3046<br \/><br \/><\/p>\r\n<hr \/>\r\n<p><span style=\"font-size: 18px;\"><strong>\u30fb[\u958b\u767a\u30bf\u30d6]\uff0d[Visual Basic] \uff0d[\u30c4\u30fc\u30eb\u30bf\u30d6]\uff0d[\u53c2\u7167\u8a2d\u5b9a\uff3d\u304b\u3089\u3001\u4ee5\u4e0b4\u70b9\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001\u300cOK\u300d\u3092\u62bc\u3059<span style=\"background-color: #ffff99;\"><br \/><\/span><\/strong><\/span><br \/><img loading=\"lazy\" class=\"size-full wp-image-4775 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting25.gif\" alt=\"\" width=\"1241\" height=\"444\" \/><\/p>\r\n<hr \/>\r\n<p><span style=\"font-size: 18px;\"><strong>\u30fbCSV\u306e\u81ea\u52d5\u4fdd\u5b58\u5148\u3092<img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"20\" height=\"20\" \/>\u30c9\u30e9\u30a4\u30d6\u306e\u9023\u643a\u7528\u30d5\u30a9\u30eb\u30c0\u306b\u6307\u5b9a\u3059\u308b<br \/><\/strong><\/span>[\u958b\u767a\u30bf\u30d6]\uff0d[Visual Basic]\uff0d[ThisWorkbook]\u3092\u958b\u304d\u3001\u4ee5\u4e0b\u306e\u2605\u5370\u306e\u4e2d\u3092\u7de8\u96c6\u3059\u308b<br \/><img loading=\"lazy\" class=\"size-full wp-image-4776 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting26.gif\" alt=\"\" width=\"1269\" height=\"554\" \/><\/p>\r\n<p>\u2605\u5370\u306e\u4e2d\u306f\u3001\u4e0b\u8a18\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u3092\u5165\u529b\u3059\u308b<\/p>\r\n<p><span style=\"color: #ff0000;\"><strong>I:\\\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\\&#8221;\u30d5\u30a9\u30eb\u30c0\u540d\u79f0&#8221;<br \/><\/strong><\/span><span style=\"font-size: 12px;\">\u4f8b\uff1aI:\\\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\\\u30bb\u30fc\u30eb\u30b9\u30d1\u30d5\u30a9\u30fc\u30de\u30fc\u9023\u643a<\/span><\/p>\r\n<p><span style=\"font-size: 12px;\">\u203b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u306e\u8a9e\u5c3e\u306b\u300c\\\u300d\u3092\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044<br \/>\u203b\u4e0a\u8a18\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u306f<img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"15\" height=\"15\" \/>\u30c9\u30e9\u30a4\u30d6\u5185\u3067\u65b0\u898f\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30eb\u30c0\u540d\u306b\u3088\u3063\u3066\u5909\u52d5\u3057\u307e\u3059<br \/>\u203b\u2605\u5370\u4e0b\u90e8\u306b\u3042\u308b\u300c20190000\u300d\u306f\u3001CSV\u51fa\u529b\u6642\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u6307\u5b9a\u3067\u304d\u308b\u7b87\u6240\u3067\u3059<br \/>\uff08\u5909\u66f4\u3059\u308b\u5834\u5408\u3001\u540d\u79f0\u306f\u300c\u534a\u89d2\u6570\u5b578\u30b1\u30bf\u300d\u3067\u6307\u5b9a\uff09<\/span><\/p>\r\n<hr \/>\r\n<p><span style=\"font-size: 18px;\"><strong>\uff1c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u306e\u78ba\u8a8d\u65b9\u6cd5\uff1e<br \/><\/strong><\/span><\/p>\r\n<table style=\"border-collapse: collapse; width: 100%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 50%; border-color: #ffffff;\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10647\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2022\/04\/excelsetting-02.jpg\" alt=\"\" width=\"419\" height=\"546\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2022\/04\/excelsetting-02.jpg 419w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2022\/04\/excelsetting-02-230x300.jpg 230w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2022\/04\/excelsetting-02-407x530.jpg 407w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/td>\r\n<td style=\"width: 50%; border-color: #ffffff;\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10636\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03.jpg\" alt=\"\" width=\"419\" height=\"546\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03.jpg 419w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-230x300.jpg 230w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-407x530.jpg 407w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<hr \/>\r\n<p>\u2605\u5370\u306e\u5165\u529b\u304c\u7d42\u4e86\u3057\u305f\u3089\u3001\u73fe\u5728\u958b\u3044\u3066\u3044\u308bVBAl\u306e\u4fdd\u5b58\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u9589\u3058\u308b<\/p>\r\n<p>Excel\u4fdd\u5b58\/\u7d42\u4e86\u5f8c\u3001\u518d\u5ea6Excel\u30de\u30af\u30ed\u300cCSV\u81ea\u52d5\u5909\u63db\u300d\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3001<img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"20\" height=\"20\" \/>\u30c9\u30e9\u30a4\u30d6\u306e\u6307\u5b9a\u30d5\u30a9\u30eb\u30c0\u4e2d\u306bCSV\u30d5\u30a1\u30a4\u30eb\uff08\u534a\u89d2\u6570\u5b578\u30b1\u30bf\uff09\u304c\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3001\u7d42\u4e86<\/p>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff16.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"color: #0066cc; font-size: 18px;\">Windows\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3092\u4f7f\u7528\u3057\u3001Excel\u30de\u30af\u30ed\u300cExcel\u9023\u52d5.xlsm\u300d\u3092\u6307\u5b9a\u306e\u6642\u9593\u9593\u9694\u3067\u5b9f\u884c\u3055\u305b\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n[Windows\u306e\u30b9\u30bf\u30fc\u30c8]\uff0d[\u30d7\u30ed\u30b0\u30e9\u30e0\u4e00\u89a7\uff08W\u884c\uff09]\uff0d[Windows\u7ba1\u7406\u30c4\u30fc\u30eb]\uff0d[\u30bf\u30b9\u30af\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9]\u3092\u8d77\u52d5\u3057\u3001[\u64cd\u4f5c]\uff0d[\u30bf\u30b9\u30af\u306e\u4f5c\u6210]\u3067\u30c0\u30a4\u30a2\u30ed\u30b0\u3092\u958b\u304f<br \/><br \/><img loading=\"lazy\" class=\"size-full wp-image-4627 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting7.gif\" alt=\"\" width=\"819\" height=\"565\" \/><br \/><br \/><\/p>\r\n<table style=\"width: 100%; height: 536px;\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"height: 37px; border-color: #f2f2f2; background-color: #f2f2f2; width: 29.704%; text-align: left;\"><span style=\"color: #0b559d; font-size: 14px;\"><strong>\u3000<span style=\"font-size: 16px;\">[\u5168\u822c]\u30bf\u30d6<\/span><\/strong><\/span><\/td>\r\n<td style=\"height: 37px; border-color: #ffffff; width: 70.1296%;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 499px;\">\r\n<td style=\"height: 499px; border-color: #f2f2f2; background-color: #f2f2f2; width: 99.8336%;\" colspan=\"2\">\u540d\u524d\uff1a\u4f8b\uff09 Excel\u9023\u52d5<br \/><br \/>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30aa\u30d7\u30b7\u30e7\u30f3\uff1a\u300c\u30e6\u30fc\u30b6\u30fc\u304c\u30ed\u30b0\u30aa\u30f3\u3057\u3066\u3044\u308b\u3068\u304d\u306e\u307f\u5b9f\u884c\u3059\u308b\u300d<br \/><br \/><img loading=\"lazy\" class=\"size-full wp-image-4629 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting8.gif\" alt=\"\" width=\"536\" height=\"386\" \/><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<table style=\"width: 100%; height: 686px;\">\r\n<tbody>\r\n<tr style=\"height: 37px;\">\r\n<td style=\"width: 28.9296%; height: 37px; border-color: #f2f2f2; background-color: #f2f2f2; text-align: left;\"><span style=\"color: #0b559d;\"><strong>\u00a0\u3000<span style=\"font-size: 16px;\">[\u30c8\u30ea\u30ac\u30fc]\u30bf\u30d6\uff0d[\u65b0\u898f]<\/span><\/strong><\/span><\/td>\r\n<td style=\"width: 70.9041%; height: 37px; border-color: #ffffff;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 649px;\">\r\n<td style=\"width: 99.8337%; height: 649px; border-color: #f2f2f2; background-color: #f2f2f2;\" colspan=\"2\">\u8a2d\u5b9a\uff1a\uff11\u56de<br \/><br \/>\u7e70\u308a\u8fd4\u3057\u9593\u9694\uff1a5\u5206\u9593\u306a\u3069\u4efb\u610f\u306e\u81ea\u52d5\u51e6\u7406\u9593\u9694\u3092\u9078\u629e\u203b30\u5206\u3092\u63a8\u5968<br \/><br \/>\u7d99\u7d9a\u6642\u9593\uff1a\u7121\u5236\u9650<br \/><img loading=\"lazy\" class=\"size-full wp-image-4645 alignnone\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting9.gif\" alt=\"\" width=\"595\" height=\"510\" \/><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<table style=\"width: 100%;\">\r\n<tbody>\r\n<tr>\r\n<td style=\"border-color: #f2f2f2; background-color: #f2f2f2; width: 28.4396%; text-align: left;\"><span style=\"color: #0b559d;\"><strong>\u3000<span style=\"font-size: 16px;\">[\u64cd\u4f5c]\u30bf\u30d6\uff0d[\u65b0\u898f]<\/span><\/strong><\/span><\/td>\r\n<td style=\"border-color: #ffffff; width: 71.394%;\">\u00a0<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"border-color: #f2f2f2; background-color: #f2f2f2; width: 99.8336%;\" colspan=\"2\">\r\n<p><span style=\"font-size: 12px;\">\u30d7\u30ed\u30b0\u30e9\u30e0\/\u30b9\u30af\u30ea\u30d7\u30c8\uff1a[\u53c2\u7167]\u30dc\u30bf\u30f3\u3067EXCEL.EXE\u3092\u63a2\u3057\u3066\u9078\u629e<\/span><br \/><br \/><span style=\"font-size: 12px;\">\u4f8b\uff1a\u201cC:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE\u201c<\/span><br \/><span style=\"font-size: 12px;\">\u203b \u6587\u5b57\u5217\u306e\u524d\u5f8c\u306b\u300c&#8221;\u300d\u3092\u5165\u308c\u3001\u4e0a\u8a18\u3068\u540c\u3058\u3088\u3046\u306a\u72b6\u614b\u306b\u3059\u308b<\/span><\/p>\r\n<p><span style=\"font-size: 12px;\">\u5f15\u6570\u306e\u8ffd\u52a0\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\uff1aExcel\u30de\u30af\u30ed\u300cExcel\u9023\u52d5.xlsm\u300d\u306e\u914d\u7f6e\u5834\u6240\u3000\uff0b\u3000\/e\u3000\u3092\u8a18\u8f09<\/span><br \/><span style=\"font-size: 12px;\">\u203b \u4f8b\uff09C:\\Documents\\csv\\Excel\u9023\u52d5.xlsm \/e<\/span><br \/><span style=\"font-size: 12px;\">\u203b\u300c\/e\u300d\u306e\u524d\u306b\u3001\u5fc5\u305a\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u5165\u308c\u3066\u4e0b\u3055\u3044<br \/><\/span><br \/><span style=\"font-size: 12px;\">\u7e70\u308a\u8fd4\u3057\u9593\u9694\uff1a5\u5206\u9593\u306a\u3069\u4efb\u610f\u306e\u81ea\u52d5\u51e6\u7406\u9593\u9694\u3092\u9078\u629e\u203b30\u5206\u3092\u63a8\u5968<\/span><span style=\"font-size: 12px;\"><br \/><\/span><br \/><span style=\"font-size: 12px;\">\u7d99\u7d9a\u6642\u9593\uff1a\u7121\u5236\u9650<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff17.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"color: #0066cc; font-size: 18px;\">\u4e0a\u8a18\u300c2\u300d\u3067\u7528\u610f\u3057\u305fGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u300cApps Script\u300d\u8a2d\u5b9a\u3092\u884c\u3046<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>\u4e0b\u8a18\u306e\u624b\u9806\u306b\u5f93\u3063\u3066Apps Script\u306e\u300c\u30a8\u30c7\u30a3\u30bf\u300d\u300c\u30c8\u30ea\u30ac\u30fc\u300d\u306e\u8a2d\u5b9a\u3092\u884c\u3046<\/p>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 1315px;\">\r\n<tbody>\r\n<tr style=\"height: 517px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 517px;\"><span style=\"font-size: 20px;\"><strong>\uff11<\/strong><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 517px;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-02.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10682\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-02.jpg\" alt=\"\" width=\"333\" height=\"500\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-02.jpg 333w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-02-200x300.jpg 200w\" sizes=\"(max-width: 333px) 100vw, 333px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%; height: 517px;\">\u4e0a\u8a18\u300c2\u300d\u3067\u7528\u610f\u3057\u305fGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u30ed\u30b0\u30a4\u30f3\u3055\u308c\u305f\u72b6\u614b\u3067\u3001\u30d6\u30e9\u30a6\u30b6\u753b\u9762\u53f3\u4e0a\u306e\u300cGoogle\u30a2\u30d7\u30ea\u300d\u4e00\u89a7\u304b\u3089\u300c\u30c9\u30e9\u30a4\u30d6\u300d\u3092\u9078\u629e<\/td>\r\n<\/tr>\r\n<tr style=\"height: 372px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 372px;\"><span style=\"font-size: 20px;\"><strong>\uff12<\/strong><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 372px;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10683\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1.jpg\" alt=\"\" width=\"769\" height=\"392\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1.jpg 769w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1-300x153.jpg 300w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1-530x270.jpg 530w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1-565x288.jpg 565w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1-710x362.jpg 710w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-03-1-725x370.jpg 725w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%; height: 372px;\">\u4e0a\u8a18\u300c3\u300d\u3067\u7528\u610f\u3057\u305f\u9023\u643a\u7528\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u3044\u305f\u72b6\u614b\u3067\u30de\u30a6\u30b9\u53f3\u30af\u30ea\u30c3\u30af\u3092\u62bc\u3057\u3001\u300cGoogle Apps Script\u300d\u3092\u9078\u629e<\/td>\r\n<\/tr>\r\n<tr style=\"height: 181px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 181px;\"><span style=\"font-size: 20px;\"><strong>\uff13<\/strong><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 181px;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-04.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10684\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-04.jpg\" alt=\"\" width=\"500\" height=\"164\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-04.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-04-300x98.jpg 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%; height: 181px;\">\u5de6\u8a18\u306e\u8868\u8a18\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u300c\u4f5c\u6210\u3057\u3066\u5171\u6709\u300d\u3092\u9078\u629e<\/td>\r\n<\/tr>\r\n<tr style=\"height: 192px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 192px;\"><span style=\"font-size: 20px;\"><strong>\u00a0\uff14<\/strong><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 192px;\">\r\n<p><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10692\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08.jpg\" alt=\"\" width=\"800\" height=\"187\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08.jpg 800w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08-300x70.jpg 300w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08-768x180.jpg 768w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08-530x124.jpg 530w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08-565x132.jpg 565w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08-710x166.jpg 710w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-08-725x169.jpg 725w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><br \/><span style=\"font-size: 14px;\"><br \/>\u203b\u30af\u30ea\u30c3\u30af\u3067\u62e1\u5927<\/span><\/p>\r\n<\/td>\r\n<td style=\"width: 32.2304%; height: 192px;\">Apps Script\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u4e0b\u8a18\u306e\u7de8\u96c6\u3092\u884c\u3046<br \/><br \/><strong><span style=\"font-size: 16px;\">\u2460\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u8a2d\u5b9a<\/span><\/strong><br \/>\u3000\u203b\u63a8\u5968\uff1a\u30e1\u30fc\u30eb\u81ea\u52d5\u9001\u4fe1<br \/><strong><span style=\"font-size: 16px;\">\u2461\u30b3\u30fc\u30c9\u5165\u529b<\/span><\/strong><br \/><strong><span style=\"font-size: 16px;\">\u2462\u30b3\u30fc\u30c9\u540d\u79f0\u5165\u529b<\/span><\/strong><br \/>\u3000(\u4f8b)\u300c\u30e1\u30fc\u30eb\u9001\u4fe11\u300d\u300c\u30e1\u30fc\u30eb\u9001\u4fe12\u300d\u306a\u3069<br \/>\u3000\u203b\u5909\u66f4\u306a\u3057\u3067\u3082\u554f\u984c\u3054\u3056\u3044\u307e\u305b\u3093<br \/><strong><span style=\"font-size: 16px;\">\u2463\u30c8\u30ea\u30ac\u30fc<\/span><\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 53px;\">\r\n<td style=\"width: 99.9998%; background-color: #ffffff; height: 53px; text-align: left;\" colspan=\"3\">\r\n<p><span style=\"font-size: 20px;\"><strong>\u00a0<\/strong><\/span><strong style=\"font-size: 12px; font-family: inherit;\"><span style=\"font-size: 16px;\">\u2461\u30b3\u30fc\u30c9\u5165\u529b\u3067\u4f7f\u7528\u3059\u308b\u30b3\u30fc\u30c9\u5185\u5bb9<\/span><\/strong><\/p>\r\n<div style=\"border: 1px solid #cccccc; height: 200px; overflow: auto; width: 100%; border-radius: 3px; margin: auto; padding: 10px; text-align: left;\">\r\n<p>function SendMail() {<br \/>\/\/\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u306e\u5b9b\u5148\u3092\u8a18\u8ff0\u3059\u308b<br \/>let address = <span style=\"color: #ff0000;\">\u25b2<strong>\u9001\u4fe1\u5148\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/strong>\u25b2<\/span>;<br \/>\/\/\u30e1\u30fc\u30eb\u306e\u4ef6\u540d\u3092\u8a18\u8ff0\u3059\u308b<br \/>let mailTitle = \u201cSP-Excel\u9023\u643a&#8221;;<br \/>\/\/\u30e1\u30fc\u30eb\u672c\u6587\u3092\u8a18\u8ff0\u3059\u308b<br \/>let mailText = \u201cCSV\u6dfb\u4ed8\u30e1\u30fc\u30eb&#8221;;<br \/>\/\/Google\u30c9\u30e9\u30a4\u30d6\u5bfe\u8c61\u30c7\u30fc\u30bfID\u3092\u5165\u529b\u3059\u308b<br \/>let attachImg = DriveApp.getFileById(<span style=\"color: #ff0000;\">\u25b2<strong>Google\u30c9\u30e9\u30a4\u30d6\u306e\u30c7\u30fc\u30bfID<\/strong>\u25b2<\/span>).getBlob();<\/p>\r\n<p>\/\/\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092\u8a2d\u5b9a\u3059\u308b<br \/>let options = {<br \/>\u201cattachments&#8221;:attachImg,<br \/>};<\/p>\r\n<p>\/\/MailApp\u3067\u5b9b\u5148\u3001\u4ef6\u540d\u3001\u672c\u6587\u3001\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092\u5f15\u6570\u306b\u3057\u3066\u30e1\u30fc\u30eb\u3092\u9001\u4ed8<br \/>GmailApp.sendEmail(address, mailTitle, mailText, options);<br \/>}<\/p>\r\n<\/div>\r\n<p>\u203b \u25b2 \u306f\u300c&#8221;\u300d\u3078\u7f6e\u304d\u63db\u3048\u308b<br \/>\u203b\u9001\u4fe1\u5148\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\uff1d\u5916\u90e8\u9023\u643a\u8a2d\u5b9a\uff0d\u30e1\u30fc\u30eb\u6dfb\u4ed8\u9023\u52d5\u304b\u3089\u53d6\u5f97\u53ef\u80fd<br \/>\u203bGoogle\u30c9\u30e9\u30a4\u30d6\u306e\u30c7\u30fc\u30bfID\u306f\u4e0b\u8a18\u624b\u9806\u3067\u53d6\u5f97\u53ef\u80fd<br \/><br \/>\u2460\u30d6\u30e9\u30a6\u30b6\u7248<img loading=\"lazy\" class=\"alignnone wp-image-10621\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/Gicon.png\" alt=\"\" width=\"20\" height=\"20\" \/>\u30c9\u30e9\u30a4\u30d6\u304b\u3089\u6dfb\u4ed8CSV\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3059\u308b<br \/>\u2461\u9ed2\u80cc\u666f\u306eCSV\u30d7\u30ec\u30d3\u30e5\u30fc\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u753b\u9762\u53f3\u4e0a\u306e<img loading=\"lazy\" class=\"alignnone wp-image-12178\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/drive-setting.png\" alt=\"\" width=\"18\" height=\"20\" \/>\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b<br \/>\u2462\u300c\u5171\u6709\u300d\u3092\u30af\u30ea\u30c3\u30af\u5f8c\u3001\u8868\u793a\u753b\u9762\u4e0b\u90e8\u306e\u300c\u30ea\u30f3\u30af\u3092\u30b3\u30d4\u30fc\u300d\u3092\u30af\u30ea\u30c3\u30af<br \/>\u2463\u4e0b\u8a18\u4f8b\u3092\u53c2\u8003\u306b\u3057\u3001\u30c7\u30fc\u30bfID\u3092\u53d6\u5f97\u3059\u308b<\/p>\r\n<p>https:\/\/drive.google.com\/file\/d\/<span style=\"color: #ff0000;\">\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf<\/span>\/view?usp=sharing<br \/>\u203b\u25cf\u90e8\u5206\u304c\u30c7\u30fc\u30bfID<\/p>\r\n<div><hr \/><\/div>\r\n<div style=\"text-align: left;\"><span style=\"font-size: 12px;\"><big><strong><span style=\"font-size: 16px;\">\u2463\u30c8\u30ea\u30ac\u30fc\u753b\u9762\u306e\u8a2d\u5b9a\u9805\u76ee<\/span><\/strong><\/big><\/span><\/div>\r\n<div><img loading=\"lazy\" class=\"alignnone wp-image-10703 size-full\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-09.jpg\" alt=\"\" width=\"564\" height=\"220\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-09.jpg 564w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-09-300x117.jpg 300w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-09-530x207.jpg 530w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4e0a\u8a18\u306e\u3088\u3046\u306b\u6642\u8a08\u30a2\u30a4\u30b3\u30f3\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u91cd\u306d\u305f\u5f8c\u3001\u300c\u30c8\u30ea\u30ac\u30fc\u300d\u3092\u30af\u30ea\u30c3\u30af<br \/><br \/><\/div>\r\n<hr \/>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-10.jpg\"><img loading=\"lazy\" class=\"alignnone wp-image-10704\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-10.jpg\" alt=\"\" width=\"500\" height=\"300\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-10.jpg 698w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-10-300x180.jpg 300w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-10-530x318.jpg 530w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-10-565x339.jpg 565w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/div>\r\n<div>\u4e0a\u8a18\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u753b\u9762\u53f3\u4e0b\u300c\u30c8\u30ea\u30ac\u30fc\u3092\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af<\/div>\r\n<div>\u00a0<\/div>\r\n<div><hr \/><\/div>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-11.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10706\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-11.jpg\" alt=\"\" width=\"500\" height=\"570\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-11.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-11-263x300.jpg 263w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-11-465x530.jpg 465w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-11-496x565.jpg 496w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/div>\r\n<div><br \/>\u4e0a\u8a18\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u5e0c\u671b\u3059\u308b\u9023\u52d5\u983b\u5ea6\u306b\u5408\u308f\u305b\u3066\u8a2d\u5b9a\u3092\u884c\u3046<br \/><br \/><\/div>\r\n<div><hr \/><strong><span style=\"font-size: 18px;\">\u25a0\u300c\u5206\u30d9\u30fc\u30b9\u300d\u306e\u30bf\u30a4\u30de\u30fc\u3067\u8a2d\u5b9a\u3059\u308b\u5834\u5408<\/span><\/strong><\/div>\r\n<div>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 149px;\">\r\n<tbody>\r\n<tr style=\"height: 58px;\">\r\n<td style=\"width: 14%; background-color: #e3f2fd; height: 58px;\">\u6642\u9593\u306e\u9593\u9694\u3092<br \/>\u9078\u629e\uff08\u5206\uff09<\/td>\r\n<td style=\"width: 17.2%; background-color: #e3f2fd; height: 58px; text-align: center;\">1\u5206\u304a\u304d<\/td>\r\n<td style=\"width: 17.2%; background-color: #e3f2fd; height: 58px; text-align: center;\">5\u5206\u304a\u304d<\/td>\r\n<td style=\"width: 17.2%; background-color: #e3f2fd; height: 58px; text-align: center;\">10\u5206\u304a\u304d<\/td>\r\n<td style=\"width: 17.2%; background-color: #e3f2fd; height: 58px; text-align: center;\">15\u5206\u304a\u304d<\/td>\r\n<td style=\"width: 17.2%; background-color: #e3f2fd; height: 58px; text-align: center;\">30\u5206\u304a\u304d<\/td>\r\n<\/tr>\r\n<tr style=\"height: 91px;\">\r\n<td style=\"width: 14%; background-color: #e3f2fd; height: 91px;\">\u5229\u7528\u53ef\u4e0d\u53ef<br \/><span style=\"font-size: 10px;\">(\u7121\u6599\u30a2\u30ab\u30a6\u30f3\u30c8)<\/span><\/td>\r\n<td style=\"width: 17.2%; text-align: center; height: 91px;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\"><strong>\u00d7<\/strong><br \/><\/span><\/span><hr \/>60(1h\uff09\u00d724(h)<br \/>\uff1d<strong>1,440\u901a<\/strong><\/td>\r\n<td style=\"width: 17.2%; text-align: center; height: 91px;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\"><strong>\u00d7<\/strong><br \/><\/span><\/span><hr \/>12(1h\uff09\u00d724(h)<br \/>\uff1d<strong>288\u901a<\/strong><\/td>\r\n<td style=\"width: 17.2%; text-align: center; height: 91px;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\"><strong>\u00d7<\/strong><br \/><\/span><\/span><hr \/>6(1h\uff09\u00d724(h)<br \/>\uff1d<strong>144\u901a<\/strong><\/td>\r\n<td style=\"width: 17.2%; text-align: center; height: 91px;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\"><strong>\u3007<\/strong><br \/><\/span><\/span><hr \/>4(1h\uff09\u00d724(h)<br \/>\uff1d<strong>96\u901a<\/strong><\/td>\r\n<td style=\"width: 17.2%; text-align: center; height: 91px;\"><strong><strong><span style=\"font-size: 20px;\">\u3007<br \/><\/span><\/strong><\/strong><hr \/>2(1h\uff09\u00d724(h)<br \/>\uff1d<strong>48\u901a<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nGoogle Apps Script(GAS)\u306e\u30e1\u30fc\u30eb\u9001\u4fe1\u6a5f\u80fd\u306b\u306f\u3001\u5b9f\u884c\u56de\u6570\u306b\u5236\u9650\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059<br \/>\u7121\u6599\u306eGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u5834\u5408\u3001GAS\u306e\u30e1\u30fc\u30eb\u9001\u4fe1\u56de\u6570\u306f<span style=\"text-decoration: underline;\"><span style=\"color: #ff0000; text-decoration: underline;\">1\u65e5100\u901a\u304c\u4e0a\u9650<\/span><\/span>\u3067\u3059<\/div>\r\n<div><br \/><hr \/><strong><span style=\"font-size: 18px;\">\u25a0\u300c\u6642\u9593\u30d9\u30fc\u30b9\u300d\u306e\u30bf\u30a4\u30de\u30fc\u3067\u8a2d\u5b9a\u3059\u308b\u5834\u5408<\/span><\/strong><\/div>\r\n<div style=\"text-align: left;\"><br \/>[1\u6642\u9593\u304a\u304d]\uff5e[12\u6642\u9593\u304a\u304d]\u307e\u3067\u81ea\u7531\u306b\u8a2d\u5b9a\u53ef\u80fd\u3067\u3059<\/div>\r\n<div>\u00a0<\/div>\r\n<div><hr \/><\/div>\r\n<div><strong><span style=\"font-size: 18px;\">\u25a0\u300c\u65e5\u4ed8\u30d9\u30fc\u30b9\u300d\u306e\u30bf\u30a4\u30de\u30fc\u3067\u8a2d\u5b9a\u3059\u308b\u5834\u5408<\/span><\/strong><\/div>\r\n<div><br \/>\u9078\u629e\u80a2[\u5348\u524d0\u6642\uff5e1\u6642]\u306e\u3088\u3046\u306b\u3001Google\u306e\u4ed5\u69d8\u4e0a\u3001\u5206\u6570\u307e\u3067\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093<\/div>\r\n<div>Google\u5074\u306e\u72b6\u6cc1\u306b\u5408\u308f\u305b\u3066\u3001\u30e1\u30fc\u30eb\u9001\u4fe1\u304c\u5b9f\u884c\u3055\u308c\u308b\u6642\u523b\u304c\u65e5\u306b\u3088\u3063\u3066\u7570\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u5e0c\u671b\u3059\u308b\u6642\u9593\u5e2f\u3092\u9078\u629e\u80a2\u304b\u3089\u304a\u9078\u3073\u304f\u3060\u3055\u3044<br \/><br \/><hr \/><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10719\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12.jpg\" alt=\"\" width=\"800\" height=\"265\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12.jpg 800w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12-300x99.jpg 300w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12-768x254.jpg 768w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12-530x176.jpg 530w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12-565x187.jpg 565w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12-710x235.jpg 710w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-12-725x240.jpg 725w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><br \/>\u4e0a\u8a18\u306e\u69d8\u306b\u8a2d\u5b9a\u9805\u76ee\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u6210\u529f<\/div>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<p><strong><span style=\"font-size: 18px;\">\u25a0Apps Script\u8a2d\u5b9a\u6642\u306b\u4e0b\u8a18\u8868\u793a\u304c\u78ba\u8a8d\u3055\u308c\u305f\u969b\u306e\u8a2d\u5b9a\u65b9\u6cd5<\/span><\/strong><\/p>\r\n<table style=\"border-collapse: collapse; width: 100%; height: 1398px;\">\r\n<tbody>\r\n<tr style=\"height: 172px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 10px;\"><span style=\"font-size: 20px;\"><strong>\uff11<\/strong><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 10px;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-05.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10685\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-05.jpg\" alt=\"\" width=\"500\" height=\"155\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-05.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-05-300x93.jpg 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%; height: 10px;\">\u5de6\u8a18\u306e\u8868\u8a18\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u300c\u6a29\u9650\u3092\u78ba\u8a8d\u300d\u3092\u9078\u629e<\/td>\r\n<\/tr>\r\n<tr style=\"height: 619px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 619px;\"><span style=\"font-size: 20px;\"><strong>\uff12<\/strong><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 619px;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-06.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10686\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-06.jpg\" alt=\"\" width=\"500\" height=\"602\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-06.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-06-249x300.jpg 249w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-06-440x530.jpg 440w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-06-469x565.jpg 469w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%; height: 619px;\">\u5de6\u8a18\u306e\u8868\u8a18\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u4e0a\u8a18\u300c2\u300d\u3067\u7528\u610f\u3057\u305fGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u9078\u629e\u3059\u308b<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center;\"><span style=\"font-size: 20px;\"><b>\uff13<\/b><\/span><\/td>\r\n<td style=\"width: 60.3994%;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-13.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10722\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-13.jpg\" alt=\"\" width=\"500\" height=\"579\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-13.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-13-259x300.jpg 259w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-13-458x530.jpg 458w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-13-488x565.jpg 488w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%;\">\u300c\u8a73\u7d30\u300d\u3092\u30af\u30ea\u30c3\u30af\u5f8c\u3001\u300c\u25cf\u25cf\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\uff08\u5b89\u5168\u3067\u306f\u306a\u3044\u30da\u30fc\u30b8\uff09\u306b\u79fb\u52d5\u300d\u3092\u30af\u30ea\u30c3\u30af<br \/><br \/><span style=\"color: #ff0000;\">\u203b\u79fb\u52d5\u5148\u3082Google\u30da\u30fc\u30b8\u3067\u3059\u306e\u3067\u3001\u3054\u5b89\u5fc3\u304f\u3060\u3055\u3044<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 769px;\">\r\n<td style=\"width: 7.37%; background-color: #e3f2fd; text-align: center; height: 769px;\"><span style=\"font-size: 20px;\"><b>\uff14<\/b><\/span><\/td>\r\n<td style=\"width: 60.3994%; height: 769px;\"><a href=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-10687\" src=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07.jpg\" alt=\"\" width=\"500\" height=\"752\" srcset=\"https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07.jpg 500w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07-199x300.jpg 199w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07-352x530.jpg 352w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07-376x565.jpg 376w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07-472x710.jpg 472w, https:\/\/salesp.jp\/spmanual\/wp-content\/uploads\/2019\/12\/excelsetting-07-482x725.jpg 482w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/td>\r\n<td style=\"width: 32.2304%; height: 769px;\">\u5de6\u8a18\u306e\u8868\u8a18\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u300c\u8a31\u53ef\u300d\u3092\u9078\u629e<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>&nbsp;<\/p>\r\n<table style=\"border-collapse: collapse; width: 101.042%; height: 53px;\">\r\n<tbody>\r\n<tr style=\"height: 57px;\">\r\n<td style=\"width: 1.85185%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"font-size: 18px; color: #0066cc;\">\uff18.<\/span><\/td>\r\n<td style=\"width: 99.2152%; background-color: #ebeff2; border-color: #ebeff2; height: 53px;\"><span style=\"color: #0066cc; font-size: 18px;\">Excel\u3068Sales Performer\u304c\u81ea\u52d5\u9023\u643a\u3055\u308c\u308b<\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>\u5ff5\u306e\u305f\u3081\u3001\u5404\u7a2e\u30b0\u30e9\u30d5\u753b\u9762\u3084\u3001Sales Performer\u306e\uff3b\u8a2d\u5b9a\uff3d\uff0d\uff3b\u64cd\u4f5c\u30ed\u30b0\uff3d\u3067\u9023\u643a\u52d5\u4f5c\u304c\u53cd\u6620\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Excel\uff08Windows\uff09\u3068 Sales Performer \u306e\u81ea\u52d5\u9023\u643a \u30e1\u30fc\u30eb\u9023\u52d5 \u00a0 \u00a0 FTP\u9023\u52d5 \u00a0 \u30e1\u30ea\u30c3\u30c8\u3000\uff1a Gmail\u306e\u9001\u4fe1\u6e08\u30d5\u30a9\u30eb\u30c0\u306bCSV\u30d5\u30a1\u30a4\u30eb\u304c\u84c4\u7a4d\u3055\u308c\u308b\u305f\u3081\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u3057\u3066\u5fdc\u7528\u53ef \u00a0 \u30e1\u30ea [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/posts\/4228"}],"collection":[{"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/comments?post=4228"}],"version-history":[{"count":835,"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/posts\/4228\/revisions"}],"predecessor-version":[{"id":12507,"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/posts\/4228\/revisions\/12507"}],"wp:attachment":[{"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/media?parent=4228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/categories?post=4228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salesp.jp\/spmanual\/wp-json\/wp\/v2\/tags?post=4228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}