l_schuiling
New member
- Joined
- Jul 23, 2006
- Messages
- 1
Dear all i am a newbie if it comes to vb.net, however i have been given an interesting task to accomplish.
i have to build an application that reads and wites data from a dataset or user input to an embedded OWC spread sheet.
Sadly the internet is a bit scarse n this subject and i seem to do something wrong in my code
Dim sheet As AxOWC10.AxSpreadsheet
sheet = New AxOWC10.AxSpreadsheet
sheet.ActiveSheet.Cells(1, 1) = 1
above code is what i can make of to write to and OWC spreadsheet on form1
but then i het the error
System.Windows.Forms.AxHost.InvalidActiveXStateException occurred in AxInterop.OWC10.dll
what am i doing wrong here? and can somebody help me reading from the same sheet, updating a dataset?
awaiting your reply
leon
i have to build an application that reads and wites data from a dataset or user input to an embedded OWC spread sheet.
Sadly the internet is a bit scarse n this subject and i seem to do something wrong in my code
Dim sheet As AxOWC10.AxSpreadsheet
sheet = New AxOWC10.AxSpreadsheet
sheet.ActiveSheet.Cells(1, 1) = 1
above code is what i can make of to write to and OWC spreadsheet on form1
but then i het the error
System.Windows.Forms.AxHost.InvalidActiveXStateException occurred in AxInterop.OWC10.dll
what am i doing wrong here? and can somebody help me reading from the same sheet, updating a dataset?
awaiting your reply
leon