About vs C + + operations Excel (close Excel file hints are saved, early formulas ...) ）

A recent project needs to manipulate EXCEL.

The principle can be borrowed from the following blog:

Http://blog.sina.com.cn/s/blog_6163bdeb0102dxcy.html

I used the most commonly used OLE automation method, which suggested that you read the documentation carefully and provide more functionality.

Then in the design encountered a problem, open Excel, exit after the prompt "whether to save the ...." Changes, Microsfot Excel recalculates the formula when you open the file that was last saved by an earlier version of Excel "

Then the project this file is the 2003 version of the old file, and my computer is already 2013, open it after reading the data and then close, to read 10 files, every time asked me to save, it is not bored to death.

Excel_example. Setshowalert (false);

Just set it up and you're ready.

About vs C + + operations Excel (close Excel file hints are saved, early formulas ...) ）