SpreadsheetGear for .NET is an Excel compatible spreadsheet control for WinForms which can also be used in ASP.NET applications. It supports autofill (drag fill with mouse as well as API) which is compatible with Excel as well as a Data Series command / UI / API which handles more complex cases including linear and growth trends, dates / times, etc...
SpreadsheetGear also supports reading from, writing to xls and xlsx as well as clipboard support (Cut, Copy & Paste) which can handle Excel content on the Windows clipboard.
We do not have a SpreadsheetGear for Silverlight control yet - but that is a high priority for the future.
You can download the free trial here if you want to give it a try.
If you are going to be providing 'export to Excel and import (paste) from Excel ' then does that mean that you're delivering to an environment where your users have a guaranteed installation of Excel on their machines? If so, you could look at using Excel itself as the grid you want, either via a VSTO project or by perhaps embedding an Excel sheet as a control a WinForm? The latter might require jumping through a few interop hoops but I think it's still possible.
Obviously, if it's not guaranteed that all your users will have Excel on their machines then you can disregard my answer ;-)
发布评论
评论（2）
SpreadsheetGear for .NET 是一个适用于 WinForms 的 Excel 兼容电子表格控件，也可以在 ASP.NET 应用程序中使用。 它支持自动填充（用鼠标拖动填充以及 API），与 Excel 以及数据系列命令/UI/API 兼容，可处理更复杂的情况，包括线性和增长趋势、日期/时间等...
SpreadsheetGear 还支持读取、写入 xls 和 xlsx 以及剪贴板支持（剪切、复制和粘贴），可以处理 Windows 剪贴板上的 Excel 内容。
我们还没有用于 Silverlight 控制的 SpreadsheetGear - 但这是未来的首要任务。
如果您想尝试一下，可以在此处下载免费试用版。
免责声明：我拥有 SpreadsheetGear LLC
SpreadsheetGear for .NET is an Excel compatible spreadsheet control for WinForms which can also be used in ASP.NET applications. It supports autofill (drag fill with mouse as well as API) which is compatible with Excel as well as a Data Series command / UI / API which handles more complex cases including linear and growth trends, dates / times, etc...
SpreadsheetGear also supports reading from, writing to xls and xlsx as well as clipboard support (Cut, Copy & Paste) which can handle Excel content on the Windows clipboard.
We do not have a SpreadsheetGear for Silverlight control yet - but that is a high priority for the future.
You can download the free trial here if you want to give it a try.
Disclaimer: I own SpreadsheetGear LLC
如果您要提供“导出到 Excel 并从 Excel 导入（粘贴）”功能，那么这是否意味着您所交付的环境中您的用户可以保证在其计算机上安装 Excel？ 如果是这样，您可以考虑使用 Excel 本身作为您想要的网格，无论是通过 VSTO 项目还是通过嵌入 Excel 工作表作为 WinForm 控件？ 后者可能需要跳过一些互操作环，但我认为这仍然是可能的。
显然，如果不能保证所有用户的计算机上都有 Excel，那么您可以忽略我的回答;-)
If you are going to be providing 'export to Excel and import (paste) from Excel ' then does that mean that you're delivering to an environment where your users have a guaranteed installation of Excel on their machines? If so, you could look at using Excel itself as the grid you want, either via a VSTO project or by perhaps embedding an Excel sheet as a control a WinForm? The latter might require jumping through a few interop hoops but I think it's still possible.
Obviously, if it's not guaranteed that all your users will have Excel on their machines then you can disregard my answer ;-)