Save Excel with a windows form

I have a windows form that traps an "before save" event in
Excel 2000. What I would like to do is save the Excel in
SQL Server by calling a web service. I thought I could
have serialized Excel and send it to the web service as a
string for database storage, but it seems that Excel
cannot be serialized. This windows form will be a no
touch deployment application so any extra software would
be difficult.

Thanks,
Shane

Juan
Fri Oct 24 14:52:03 CDT 2003

Save the document to disk, open the file, read it's content (binary), encode
the binary data in Base64, send that and then decode at the other end.

Hope that helps,
-JG

Chris
Sat Oct 25 11:51:18 CDT 2003

Your idea is good, except one does not need the encoding/decoding step, as a
web service can have as parameter a byte array, thus one can send the byte
stream read directly to the web service.

"Juan Gabriel Del Cid" <jdelcid@atrevido.nospam.net> wrote in message
news:%23WVdJMqmDHA.1656@tk2msftngp13.phx.gbl...
> Save the document to disk, open the file, read it's content (binary),
encode
> the binary data in Base64, send that and then decode at the other end.
>
> Hope that helps,
> -JG
>
>

Juan
Sun Oct 26 01:41:16 CST 2003

> Your idea is good, except one does not need the encoding/decoding step, as
a
> web service can have as parameter a byte array, thus one can send the byte
> stream read directly to the web service.

This is correct. I forgot SOAP handles byte arrays automatically. It does
encode them as base64, :-D, so I still get half a point.

-JG

anonymous
Mon Oct 27 07:52:08 CST 2003

That worked. Thanks for your help.


>-----Original Message-----
>> Your idea is good, except one does not need the
encoding/decoding step, as
>a
>> web service can have as parameter a byte array, thus
one can send the byte
>> stream read directly to the web service.
>
>This is correct. I forgot SOAP handles byte arrays
automatically. It does
>encode them as base64, :-D, so I still get half a point.
>
>-JG
>
>
>.
>