Save Excel with a windows form

  • Thread starter Thread starter Juan Gabriel Del Cid
  • Start date Start date
J

Juan Gabriel Del Cid

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
 
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
 
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.
 
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.
Click to expand...

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
 
That worked. Thanks for your help.

-----Original Message----- encoding/decoding step, as
a

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


.
Click to expand...
 
Back
Top