Excel Template changes when data is stored programmatically

Question

0.00/5 (No votes)

See more:

Hello,

In a little project I'm working on, I created a simple template in excel which has a chart and a column of values for the chart. I saved this as .xlt (Excel temple). (I hope that's the right way)

Now based on some calculations in my c++ program, I opened this particular .xlt file and saved those values, in the column specified.
But when I open the file, my values are printed but there is no chart.

Need some help please..

Posted 21-Jun-12 5:33am

Sumal.V

Updated 21-Jun-12 5:50am

v2

Add a Solution

Comments

Jochen Arndt 21-Jun-12 11:38am

What method did you use to write the file (Excel automation or some kind of library)?

Sumal.V 21-Jun-12 11:48am

Its just a simple Stdio file,
of.WriteString(DispValue(val));
where of is the CStdioFile of;
and DispValue(val)is a function that returns a string of values

Jochen Arndt 21-Jun-12 12:03pm

I did not really understand how the data are passed to Excel. Did you write to a text file, open it with Excel, and apply the template or did you write directly to the template file? The second method won't work.

BTW: Use the small Reply link on the right of a comment to answer to it (so the author will get an email notification).

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-06-21T08:14:00

Templates in an Excel application are the copies of workbooks. So, if you would like to display default values, template is a good idea, in other way, it's not!

You should know that the excel file is not a simple text file! You can't use WriteString(); method!

Start here:
http://support.microsoft.com/kb/308407[^]
http://support.microsoft.com/default.aspx?scid=kb;en-us;178782[^]
BasicExcel - A Class to Read and Write to Microsoft Excel[^]
How to Read and Write Excel Files in C++ via ADO[^]
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet[^]

Useful library: http://www.libxl.com/[^]