将Excel数据透视表嵌入C#winforms

时间:2022-11-17 20:57:54

Does anyone know how I can embed an Excel Pivot table control in a win form application developed in C#?

有谁知道如何在C#开发的win表单应用程序中嵌入Excel Pivot表控件?

The raw data for the form would be coming from a SQL Server 2000 database and loaded into a DataTable.

表单的原始数据将来自SQL Server 2000数据库并加载到DataTable中。

Thanks,

1 个解决方案

#1


I don't that you can embed the actual Excel pivot table control into your application but you can make a reference to the Excel libraries to manipulate your data then display it in a DataGridView or other third party control.

我不是说您可以将实际的Excel数据透视表控件嵌入到您的应用程序中,但您可以引用Excel库来操作数据,然后在DataGridView或其他第三方控件中显示它。

Here is a good article on linking to Excel: http://support.microsoft.com/kb/302096

这是一篇关于链接到Excel的好文章:http://support.microsoft.com/kb/302096

Here is my favorite third party Excel like control: http://www.spreadsheetgear.com/

这是我最喜欢的第三方Excel控件:http://www.spreadsheetgear.com/

Hope this helps.

希望这可以帮助。

#1


I don't that you can embed the actual Excel pivot table control into your application but you can make a reference to the Excel libraries to manipulate your data then display it in a DataGridView or other third party control.

我不是说您可以将实际的Excel数据透视表控件嵌入到您的应用程序中,但您可以引用Excel库来操作数据,然后在DataGridView或其他第三方控件中显示它。

Here is a good article on linking to Excel: http://support.microsoft.com/kb/302096

这是一篇关于链接到Excel的好文章:http://support.microsoft.com/kb/302096

Here is my favorite third party Excel like control: http://www.spreadsheetgear.com/

这是我最喜欢的第三方Excel控件:http://www.spreadsheetgear.com/

Hope this helps.

希望这可以帮助。