{"id":679,"date":"2015-02-25T14:51:16","date_gmt":"2015-02-25T05:51:16","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=679"},"modified":"2016-02-05T14:38:19","modified_gmt":"2016-02-05T05:38:19","slug":"datatype","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/datatype\/","title":{"rendered":"\u5909\u6570\u306e\u30c7\u30fc\u30bf\u578b\u30fb\u5ba3\u8a00\uff08Dim \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\uff09"},"content":{"rendered":"

\u5909\u6570\u306e\u5ba3\u8a00<\/h2>\n

\u4e00\u822c\u7684\u306a\u65b9\u6cd5<\/h3>\n
\n
\u3010\u66f8\u5f0f\u3011<\/strong>
\nDim<\/strong> varname<\/em> [ As<\/strong> type<\/em>, \u2026\u2026 ]\n<\/div>\n
\n
    \n
  • varname \u30fb\u30fb\u30fb \u5909\u6570\u540d<\/li>\n
  • type       \u30fb\u30fb\u30fb \u30c7\u30fc\u30bf\u578b\uff08Integer, Long, Date, String \u7b49\uff09<\/li>\n<\/ul>\n

    \u300ctype\u300d\u306f\u7701\u7565\u53ef\u80fd\u3002\u7701\u7565\u3057\u305f\u5834\u5408\u306f\u3001\u30d0\u30ea\u30a2\u30f3\u30c8\u578b\uff08Variant\uff09\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n

    \r\n\u3000\r\n'\u6574\u6570\u578b\r\nDim num As Integer\r\n\r\n'xnum:\u9577\u6574\u6570\u578b\u3001ynum:\u500d\u7cbe\u5ea6\u6d6e\u52d5\u5c0f\u6570\u70b9\u578b\r\nDim xnum As long, ynum As Double\r\n\r\n'A\u3001B:\u30d0\u30ea\u30a2\u30f3\u30c8\u578b\u3001C:\u53ef\u5909\u9577\u6587\u5b57\u5217\u578b\r\nDim A, B, C As String\r\n\r\n'\u56fa\u5b9a\u9577\u6587\u5b57\u5217\u578b\r\nDim varstr As String * 10\r\n\u3000\r\n\u3000\r\n<\/pre>\n<\/div>\n
    \n
    \u7701\u7565\u8a18\u53f7\u3092\u4f7f\u7528\u3059\u308b<\/h3>\n
    \n
    \u3010\u66f8\u5f0f\u3011<\/strong>
    \nDim<\/strong> varname<\/em><ellipsis><\/strong>\n<\/div>\n
    \n
      \n
    • varname \u30fb\u30fb\u30fb \u5909\u6570\u540d<\/li>\n
    • <ellipsis>\u30fb\u30fb\u30fb \u7701\u7565\u8a18\u53f7\uff08% & @ $ \u7b49\uff09<\/li>\n<\/ul>\n<\/div>\n
      \r\n\u3000\r\n'num:\u6574\u6570\u578b\u3001str:\u53ef\u5909\u9577\u6587\u5b57\u5217\u578b\r\nDim num%, str$\r\n\r\n'kingaku:\u901a\u8ca8\u578b\r\nDim kingaku@\r\n\u3000\r\n\u3000\r\n<\/pre>\n<\/div>\n

      \n
      \u30c7\u30fc\u30bf\u578b\u4e00\u89a7<\/h2>\n
      \n
      \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      \u30c7\u30fc\u30bf\u578b<\/span><\/td>\n\u610f\u5473<\/span><\/td>\n\u30b5\u30a4\u30ba\u30fb\u30c7\u30fc\u30bf\u306e\u5185\u5bb9<\/span><\/td>\n\u7701\u7565\u8a18\u53f7<\/span><\/td>\n<\/tr>\n
      Boolean<\/td>\n\u30d6\u30fc\u30eb\u578b<\/td>\n[2\u30d0\u30a4\u30c8]\u3000true\uff08\u771f\uff09-1 \/ false\uff08\u507d\uff090<\/td>\n<\/td>\n<\/tr>\n
      Byte<\/td>\n\u30d0\u30a4\u30c8\u578b<\/td>\n[1\u30d0\u30a4\u30c8]\u3000\u6b63\u306e\u6574\u6570\uff080\uff5e255\uff09<\/td>\n<\/td>\n<\/tr>\n
      Integer<\/td>\n\u6574\u6570\u578b<\/td>\n[2\u30d0\u30a4\u30c8]\u3000\u6574\u6570\uff08-32768\uff5e32767\uff09<\/td>\n%<\/td>\n<\/tr>\n
      Long<\/td>\n\u9577\u6574\u6570\u578b<\/td>\n[4\u30d0\u30a4\u30c8]\u3000\u6574\u6570\uff08-2147483648\uff5e2147483647\uff09<\/td>\n&<\/td>\n<\/tr>\n
      Currency<\/td>\n\u901a\u8ca8\u578b<\/td>\n[8\u30d0\u30a4\u30c8]\u3000-922,337,203,685,477.5808 \uff5e 922,337,203,685,477.5807\u306e\u56fa\u5b9a\u5c0f\u6570\u70b9\u6570<\/td>\n@<\/td>\n<\/tr>\n
      Single<\/td>\n\u5358\u7cbe\u5ea6\u6d6e\u52d5
      \n\u5c0f\u6570\u70b9\u6570\u578b<\/td>\n      		[4\u30d0\u30a4\u30c8]
      \n-3.402823E38 \uff5e -1.401298E-45 (\u8ca0\u306e\u5024)
      \n1.401298E-45 \uff5e 3.402823E38 (\u6b63\u306e\u5024)<\/td>\n      		!<\/td>\n<\/tr>\n
      Double<\/td>\n\u500d\u7cbe\u5ea6\u6d6e\u52d5
      \n\u5c0f\u6570\u70b9\u6570\u578b<\/td>\n      		[8\u30d0\u30a4\u30c8]\u3000
      \n-1.79769313486232E308 \uff5e -4.94065645841247E-324 (\u8ca0\u306e\u5024)
      \n4.94065645841247E-324 \uff5e 1.79769313486232E308 (\u6b63\u306e\u5024)<\/td>\n      		#<\/td>\n<\/tr>\n
      Date<\/td>\n\u65e5\u4ed8\u578b<\/td>\n[8\u30d0\u30a4\u30c8]
      \n\u897f\u66a6100\u5e741\u67081\u65e50:00:00 \uff5e \u897f\u66a69999\u5e7412\u670831\u65e523:59:59<\/td>\n      		<\/td>\n<\/tr>\n
      String<\/td>\n\u53ef\u5909\u9577
      \u6587\u5b57\u5217\u578b<\/td>\n      		\u4efb\u610f\u306e\u9577\u3055\u306e\u6587\u5b57\u5217<\/td>\n$<\/td>\n<\/tr>\n
      String * length<\/td>\n\u56fa\u5b9a\u9577
      \u6587\u5b57\u5217\u578b<\/td>\n      		\u9577\u3055 length \u306e\u6587\u5b57\u5217<\/td>\n<\/td>\n<\/tr>\n
      Object<\/td>\n\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u578b<\/td>\n[4\u30d0\u30a4\u30c8]\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/td>\n<\/td>\n<\/tr>\n
      Variant<\/td>\n\u30d0\u30ea\u30a2\u30f3\u30c8\u578b<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
      Type<\/td>\n\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u578b<\/td>\nType \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/a>\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u30c7\u30fc\u30bf\u578b<\/td>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
      \u5909\u6570\u306e\u5ba3\u8a00 \u4e00\u822c\u7684\u306a\u65b9\u6cd5 \u3010\u66f8\u5f0f\u3011 Dim varname [ As type, … <\/p>\n","protected":false},"author":1,"featured_media":774,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":""},"categories":[37],"tags":[38,41,39],"jetpack_featured_media_url":"https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/02\/variable_declaration.jpg?fit=1105%2C676&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s4Ye9i-datatype","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/679"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=679"}],"version-history":[{"count":99,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/679\/revisions"}],"predecessor-version":[{"id":5054,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/679\/revisions\/5054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media\/774"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}