将数据导入和导出到excelsheet中 [英] Import and Export of Data into and from excelsheet

问题描述

嗨
朋友谁能帮助我提供将数据导入和导出到excel工作表的最佳代码..
我们可以在其中指定工作表名称的地方，也可以在数据导入和导出的地方..
如果工作表不存在，我们可以使用C#和asp.net代码在excel中创建新工作表

在此先感谢

问候
Sushil Dharmar

Hi
Friends Can any one help me with providing the best code for Importing and Exporting of data into excel sheet..
Where we can specify the Sheet name also where Importing and Exporting of Data..
If the Sheet Doesn''t exists we can create an new sheet in the excel using C# and asp.net codes

Thanks in Advance

Regards
Sushil Dharmar

推荐答案

以下是带有源代码的示例: http ://code.msdn.microsoft.com/CSASPNETExcelImportExport-71cf1101 [ ^ ]
在这里，您可以获得代码: http://www. gemboxsoftware.com/support/articles/import-export-datagrid-xls-xlsx-ods-csv-html-net [

Here is an example with source code:http://code.msdn.microsoft.com/CSASPNETExcelImportExport-71cf1101[^]
Here you get the code: http://www.gemboxsoftware.com/support/articles/import-export-datagrid-xls-xlsx-ods-csv-html-net[^]

尝试一下
exporting-datagrid-to-excel-in-aspnet.html [ ^ ]

excel-data-into-gridview-in-aspnet.html [ ^ ]

Try this
exporting-datagrid-to-excel-in-aspnet.html[^]

excel-data-into-gridview-in-aspnet.html[^]

这篇关于将数据导入和导出到excelsheet中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！