' Response.Write('error occured') ' Response.End() End Try End Sub Wrapping up If strOperation = ' save' Then Dim streamReader As New System.IO.StreamReader(Request.InputStream)ĭim spreadsheetdata = streamReader.ReadToEnd() ' ' this this needs to be updated in teh database Try Dim strOperation As String = String.Empty Once you have installed the office web component, use the tag to insert component control on to your aspx page.īlocks of code should be set as style 'Formatted' like this:Ĭopy Code Protected Sub Page_Load( ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load The important point to note here is, that the server does not require to install microsoft Excel. Or just search for “Office Web Component v11.0 Download”, yeah I trust ‘Google’ that it would provide us with the exact result if Microsoft does not change the location of the download. Note: OWC is not available for Design Time toolbox in Visual studio. Sometimes in our Application we may require a feature of Excel Spreadsheet with minimum level of functionality in such cases OWC is the solution to our problem. The OWC can be used by any COM-compliant Component Object Model programming language. This ActiveX controls can be plugged into web pages, Visual Basic and VBA forms, Windows forms or programmed in-memory. Office Web Component (OWC) are a group of OLE classes implemented as ActiveX controls in Microsoft Office 2000, Office XP and Office 2003.
