如何使用C＃将数据从sqlserver 2008导入到msExcel [英] how to import data from sqlserver 2008 to msExcel using C#

问题描述

如何使用C＃

解决方案

将数据从sqlserver 2008导入msExcel尝试

将数据导出到Excel，Word，PDF，不带数据库的自动化 [ ^ ]

http://geekswithblogs.net/VROD/archive/2008/ 04/20 / 121433.aspx [ ^ ]

http://tim.mackey.ie/HowtoExportADatasetToExcelCAspnet.aspx [ ^ ]

http://www.dotnetfunda.com/forums/thread548 -export-data-to-excel-file-from-a-table-in-sql-server-using-csharp.aspx [ ^ ]

您可以编写一个查询，返回您希望放在excel文件中的结果的DataTable，然后查看以下链接之一转换为excel。



[ ^ ]



< a href =http://www.gemboxsoftware.com/support/articles/import-export-datatable-xls-xlsx-ods-csv-html-net> http://www.gemboxsoftware.com/support/articles /进出口，数据表，XLS，XLSX-OD s-csv-html-net [ ^ ]



http://msmvps.com/blogs/deborahk/archive/2009/07/23/writing-data-from -a-datatable-to-excel.aspx [ ^ ]



http://stackoverflow.com/questions/373925/c-sharp-winforms-app-export-dataset-to- excel [ ^ ]

how to import data from sqlserver 2008 to msExcel using C#

解决方案

Try
Export Data to Excel, Word, PDF without Automation from DataBase[^]
http://geekswithblogs.net/VROD/archive/2008/04/20/121433.aspx[^]
http://tim.mackey.ie/HowtoExportADatasetToExcelCAspnet.aspx[^]
http://www.dotnetfunda.com/forums/thread548-export-data-to-excel-file-from-a-table-in-sql-server-using-csharp.aspx[^]

You can write a query that returns a DataTable of the results you wish to place in a excel file and then look at one of the links below to convert to excel.

[^]

http://www.gemboxsoftware.com/support/articles/import-export-datatable-xls-xlsx-ods-csv-html-net[^]

http://msmvps.com/blogs/deborahk/archive/2009/07/23/writing-data-from-a-datatable-to-excel.aspx[^]

http://stackoverflow.com/questions/373925/c-sharp-winforms-app-export-dataset-to-excel[^]

这篇关于如何使用C＃将数据从sqlserver 2008导入到msExcel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！