Problems of VC operating WORD and excel files

jin_kasama

How to open the binary data stream (word or excel document) read from the database with word or excel. After user modification, save it back to the database.

1231456

May need to use temporary files and VBA
The database data is saved as a temporary file and modified with VBA,
Save it after modifying.

霜之哀愁

You can find a routine for handling excel online,
Just look at it. I've done it before, but it's been a long time and I forgot. . . . Sorry

72次灌水被抓

You can use the OLE automation server type of word/excel to access the corresponding BLOB type field of the database

2511718

It is estimated that IE browses Excel and Word documents on the Internet as a data flow method

kanubis

There is an example of VC operation word in vckbase, you can find it
The last time I used JSP to make things, I also encountered the same problem, but I was unable to make one to process WORD stream. I used a control on the Internet and source code. Although it is a JSP file, I think the principles and ideas It should be the same, if you are interested, I can send it to you

jin_kasama

In word or excel, without VBA, can the user save the problem?

sunleon1978

COM development, Word, Excel already support COM development. Use COM objects directly.

zrl8668

a way:
1. Read the file from the database and save it as a temporary file;
2. Use ShellExecute

The second method:
1. Read the file from the database and save it as a temporary file;
2. Use Word, Excel automated method operation

jin_kasama

Save as a temporary file. This method is unnecessary. This method has no way to control the user's save operation. Because also write the user's save back to the database.
to:
sunleon1978
COM development, Word, Excel already support COM development. Use COM objects directly.
Can you be more detailed