How to open an Excel file and edit it on a windows form
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.