在windowsform VB.NET中有excel [英] Have excel inside windowsform VB.NET

问题描述

我正在尝试在vb windowsform中有一个excel工作表及其功能。



问题是我找到的任何解决方案都太旧了，有些组件甚至停产了。并且不再支持。



任何寻求解决方案的帮助都会很棒。



谢谢。



我的尝试：



任何解决方案我觉得太旧了，有些组件甚至停产了。并且不再支持。

Hi,

I'm trying to have an excel worksheet and its functionalities inside a vb windowsform.

the problem is that any solution I find is too old, and some components are even discontinued. and no longer supported.

any kind of help for finding a solution to do it would be great.

Thanks.

What I have tried:

Any solution I find is too old, and some components are even discontinued. and no longer supported.

推荐答案

Excel不是一个开源应用程序，你不能拥有它。它没有意义，甚至是实际意义。谁想使用Excel可以在没有您的应用程序的情况下使用它。它是一个专有的商业近源应用程序，就是这样。只是忘了它。



Excel集成的常用方法是使用Office Interop，但我强烈反对处理这类内容。



基于一个可用的.NET FCL控件，使用基本电子表格功能创建一些控件并不太难。如果是 System.Windows.Forms ，首先可能是 System.Windows.Forms.DataGridView ：

DataGridView类（System.Windows.Forms）。



如果你进行一些网络搜索，你将能够找到一些已开发的开源组件电子表格功能。我刚发现的第一个是： .NET Framework的SpreadsheetLight 。



On相反，高端极点，你可以看到，例如，开源Calc，LibreOffice的一部分，它是具有自己的API的产品。但是，我想警告你：使用它将是相当复杂的工作。无论如何，请参阅：

LibreOffice - 维基百科，免费的百科全书，

主页| LibreOffice ，

LibreOffice 5.2 API文档。

-SA

Excel is not an open-source application, you cannot "have" it. It would make no sense, even practical sense. Who wants to use Excel can use it without your application. It is a proprietary commercial close-source application, that's it. Just forget it.

The usual way of Excel integration is using Office Interop, but I would strongly discourage dealing with such stuff.

It's not too hard to create some control with basic spreadsheet functionality, based in one of the available .NET FCL controls. In case of System.Windows.Forms, it could be, first of all, System.Windows.Forms.DataGridView:
DataGridView Class (System.Windows.Forms).

If you do some Web search, you will be able to find some open-source components with already developed spreadsheet functionality. The first one I just found is this: SpreadsheetLight for .NET Framework.

On the opposite, high-end pole, you can see, for example, open-source Calc, part of LibreOffice, which is the product with its own API. However, I would like to warn you: using it would be quite complicated work. Anyway, please see:
LibreOffice — Wikipedia, the free encyclopedia,
Home | LibreOffice,
LibreOffice 5.2 API Documentation.

—SA

这篇关于在windowsform VB.NET中有excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！