Like Tree2Likes
  • 1 Post By mariostg
  • 1 Post By Salem

Working with multiple excel files

This is a discussion on Working with multiple excel files within the Tech Board forums, part of the Community Boards category; Hello Guys, I need to write very short c programming language in order to be able to combine Excel sheet ...

  1. #1
    SBK
    SBK is offline
    Registered User
    Join Date
    May 2012
    Posts
    2

    Working with multiple excel files

    Hello Guys,
    I need to write very short c programming language in order to be able to combine Excel sheet in a way that I want. But i dont have any software for that. What do u suggest me to download for free? Easy to use?

    Thanks

  2. #2
    Master Apprentice phantomotap's Avatar
    Join Date
    Jan 2008
    Posts
    4,409
    O_o

    What does these things have in common?

    If you just want to combine spreadsheets, I'm reasonably certain that literally every spreadsheet program (I use Libre Office.) will probably be capable of the task.

    Soma

  3. #3
    SBK
    SBK is offline
    Registered User
    Join Date
    May 2012
    Posts
    2
    I tried to write (record) a macro for that but didn't work. So decide to switch to C.
    i want to grab a certain column from 100 Excel file and add in them next to each other into the first Excel file.

  4. #4
    Registered User
    Join Date
    Dec 2011
    Posts
    51
    I am no C expert, but I can tell you you want to do it in VBA. Recording a macro will not give you a complete solution you will have to write your own routine. I don't think you are on the right forum to solve your problem. The title you picked is not going to help you much by the way.
    Salem likes this.

  5. #5
    Registered User
    Join Date
    Aug 2007
    Location
    MD, USA
    Posts
    71
    An excel file is encoded. It would take forever to learn decipher it. By then MS would change it (again).

    You could export all .xls to .csv (comma separated files) and write a C program to read them and do what you want with the data.

    OR start as new xl sheet, copy the desired column from each of the sheets to that and do what you want,
    or save that as .csv and write a C prog to do what you want.

    Or take the time to learn to write the macro.

    Which would be the fastest? Most fun? Your choice!

  6. #6
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    32,825
    > I tried to write (record) a macro for that but didn't work. So decide to switch to C.
    How much of a road-bump would it take for you to give up trying to use C and switch to yet another approach?
    - How much VBA do you know (none)?
    - How much C do you know (wizard)?
    Unless you're already a C wizard, I can't see you succeeding at using C.

    In the past, I've started with a macro recording to do some part of a "thing" once, then gone in and edited it to make it do what I want.

    Which version of excel are you using - or more importantly, which version of excel are the files saved in? If it's something fairly recent, then perhaps the documents are stored in XML format.
    Microsoft Office XML formats - Wikipedia, the free encyclopedia
    Dealing with these is easy, it's just a big dumb text file.
    rags_to_riches likes this.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.
    I support http://www.ukip.org/ as the first necessary step to a free Europe.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Working with multiple source files
    By abh!shek in forum C Programming
    Replies: 17
    Last Post: 06-03-2008, 12:23 PM
  2. reading excel files...
    By gaah in forum C++ Programming
    Replies: 2
    Last Post: 02-18-2005, 09:55 PM
  3. C++ Builder and Excel files
    By mfdemi in forum Windows Programming
    Replies: 3
    Last Post: 09-24-2004, 02:51 AM
  4. Reading Excel Files?
    By Daniel in forum C++ Programming
    Replies: 2
    Last Post: 08-13-2003, 07:03 PM
  5. Replies: 1
    Last Post: 05-01-2003, 03:52 PM

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