This is my second attempt at getting this completed successfully, so please do not bid on this unless you can successfully complete the described task.
I have a web application built with asp .net. I am using MS Office web components, specifically the spreadsheet control. That control is an Active X control, so it resides on the client and is not accessible from the [url removed, login to view] codebehind.
I need to grab the information out of this spreadsheet and then store it in a database.
The only way to get the information out of the ms office web component spreadsheet is to use client side scripting. So, this leaves me with the need to send an array build on the client in vbscript to the web server where I can then send it into a database.
The final product should be a working project build in VS .NET 2002. I need an example of an aspx page that builds an array using **client side vb script**, then sends that array to the webserver. Also i would like a page that demonstrates how to read the data back out on the server side.
I need to do this without exporting an xls file from the MS office web component. So, there should be no file system scripting in the proposed solution.
Using a webservice to do this is a viable option.
Lastly, the array on the client will be large, about 1000 rows with 10 columns. So, the proposed solution to this problem will need to handle something that size in a timely manner (under 1.5 minutes).
1) Complete and fully-functional working program(s) in VS .NET 2002 form as well as complete source code of all work done.