Submiting OWC Spreadsheet

[Chris Chandler]

I have put the Spreadsheet into a form, but for whatever reason, when I click
the submit button, it only send the button name.
Is there something, well obviously it is, that I am missing?
The OWC Spreadsheet contains hours worked and employee names by store. The GM
can go to the intranet site, fill in the hours per employee and change the
names or hours or whatever, then onece they are done, tehy can submit the
information to the Payroll guy.

Well, thats it in a nutshell

 

[Alvin Bruney [MVP]]

right, because the owc control is a client side control. you have to unload
its data into a serverside textbox for example and then the data will be
available to you on the server. the spreadsheet cannot run on the server.

 

[Chris Chandler]

right, because the owc control is a client side control. you have to
unload its data into a serverside textbox for example and then the data
will be available to you on the server. the spreadsheet cannot run on
the server.

So the user woul have to download the sheet to their machine in order to edit
it, then save the document then submit it? Or would it just be easier to
download teh document and then edit it and -email it back?

 

[Alvin Bruney [MVP]]

no, IE already handles that. you need to have a function inside your page
similar to this
function unloadspreadsheet(){
TextBox1.Text = sp.CSVDATA;
Form1.Submit();
}

in your page_load, you check textbox1.text for data and process it as needed