• C

Creating EXCEL in C

I'm charged with coming up with a fast running program in C (which I prefer) or C++ that will extract data and dynamically build an EXCEL spread sheet.  I'm pretty good at C but have ZERO experience with EXCEL.

Can anyone point me in the right direction? DDE or something.  Sample code or links to samples would be greatly APPRECIATED! Anything ...

-Thank you
robjAsked:
Who is Participating?
 
jdrisselCommented:
Write your program to create a comma delimited output file.
Then write a template spreadsheet with a macro to import the comma delimited data.
You would probably have to figure out what format a formula is exported in to know how to
write your output.  I would suggest that you write the kinds of formulas you will need into a
test spread sheet, export it and take a look.  Good luck!
0
 
robjAuthor Commented:
Thanks .. just about what I thought .. however ... does it assume the user will open the flat delimtted file.  How can I launch (i.e. what parms or is there a sample)EXCEL to automatically pull in and build the spreadsheet so the .XLS is fully built by the time the use fetches the file?
0
 
jdrisselCommented:
That part of the application would be best done with Visual Basic.  I really don't know how to do it, but I do know that kind of automation is frequently done in VB.  Good Luck
kd5dac
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.