web环境下office文档的自动生成与下载服务的实现

大庆石油学院本科生毕业设计（论文）I摘要该系统用来实现互联网中office文档的自动生成与下载服务。在21世纪，网络对信息传递与加工是当代办公自动化的一项重要内容。office文档的自动化处理会帮助公司内部之间或公司对外界的信息高时效性传递，完成了对文本信息的自动化生成与处理。公司通过这项技术能够比较方便的发布信息并且生成信息的office文档文件，用户下载到office文档文件就能够更好的对文本信息进行修改与再加工。系统主要功能包括网站的实时更新、客户与服务器的信息交互、office文档文件在Web环境下的动态生成与下载。经过进一步完善与测试，本项技术将会在网站建设与Web应用程序项目上投入使用。关键词：Web；McrosoftOffice；McrosoftVisualStudio大庆石油学院本科生毕业设计（论文）IIAbstractThesystemisusedtoachievesiteofficefileautomaticallygeneratinganddownloadinginthewebsiteenvironmentservices.Inthe21stcentury,thenetworkforinformationtransferandprocessingofcontemporaryofficeautomationanimportantpart.Officeautomationdocumentprocessingwillhelpcompaniesorbetweencompaniesoutsidethehightimelinessofinformationtransmission,completedtheautomationoftextinformationisgeneratedandprocessed.Throughthistechnologycanbequiteeasytodisseminateinformationandgenerateinformationofficedocumentfiles.Usersdownloadfilestotheofficewillbeabletobetterdocumenttherighttoamendthetextinformationandreprocessing.Themainfeaturesincludereal-timeupdatesofwebsite,theclientandtheserverinformationexchange,officedocumentfilesintheWebenvironmentdynamicallygeneratedanddownloaded.Aftermoreimprovementandtest,thistechnologywillbeappliedtothewebsitebuildingandWebapplicationprojects.Keywords：Web；McrosoftOffice；McrosoftVisualStudio大庆石油学院本科生毕业设计（论文）III前言互联网成为人们获取、发布和传递信息的重要渠道，它在人们政治、经济、生活等各个方面发挥着重要的作用。Web应用程序的出现代表人们对信息传递、共享与加工的更高需求，标志着软件开发走入网络化的时代。本文主要阐述的是用于网站开发项目上WEB环境下Office文档的自动生成与下载的专项技术。本文按整个解决方案的模块来组织章节。全文分为五章。第一章介绍开发环境，开发语言的概况。第二章介绍系统分析，包括需求分析、系统的体系结构和系统的工作流程。第三章介绍系统设计，包括具体的模块设计、开发的技术和理论。第四章介绍系统实现，包括系统开发细节、开发的重点难点与系统的优化。第五章介绍系统测试，包括系统的完善和改进措施。大庆石油学院本科生毕业设计（论文）IV目录第1章概述·····························································································11.1技术研究意义··············································································11.2VISUALSTUDIO.NET·······································································11.3ASP.NET与C#语言·······································································11.4SQLSERVER2000与SQL语言·························································31.5系统的开发环境···········································································4第2章服务系统分析···················································································52.1需求分析····················································································52.2系统结构图·················································································52.3工作流程图·················································································6第3章服务系统设计···················································································83.1模块设计····················································································83.2数据库的建立··············································································93.3网络环境与环境下的压缩文件························································103.4网络下的安全策略·······································································12第4章自动生成与下载技术的实现·······························································144.1数据库的连接·············································································144.2OFFICE文档文件的生成·································································164.3WEB环境中的技术问题·································································19第5章系统测试························································································24结论·······································································································25参考文献··································································································26致谢·······································································································27大庆石油学院本科生毕业设计（论文）1第1章概述1.1技术研究意义21世纪是信息化网络化的时代，随着社会的进步人们对于当代生产生活方式有着更高的要求，如何使工作更加人性化成了我们追求的目标。世界的各个地区都面临着减少机械化劳动提高工作效率的实际问题，该技术就是为了解决这一问题而提出的。在网络环境下，政府、学校、医院、公司、生活等领域都面临着日常信息的发布传达，对文档文件的自动化生成与下载技术可以减少工作量，减少时间与人力的损耗，方便快捷的加工信息，使我们的工作更加轻松生活更加舒适。1.2VisualStudio.NETVisualStudio.NET是Miscrosoft公司新一代的软件开发平台，是.NETFramework的重要战略产品。ASP.NET作为MiscrosoftVisualStudio.NET组成部分之一，成为Interent和Interent开发Web的新一代开发工具，逐渐为广大Windows程序员普遍使用。同时VisualC#.NET是微软实现.NET战略的核心开发语言之一，为了让这一庞大的C语言用户加入.NET开发阵营，微软对过去的C开发工具进行了大幅度的改造，使之适应.NET平台的需要[1]。Web应用程序的优点在于可以让企业间的商业数据及交易等行为，透过因特网的通讯来彼此交换讯息。这样不但可以节省数据交换的时间，而且可以简化流程。但是在新一代的.NET开发平台还没有出现之前，要让因特网应用程序达到上述的功能是一项浩大的工程。牵涉到的技术及程序开发语言，可能包括了HTML、ASP、VBScript、JavaScript、C++、ADO、SQL、COM、MTS等。这样的环境对于开发人员来说，想要快速的开发一个功能强大且稳定可靠的Web应用程序，不是一项轻松的工作。为了因应Web架构的快速发展及广大程序开发人员的需求，新一代开发平台目前已经推出了，即为VisualStudio.NET。VisualStudio.NET开发平台里面包含VisualBasic.NET、C#、VisualC++、ASP.NET以及VisualFoxPro。为了让这套开发平台更容易开发以因特网为基础的应用程序，这个开发平台做了许多和以往不同的改革，这个改革就是.NETFramework。.NET架构就是为了让开发分布式因特网应用程序架构变得更简单容易而发展出来的[2]。1.3ASP.NET与C#语言ASP.NET是一种建立在通用语言上的程序构架，能被用于一台Web服务器来建立强大的WEB应用程序。ASP.NET构架是可以用Microsoft（R）公司最新的产大庆石油学院本科生毕业设计（论文）2品VisualStudio.NET开发环境进行开发。ASP.NET提供许多比现在的Web开发模式强大的的优势。ASP.NET是建立在通用语言运行时CLR上的应用程序框架。它用来在服务器端构建功能强大的Web应用程序。ASP.NET提供了几个超越以前Web开发模式的优点：(1)增强的性能ASP.NET是运行在服务器端的编译后的CLR代码，而不像ASP那样解释执行。AS