Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. Excel and c++

Excel and c++

Scheduled Pinned Locked Moved C / C++ / MFC
c++question
8 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    mitil20390482304
    wrote on last edited by
    #1

    Hi I have a simple application and, I have the data in some arrays. If I want to write these data to an Excel file what should I do. I can easily write them to a text file....but is it possible to write it to an Excel file without using MFC?

    K D 2 Replies Last reply
    0
    • M mitil20390482304

      Hi I have a simple application and, I have the data in some arrays. If I want to write these data to an Excel file what should I do. I can easily write them to a text file....but is it possible to write it to an Excel file without using MFC?

      K Offline
      K Offline
      keegan
      wrote on last edited by
      #2

      you can make the output go into a *.csv file, a comma seperated value file, which can easily be imported into excell. *.* cin >> knowledge;

      M 3 Replies Last reply
      0
      • K keegan

        you can make the output go into a *.csv file, a comma seperated value file, which can easily be imported into excell. *.* cin >> knowledge;

        M Offline
        M Offline
        mitil20390482304
        wrote on last edited by
        #3

        ok thanks I tried to make a .CSV file and it opens in Excel format the only problem is that the file does not look good. All of the output in in One Cell. if I want to have something in A1 and the next thing in B1 what should I do. right not it does not undrestand that Tab means going to the next column!

        1 Reply Last reply
        0
        • K keegan

          you can make the output go into a *.csv file, a comma seperated value file, which can easily be imported into excell. *.* cin >> knowledge;

          M Offline
          M Offline
          mitil20390482304
          wrote on last edited by
          #4

          One more thing I forgot to ask. How can I create a Sheet within the .cvs file from inside my c++ code?

          1 Reply Last reply
          0
          • K keegan

            you can make the output go into a *.csv file, a comma seperated value file, which can easily be imported into excell. *.* cin >> knowledge;

            M Offline
            M Offline
            mitil20390482304
            wrote on last edited by
            #5

            dont worry about my first question. I used *.xls file directly and it works but i am still wondering about generating that extra sheet in the file.

            1 Reply Last reply
            0
            • M mitil20390482304

              Hi I have a simple application and, I have the data in some arrays. If I want to write these data to an Excel file what should I do. I can easily write them to a text file....but is it possible to write it to an Excel file without using MFC?

              D Offline
              D Offline
              David Crow
              wrote on last edited by
              #6

              maryami wrote: ...is it possible to write it to an Excel file without using MFC? Yes, just use Excel's COM interface.


              Five birds are sitting on a fence. Three of them decide to fly off. How many are left?

              M 1 Reply Last reply
              0
              • D David Crow

                maryami wrote: ...is it possible to write it to an Excel file without using MFC? Yes, just use Excel's COM interface.


                Five birds are sitting on a fence. Three of them decide to fly off. How many are left?

                M Offline
                M Offline
                mitil20390482304
                wrote on last edited by
                #7

                Can you give me a link that can help me to get to know excel's COM interface? I have not work with that before!.is it a class? library ?

                D 1 Reply Last reply
                0
                • M mitil20390482304

                  Can you give me a link that can help me to get to know excel's COM interface? I have not work with that before!.is it a class? library ?

                  D Offline
                  D Offline
                  David Crow
                  wrote on last edited by
                  #8

                  maryami wrote: Can you give me a link that can help me to get to know excel's COM interface? Try this one.


                  Five birds are sitting on a fence. Three of them decide to fly off. How many are left?

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups