摘要通过利用Exce1软件的矩阵运算、循环迭代计算、绘制图像等功能展开对偏微分方程的数值解的讨论，运用Exce1软件操作简单、快速准确、结果直观清晰等特点以及利用差分方法在偏微分方程中的应用，推算出抛物线型方程的加权隐式差分格式和与之对应的Exce1的计算格式，分别对传统意义的数学物理方程和具有实际意义的热传导方程的数值解和解析解（存在有解析解的情况下）加以对比和分析，利用Exce1软件的图形绘制功能实现了“数”与“形”的完美结合，实现了Excel软件与偏微分方程的真正结合与实际意义。实验表明，利用Exce1软件计算偏微分方程具有赋值准确、计算快速、方便、准确，图形绘制清晰形象等优点。关键词：Excel软件偏微分方程数值解AbstractThis article talks over the digital solution of partial differential equations by usingthe matrix operation,cyclic iterative calculation,drawing image and other functions ofExcel software.Using the characteristics of Excel software,such as simple operation,fast and accurate,intuitive and clear results,and the application of difference method inpartial differential equations,the weighted implicit difference format of parabolicequation and the corresponding calculation of Excel are calculated The format,respectively,compares and analyzes the numerical solution and analytical solution (in thecase of analytical solution)of the traditional mathematical physical equation and thepractical heat conduction equation,realizes the perfect combination of "number"and"shape"by using the graphic drawing function of Excel software,and realizes the realcombination and practical significance of Excel software and partial differential equation.The experiment shows that using Excel software to calculate partial differential equationshas the advantages of accurate assignment,fast calculation,convenience and accuracy,and clear and vivid drawing.KEY WORDS:Excel,partial differential equations,numerical solution目录1.1研究背景和意义1.2国内发展与研究现状22.1 Excel的基本情况2.2 Excel的基本功能33.1差分法的定义53.2差分的种类54.1偏微分方程的一般概念....4.2.1从数学上分类.…74.2.2从物理实际问题上分类4.3偏微分方程的基本解法（一维非齐次波动方程的傅里叶解法）7105.1一维波动方程.…105.2细杆热传导方程的第一混合问题（具有实际意义）156总结与展望6.1总结96.2展望.192021