DataGridView控件中数据导出至Excel方案的优化与实现

Optimizing and Implementing the Method of Deriving Data to Excel in DataGridView Control

DataGridView控件是信息化系统广泛应用的数据显示控件,但并未提供与Excel文档的交互功能。针对多种交互方法进行分析,通过使用Excel组件和设置Range对象的属性,大大提高数据交互效率和稳定性;采用动态添加控制右键菜单方式,对交互完成后的Excel文件导出操作方式进行优化。测试结果表明,优化后控件的便捷性、移植性、美观度和易用性得到了很大提升。

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.