How to embed Excel in .Net form ?

This is not supported by MS Office. However, you can use the Microsoft WebBrowser in your form and Navigate to the Excel file.

Thanks Joseph but I have already tried this and don´t works for me. Microsoft WebBrowser control opens the Excel document in another window (Excel Application), not in the control. Is there any way to avoid this or another way to solve the problem?

Regards,

Juanjo

You can embed Office applications/documents in Active X Controls. These Active X Controls can be used on ABL windows embedded in .NET Forms.

When done properly, the user won't know the difference (of underlying technology)

What activex can be used?

The .Net Form needs to use other .Net controls. How can I use .Net controls and ActiveX in the same Form?

Regards,

Juanjo

The .Net Form needs to use other .Net controls. How can I use .Net controls and ActiveX in the same Form?

Check the GUI for .NET documentation for embedded windows. Basically you'll place a Progress.Windows.WindowContainer control anywhere on your Form. That Control will host an ABL window and in that ABL window you can have an Active X Control. You'll have other .NET Controls around or on top of that.

The coolest feature of GUI for .NET

Check the GUI for .NET documentation for embedded windows. Basically you'll place a Progress.Windows.WindowContainer control anywhere on your Form. That Control will host an ABL window and in that ABL window you can have an Active X Control. You'll have other .NET Controls around or on top of that.

Ok.

What activex can be used? Do you know any?

Juanjo

There is no more ActiveX integration support from Office product. Looks like starting with Vista no more embedding is allowed including through the IE plug-in.

Then, there is no solution to this problem with ActiveX?

Then, there is no solution to this problem with ActiveX?

http://www.edrawsoft.com/officeviewer.php

Works on Windows 7 and with Office 2000 ... Office 2010

You can still use third party ActiveX.

If you don't want to pay for a control/want writeaccess to the files, I actually created a solution to embedding Excel into an ABL form.

Steps:

1. Import functions from the Win32-API assembled User32.dll-file.(GetWindowLong, SetWindowLong, SetParent etc)
2. Create a Interop.Excel.Application, Set the parent of that windowhandle to the panels handle(where you want it implemented, or even better, the custom excel-controls panels windowhandle).
3. Play around with Get/SetWindowLong etc to remove the borders, ribbons. Jail the rest of the ugly remains out of it with hardcore tweaks
4. ?????
5. Profit!

Made right, this will actually implement a workbook, with a minimal macroeditor, splitscreen-capabilities, several sheets etc. The code behind it might be pretty farfetched and ugly, but as long as it delivers robust results im happy

Hi,

   I try this solution, it work . And you don't need Excel .

You DL this library in MSDN

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=5124

And Now , you may read and write excel with ABL code (without excel installation) but it's just (xslx format , excel 2010).

Tip : A make Class Factory in C#  , for my easy use in ABL code.

This SDK have reverse engineering tool. You create Excel File with Excel Application And it creat C# code for create same document.

Thanks Adrien but I need to show the Excel document in the .Net form.

Thanks Fredrik, I wil try it.

You use this ocx : DSOFramer.ocx , but microsoft stop this developpement of this ocx, or try make in C++ your own Activx hosting

   And make a wrapper for C# form width this .net commande : aximp.exe (ex : http://www.c-sharpcorner.com/uploadfile/yougerthen/host-an-ocx-control-within-a-net-windows-application-net-and-com-part-iv/)

exemple :

   http://blogs.msdn.com/b/erikaehrli/archive/2005/08/26/hostofficeinnet.aspx

Ok. I will do some tests.