• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

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
0
robj
Asked:
robj
  • 2
1 Solution
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now