{"id":5200,"date":"2026-04-25T12:21:07","date_gmt":"2026-04-25T03:21:07","guid":{"rendered":"https:\/\/www.ktech.biz\/jp\/?p=5200"},"modified":"2026-04-25T12:21:07","modified_gmt":"2026-04-25T03:21:07","slug":"xlpack-mpl-user","status":"publish","type":"post","link":"https:\/\/www.ktech.biz\/jp\/manual2\/xlpack-mpl-user\/","title":{"rendered":"XLPack for Matplotlib \u30e6\u30fc\u30b6\u30fc\u30de\u30cb\u30e5\u30a2\u30eb"},"content":{"rendered":"

1. \u6982\u8981<\/h2>\n

XLPack for Matplotlib (\u4ee5\u4e0b XLPack MPL \u3068\u7565\u8a18\u3057\u307e\u3059) \u306f Excel VBA \u304b\u3089 Python \u306e Matplotlib \u3092\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059.<\/p>\n

Matplotlib \u306e\u4e3b\u8981\u306a\u30af\u30e9\u30b9\u304a\u3088\u3073\u30e1\u30bd\u30c3\u30c9\u3092 VBA \u306e\u30af\u30e9\u30b9\u304a\u3088\u3073\u30e1\u30bd\u30c3\u30c9\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u3057\u3066 VBA \u30d7\u30ed\u30b0\u30e9\u30e0\u3060\u3051\u3067 Matplotlib \u3092\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u305f\u3082\u306e\u3067\u3059.<\/p>\n

\u672c\u30d7\u30ed\u30b0\u30e9\u30e0\u306f, \u6570\u5024\u8a08\u7b97\u30e9\u30a4\u30d6\u30e9\u30ea XLPack \u3068\u7d44\u307f\u5408\u308f\u305b\u3066, Excel \u3067\u8a08\u7b97\u304b\u3089\u7d50\u679c\u306e\u8868\u793a\u307e\u3067\u3092\u884c\u3046\u305f\u3081\u306e\u53ef\u8996\u5316\u6a5f\u80fd\u90e8\u5206\u3068\u3057\u3066\u8a66\u9a13\u7684\u306b\u958b\u767a\u4e2d\u306e\u3082\u306e\u3067\u3059.<\/p>\n

\u672a\u5b9f\u88c5\u306e Matplotlib \u30af\u30e9\u30b9\u304a\u3088\u3073\u30e1\u30bd\u30c3\u30c9\u306f\u9806\u6b21\u8ffd\u52a0\u3057\u3066\u3044\u304f\u4e88\u5b9a\u3067\u3059\u304c, \u5225\u9014\u63d0\u4f9b\u3055\u308c\u3066\u3044\u308b XLPack for Python \u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3053\u308c\u3089\u306e\u6a5f\u80fd\u3092\u88dc\u5b8c\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059.<\/p>\n

2. \u4f8b\u984c<\/h2>\n

\u4f7f\u7528\u30a4\u30e1\u30fc\u30b8\u3092\u3064\u304b\u3080\u305f\u3081\u306b\u7c21\u5358\u306a\u4f8b\u984c\u3092\u898b\u3066\u307f\u307e\u3059.<\/p>\n

pyplot.plot \u3092\u4f7f\u3063\u3066\u30b5\u30a4\u30f3\u30ab\u30fc\u30d6\u3092\u30d7\u30ed\u30c3\u30c8\u3059\u308b\u4f8b\u984c\u3067\u3059. Python \u3067\u306f\u6b21\u306e\u3088\u3046\u306b\u66f8\u304b\u308c\u307e\u3059.<\/p>\n

\n
\r\nimport matplotlib.pyplot as plt\r\nimport numpy as np\r\nimport math\r\n# make data\r\nt = np.linspace(0, 2, 201)\r\ns = 1 + np.sin(2 * math.pi * t)\r\n# plot\r\nplt.plot(t, s, '-b')\r\nplt.xlabel(\"time (s)\")\r\nplt.ylabel(\"voltage (mV)\")\r\nplt.title(\"About as simple as it gets, folks\")\r\nplt.grid()\r\nplt.show()<\/code><\/pre>\n<\/div>\n
\u3053\u308c\u3068\u540c\u3058\u3082\u306e\u3092\u6b21\u306e\u3088\u3046\u306b VBA \u3067\u66f8\u304f\u3053\u3068\u304c\u3067\u304d\u307e\u3059.<\/p>\n
\n
\r\nDim Plt As New PyPlot\r\n\r\nFunction Pi() As Double\r\n    Pi = 4 * Atn(1)\r\nEnd Function\r\n\r\nSub Linspace(A As Double, B As Double, N As Long, X() As Double)\r\n    Dim I As Long\r\n    For I = 0 To N - 1\r\n        X(I) = A + I * ((B - A) \/ (N - 1))\r\n    Next\r\nEnd Sub\r\n\r\nSub Test_Plt_Plot()\r\n    Const N = 201\r\n    Dim T(N - 1) As Double, S(N - 1) As Double\r\n    Dim I As Long\r\n    Call Linspace(0, 2, N, T())\r\n    For I = 0 To N - 1\r\n        S(I) = 1 + Sin(2 * Pi() * T(I))\r\n    Next\r\n    Call Plt.Plot(N, T(), S(), \"-b\")\r\n    Call Plt.Xlabel(\"time (s)\")\r\n    Call Plt.Ylabel(\"voltage (mV)\")\r\n    Call Plt.Title(\"About as simple as it gets, folks\")\r\n    Call Plt.Grid\r\n    Call Plt.Show\r\nEnd Sub<\/code><\/pre>\n<\/div>\n
VBA \u3067\u306f Python \u306e\u3088\u3046\u306b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u305b\u305a\u306b PyPlot \u306e\u30e1\u30bd\u30c3\u30c9\u3092\u547c\u3073\u51fa\u3059\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093. \u305d\u306e\u305f\u3081, VBA \u30d7\u30ed\u30b0\u30e9\u30e0\u5185\u3067 “Dim Plt As New PyPlot” \u3068\u3057\u3066 PyPlot \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4e00\u5ea6\u4f5c\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059. \u305d\u306e\u5f8c\u306f, VBA \u30d7\u30ed\u30b0\u30e9\u30e0\u3092 Python \u3068\u8981\u9818\u3067\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059.<\/p>\n
\u5b9f\u884c\u7d50\u679c\u306f\u3069\u3061\u3089\u3082\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059.<\/p>\n
\"\"<\/p>\n
\u540c\u3058\u4f8b\u984c\u3092 Pyplot \u3067\u306f\u306a\u304f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f7f\u3063\u3066\u66f8\u304f\u3053\u3068\u3082\u3067\u304d\u3066, \u30e1\u30a4\u30f3\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059.<\/p>\n
\n
\r\nSub Test_Plot()\r\n    Const N = 201\r\n    Dim T(N - 1) As Double, S(N - 1) As Double\r\n    Dim I As Long\r\n    Dim Fig As Figure, Ax As Axs\r\n    Call Linspace(0, 2, N, T())\r\n    For I = 0 To N - 1\r\n        S(I) = 1 + Sin(2 * Pi() * T(I))\r\n    Next\r\n    Set Fig = Plt.Figure()\r\n    Set Ax = Fig.Gca()\r\n    Call Ax.Plot(N, T(), S(), \"-b\")\r\n    Call Ax.Set_xlabel(\"time (s)\")\r\n    Call Ax.Set_ylabel(\"voltage (mV)\")\r\n    Call Ax.Set_title(\"About as simple as it gets, folks\")\r\n    Call Ax.Grid\r\n    Call Plt.Show\r\nEnd Sub<\/code><\/pre>\n<\/div>\n
3. Matplotlib \u3092\u4f7f\u3046\u305f\u3081\u306e VBA \u30af\u30e9\u30b9\u3068\u30e1\u30bd\u30c3\u30c9<\/h2>\n
\u73fe\u6642\u70b9\u3067\u306f\u4e00\u90e8\u306e\u30af\u30e9\u30b9\u3068\u30e1\u30bd\u30c3\u30c9\u3057\u304b\u5b9f\u88c5\u3055\u308c\u3066\u3044\u307e\u305b\u3093. \u8a73\u3057\u304f\u306f\u4ee5\u4e0b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044.<\/p>\n
\u6982\u8981<\/a>
\nVBA \u30af\u30e9\u30b9\uff0f\u30e1\u30bd\u30c3\u30c9\u306e\u8a73\u7d30<\/a>
\n\u4f7f\u7528\u4f8b\u4e00\u89a7<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
XLPack for Matplotlib \u306e\u30e6\u30fc\u30b6\u30fc\u30de\u30cb\u30e5\u30a2\u30eb<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[49],"tags":[],"class_list":["post-5200","post","type-post","status-publish","format-standard","hentry","category-manual2"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t