摘 要通过利用 Excel 软件的矩阵运算、循环迭代计算、绘制图像等功能展开对偏微分方程的数值解的讨论，运用 Excel 软件操作简单、快速准确、结果直观清晰等特点以及利用差分方法在偏微分方程中的应用，推算出抛物线型方程的加权隐式差分格式和与之对应的 Excel 的计算格式，分别对传统意义的数学物理方程和具有实际意义的热传导方程的数值解和解析解（存在有解析解的情况下）加以对比和分析，利用 Excel 软件的图形绘制功能实现了“数”与“形”的完美结合，实现了 Excel软件与偏微分方程的真正结合与实际意义。实验表明，利用 Excel 软件计算偏微分方程具有赋值准确、计算快速、方便、准确，图形绘制清晰形象等优点。关键词:Excel 软件 偏微分方程 数值解 AbstractThis article talks over the digital solution of partial differential equations by using the matrix operation, cyclic iterative calculation, drawing image and other functions of Excel software. Using the characteristics of Excel software, such as simple operation, fast and accurate, intuitive and clear results, and the application of difference method in partial differential equations, the weighted implicit difference format of parabolic equation and the corresponding calculation of Excel are calculated The format, respectively, compares and analyzes the numerical solution and analytical solution (in the case of analytical solution) of the traditional mathematical physical equation and the practical heat conduction equation, realizes the perfect combination of "number" and "shape" by using the graphic drawing function of Excel software, and realizes the real combination and practical significance of Excel software and partial differential equation. The experiment shows that using Excel software to calculate partial differential equations has the advantages of accurate assignment, fast calculation, convenience and accuracy, and clear and vivid drawing.KEY WORDS: Excel, partial differ...
