Click here to Skip to main content
15,888,610 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
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.
Posted
Updated 14-Jun-16 21:17pm
v2

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900