Excel integration

This is a discussion on Excel integration within the C++ Programming forums, part of the General Programming Boards category; Hi all, I have a 'data health' project which requires excel as a final output. However the requirements are in ...

  1. #1
    Registered User rogster001's Avatar
    Join Date
    Aug 2006
    Location
    Liverpool UK
    Posts
    1,438

    Excel integration

    Hi all,

    I have a 'data health' project which requires excel as a final output. However the requirements are in my opinion ill suited to VBA, it just does not scale to the job properly. I plan to write in C++ for a quality solution - The actual processing and 'tool' spec is nailed on for it. Can anybody point me to a library that is free and allows me to talk to excel once processing is over? I would like access to excel formatting and worksheets, save in proprietary formats. I have checked a few things out but any suggestions? Is there any e.g. open source, good quality library around?
    Last edited by rogster001; 09-22-2012 at 06:12 AM.
    Thought for the day:
    "Are you sure your sanity chip is fully screwed in sir?" (Kryten)
    FLTK: "The most fun you can have with your clothes on."

    Stroustrup:
    "If I had thought of it and had some marketing sense every computer and just about any gadget would have had a little 'C++ Inside' sticker on it'"

  2. #2
    qny
    qny is offline
    Registered User
    Join Date
    Sep 2012
    Posts
    355
    If you don't mind a "bit of cheating" write a csv file -- possibly with extension .xls

    Excel will open and convert it on the fly.

  3. #3
    Registered User rogster001's Avatar
    Join Date
    Aug 2006
    Location
    Liverpool UK
    Posts
    1,438
    Thats what i am saying, I know i can generate data and filetypes that excel will open but i need the true access - I don't want to deliver a tool that requires anybody to go and add all the formatting for tables etc afterwards -Though Its not the end of the world if that is what ends up happening like. I have stuff i can use to write chart output in all sorts of ways via fltk - but there is no budget for 'roll your own' on this job - interface yes, quick and easy, output via fancy formatting to custom code widgets - no.
    Last edited by rogster001; 09-22-2012 at 06:27 AM.
    Thought for the day:
    "Are you sure your sanity chip is fully screwed in sir?" (Kryten)
    FLTK: "The most fun you can have with your clothes on."

    Stroustrup:
    "If I had thought of it and had some marketing sense every computer and just about any gadget would have had a little 'C++ Inside' sticker on it'"

  4. #4
    Registered User whiteflags's Avatar
    Join Date
    Apr 2006
    Location
    United States
    Posts
    7,763
    Unless you are working with an old version of Excel (before 2007) then you can just use the open document format. OpenDocument Format for developers

    LibOPC is yet another option. http://libopc.codeplex.com/documentation
    Last edited by whiteflags; 09-22-2012 at 07:37 AM.

  5. #5
    Registered User rogster001's Avatar
    Join Date
    Aug 2006
    Location
    Liverpool UK
    Posts
    1,438
    ok, cool, thanks for the suggestions will take a look
    Thought for the day:
    "Are you sure your sanity chip is fully screwed in sir?" (Kryten)
    FLTK: "The most fun you can have with your clothes on."

    Stroustrup:
    "If I had thought of it and had some marketing sense every computer and just about any gadget would have had a little 'C++ Inside' sticker on it'"

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Integration with C++
    By strokebow in forum C++ Programming
    Replies: 9
    Last Post: 10-06-2011, 07:15 AM
  2. Integration with Web?
    By dluthcke in forum C++ Programming
    Replies: 25
    Last Post: 09-30-2009, 01:02 AM
  3. PC Cam Integration
    By neo_phyte in forum Networking/Device Communication
    Replies: 0
    Last Post: 10-25-2006, 02:34 AM
  4. Integration
    By westclok in forum C Programming
    Replies: 8
    Last Post: 02-01-2005, 05:06 AM
  5. Integration
    By Sang-drax in forum A Brief History of Cprogramming.com
    Replies: 17
    Last Post: 01-03-2003, 04:08 AM

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