Trying to call an Excel file

This is a discussion on Trying to call an Excel file within the C++ Programming forums, part of the General Programming Boards category; I was wondering what the code would be to call upon an Excel file, perform a find and replace, and ...

  1. #1
    Registered User
    Join Date
    Jun 2008
    Posts
    5

    Trying to call an Excel file

    I was wondering what the code would be to call upon an Excel file, perform a find and replace, and then save the Excel file to a specific name.

  2. #2
    Kernel hacker
    Join Date
    Jul 2007
    Location
    Farncombe, Surrey, England
    Posts
    15,677
    Can you describe a bit more what you are wanting to do? There are likely to be several solutions, but C++ can not implicitly read .xls files - you'd be much better of usinc Excel macros for that.

    --
    Mats
    Compilers can produce warnings - make the compiler programmers happy: Use them!
    Please don't PM me for help - and no, I don't do help over instant messengers.

  3. #3
    Registered User
    Join Date
    Jun 2008
    Posts
    5
    Currently, we use a bunch of Excel files that are linked to one another to organize color recipes for the product we create. However, every time we need to create a new recipe sheet, it is a pain. So I'm looking at writing a program which can call upon the Master Recipe Sheet, change the links (easily done through a find and replace in excel), and then save the file under the name of the Recipe. I am versed enough with C++ to be able to do this with text files, but am not sure how to go about it using excel files. Thanks for your assistance.

  4. #4
    3735928559
    Join Date
    Mar 2008
    Location
    RTP
    Posts
    839
    sounds like you need a database to replace all those excel files. try access. i use postgres myself, but access has some nice features for making forms and such.
    Last edited by m37h0d; 06-11-2008 at 07:35 PM.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. File transfer- the file sometimes not full transferred
    By shu_fei86 in forum C# Programming
    Replies: 13
    Last Post: 03-13-2009, 12:44 PM
  2. File Writing Problem
    By polskash in forum C Programming
    Replies: 3
    Last Post: 02-13-2009, 09:47 AM
  3. Need Help Fixing My C Program. Deals with File I/O
    By Matus in forum C Programming
    Replies: 7
    Last Post: 04-29-2008, 07:51 PM
  4. Encryption program
    By zeiffelz in forum C Programming
    Replies: 1
    Last Post: 06-15-2005, 03:39 AM
  5. Unknown Memory Leak in Init() Function
    By CodeHacker in forum Windows Programming
    Replies: 3
    Last Post: 07-09-2004, 09:54 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21