将数据从datagridview传输到Excel工作表 [英] transfer of data from datagridview to excel sheet

问题描述

大家好，
我想将按钮单击事件中的datagridview数据导出到excel表中.
我该怎么办.
荣誉
neaS

hi all,
i want to export my datagridview data into excel sheet on button click event.
how could i do that.
kudos
neaS

推荐答案

这是使用C#处理Excel的两种主要方法.您可以使用Microsoft Office Interop程序集，也可以使用ADO.Net与Excel电子表格进行交互.选择哪个选项取决于您的要求.

Ther are two main ways of dealing with Excel with C#. You can either use the Microsoft Office Interop Assemblies or you can use ADO.Net to interact with an Excel Spreadsheet. Which one you choose will depend on your requirements.

http://csharp.net-informations.com/excel/csharp-excel-datagridview.htm [^ ]

Export a DataSet to Microsoft Excel without the use of COM objects[^]

http://csharp.net-informations.com/excel/csharp-excel-datagridview.htm[^]

这篇关于将数据从datagridview传输到Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！