如何在不使用gridview等任何控件的情况下将数据集导出到Excel ... [英] How to Export dataset to Excel without using any control like gridview...

问题描述

如何在不使用gridview等任何控件的情况下将数据集导出到Excel ... c

How to Export dataset to Excel without using any control like gridview...c

推荐答案

有几种方法可以实现这一点，例如：

1）使用 Interop [ ^ ]，

2）使用 OpenXML [ ^ ]，

3）使用 ADO.NET [ ^ ]，

4）使用第三方工具。



按照以上链接查看以下链接：

输出DataSet到Excel [ ^ ]

http://social.msdn.microsoft.com/Forums/vstudio/en-US/ea02f8e8 -edf5-4aca-8c74-ef3a9​​4b5328d / export-dataset-into-excel-sheet-in-c [ ^ ]

http://forums.asp.net/t/1197704.aspx/1 [ ^ ]

http://diegworld.blogspot.com/2010/09/i mportexport-dataset-to-excel-file-with.html [ ^ ]

There are several ways to achieve that, for example:
1) using Interop[^],
2) using OpenXML[^],
3) using ADO.NET[^],
4) using third-party tools.

Follow above links and have a look at below set of links:
Output DataSet to Excel[^]
http://social.msdn.microsoft.com/Forums/vstudio/en-US/ea02f8e8-edf5-4aca-8c74-ef3a94b5328d/export-dataset-into-excel-sheet-in-c[^]
http://forums.asp.net/t/1197704.aspx/1[^]
http://diegworld.blogspot.com/2010/09/importexport-dataset-to-excel-file-with.html[^]

这篇关于如何在不使用gridview等任何控件的情况下将数据集导出到Excel ...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！