Solved

Creating EXCEL in C

Posted on 1999-01-07
3
200 Views
Last Modified: 2010-04-15
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
Comment
Question by:robj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Accepted Solution

by:
jdrissel earned 100 total points
ID: 1255594
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
 

Author Comment

by:robj
ID: 1255595
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
 

Expert Comment

by:jdrissel
ID: 1255596
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you thought about creating an iPhone application (app), but didn't even know where to get started? Here's how: ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ Important pre-programming comments: I’ve never tri…
Windows programmers of the C/C++ variety, how many of you realise that since Window 9x Microsoft has been lying to you about what constitutes Unicode (http://en.wikipedia.org/wiki/Unicode)? They will have you believe that Unicode requires you to use…
The goal of this video is to provide viewers with basic examples to understand and use pointers in the C programming language.
The goal of this video is to provide viewers with basic examples to understand opening and writing to files in the C programming language.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question