Solved

How to open an Excel file and edit it on a windows form

Posted on 2008-10-27
3
299 Views
Last Modified: 2012-05-05
I need to be able to open, create and edit an Excel file from a Windows form. I am not worth using DataGrid or DataGridView, abd not a WebBrowser.
What i want is the most similar to Excel itself.

Are some object in the office who i can use to it?

In teory i can use this objet : AxSpreadsheet but i dont find samples for he and when i put this object in the windows form i have a error message when i try to load the form.

Original Error Message in Spanish
Error: Error al crear el formulario. Consulte Exception.InnerException para obtener más detalles. Error: No se puede obtener el identificador de ventana para el control 'AxSpreadsheet'. Los controles ActiveX sin ventana no son compatibles.

google traduction:

Failed to create the form. See Exception.InnerException for more details. Error: Unable to get the identifier of the window to control 'AxSpreadsheet'. ActiveX controls without windows are not compatible.
0
Comment
Question by:JPdeLeon
3 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 22811575
there are some 3rd party products that allows you to do it like http://www.fpoint.com/netproducts/spreadwin/spreadwin.aspx
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question