We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

a 500 points question: build a excel file in c++

roby
roby asked
on
Medium Priority
288 Views
Last Modified: 2010-04-01
I need to build an excel file (without using OLE), but I can't find the exact format of the excel file, perhaps that in microsoft visual c++, there are some objects that already exist to do it.
Thank you.
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
You have a serious problem.
The Excel fileformat is in fact a so called "Structured Storage File". Which means it is a "Filesystem, file" in a File. Well this can be generated with the standard Win32 API. You don't need to use any ole stuff for this. But its a "little bit" of work. FYI, in MFC you can find support for COLEStreamfile. This is a wrapper class for the Files in the "Structured Storage Files". The rest of the files consists of several "subdirs" and "Files in this subdirs". The Format of this Entry should be found within the Office Developers Kit.
At last, you can use "DFVIEW.EXE" in order to take a look at the Excelfiles. This tool is integrated in Visual Studio. It can also too look at WORD Doc files. And if you look around at the Filesformats for the Microsoft Applications, you will find a lot more "Structured Storage Files".
A more detaild explanation of "Structured Storage Files" can be found in the WIN 32 SDK Dokumentation.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.