|本期目录/Table of Contents|

[1]吴双.DataGridView控件中数据导出至Excel方案优化及实现[J].温州职业技术学院学报,2016,02:68-71.
 WU Shuang.Optimizing and Implementing the Method of Deriving Data to Excel in DataGridView Control[J].Journal of Wenzhou Vocational and Technical College,2016,02:68-71.
点击复制

DataGridView控件中数据导出至Excel方案优化及实现(PDF)

《温州职业技术学院学报》[ISSN:1006-6977/CN:61-1281/TN]

期数:
2016年02期
页码:
68-71
栏目:
应用技术
出版日期:
2016-05-01

文章信息/Info

Title:
Optimizing and Implementing the Method of Deriving Data to Excel in DataGridView Control
作者:
吴双
温州职业技术学院教务处;
Author(s):
WU Shuang
Teaching Affairs Department, Wenzhou Vocational & Technical College, Wenzhou, 325035, China
关键词:
计算机 DataGridView控件 Excel 信息化
Keywords:
Computers DataGridView control Excel Informationization
分类号:
TP391.13
DOI:
10.13669/j.cnki.33-1276/z.2016.042
文献标识码:
A
摘要:
DataGridView控件是信息化系统广泛应用的数据显示控件,但并未提供与Excel文档的交互功能。针对多种交互方法进行分析,通过使用Excel组件和设置Range对象的属性,大大提高数据交互效率和稳定性;采用动态添加控制右键菜单方式,对交互完成后的Excel文件导出操作方式进行优化。测试结果表明,优化后控件的便捷性、移植性、美观度和易用性得到了很大提升。
Abstract:
DataGridView Control is a data display control widely used in information system, but it can't interact with Excel documents. Analysis has been done on various interactive methods. By using Excel components and fixing the property of Range object, data interactive efficiency and stability are greatly improved. In addition, dynamic addition is used to control right key menu in order to optimize the Excel document deriving process after interaction comes to an end. Testing findings demonstrate that the optimized control is greatly improved in terms of its convenience, portability, presentation, and being easy to use.

参考文献/References

-

备注/Memo

备注/Memo:
【基金】 温州职业技术学院科研项目(WZY2015012)
更新日期/Last Update: 2016-06-20