基于B/S结构的Excel试验数据导出方法  

A Method for Leading off Excel Testing Data Based on B/S Structure

作　　者：蔡芳[1] 王晓红[1] 刘晓晖[1] 

机构地区：[1]中国飞机强度研究所,西安710065

出　　处：《电脑开发与应用》2011年第12期20-21,24,共3页Computer Development & Applications

基　　金：航空科学基金资助项目(20090923007)

摘　　要：随着我国航空事业的不断发展,飞机结构强度试验数据的整理、分析和再利用在飞机型号试验和设计领域内显得尤为重要。为了将历史试验数据更好地保存并展示出来,为改型或新研型号提供历史数据基础平台,设计了一套"飞机结构强度试验数据库查询系统"。该系统基于B/S模式,采用ASP、OLEDB、Oracle数据库技术开发,对于其中应用到的技术"将Excel文件中的数据通过OLEDB技术以Web方式展示出来"进行了阐述,给出了实现方法。通过对该系统的运行情况分析,这种数据导出方法对大型数据的Web展示效果良好,运行效率高,可以在更多行业内推广应用。With the continuous development of China＇s aviation industry,the collation, analysis and preservation of Aircraft Structural Strength Testing Data become particularly significant in the field of Aircraft model Testing and Design.In order to make a better preservation and demonstration of historical Testing Data,and to provide a basic historical data platform for transformation model or newly developed model,we have designed an ＂Aircraft Structural Strength Testing Database Query System＂.Our query system based on B/S structure mainly uses ASP, OLEDB,and Oracle Database technology.This paper mainly describes the technology used for ＂Excel Data demonstration through Web mode by using OLEDB method＂. And in this paper we also provide the implementation in detail.The operation condition analysis of the query system shows this data export method works well for the Web demonstration of large-scale data.This method is high efficiency,and it＇s suitable for other industries.

关 键 词：数据导出 EXCEL OLEDB WEB 

分 类 号：TP399[自动化与计算机技术—计算机应用技术]