Spreadsheet control OWC10

[Krishna]

Hello!,
I am using the OWC spreadsheet component in my web form. Users copy data
from an excel sheet and paste it onto the spreadsheet on the web form. I have
to validate this data tbefore saving it to the backend. The spreadsheet has
17 columns and user can paste 1500 or more rows. I am trying to use AJAX to
validate the data as some columns validate values against a Database.Right
now I store the sheet values in a textbox as CSV. What is the best way for
me to pass this data to the server to be validated and send the error cell
address to the client for it to be highlighted so tha the user can correct it.
Any help is appreciated.
Thanks,
Krishna.

 

[Alvin Bruney [MVP]]

Push the data to a server-side text box, on the post you can examine the
textbox. Using AJAX, you submit the contents of the text box. Easy pickings.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

 

[Krishna]

Using AJAX I can send an array of cell addresses back to the client for the
errror cells to be marked on the sheet. How can I do this using Post?
Thanks,
Krishna.

 

[Alvin Bruney [MVP]]

No you wouldn't have to post, I was saying this is how it is done without
AJAX.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley