Thread: Reading Excel Row Cells A through J

  1. #31
    cout<<"Wakka Wakka"<<endl
    Join Date
    May 2004
    Posts
    35
    when you run the program does it output 2000 lines. I am at another computer and I am getting the same output error. The first mean should be 3.7947(its close) instead of 1.87068. I see the program go through the 2000 lines of data and it does this with the code i have written as well but the end results is only 299 lines instead of 2000 lines. I know this because i copy the output data and paste it in word or notepad and view the line count. just wondering if you get the same thing? thanks for looking into this but if you could compile and run it and see if your first answer is 1.87068 then you will see what im talking about

  2. #32
    cout<<"Wakka Wakka"<<endl
    Join Date
    May 2004
    Posts
    35
    HOLY! OMFG! WTH! I dont know why but when i run it and grab onto the scroll bar and go up I can see my elusive first mean of 3.7987. but when i let go and let the program complete its cycle It wont show up anymore. Why does c++ do this on my output window only? Is there some properties option I need to set? It actually works thank god but why does it only show me 299 lines in the end. I think i need a tinfoil hat on or something

  3. #33
    Code Goddess Prelude's Avatar
    Join Date
    Sep 2001
    Posts
    9,897
    >but why does it only show me 299 lines in the end.
    That's probably the line limit of your console window. It has nothing to do with C++.
    My best code is written with the delete key.

  4. #34
    cout<<"Wakka Wakka"<<endl
    Join Date
    May 2004
    Posts
    35
    I hate to beat a dead horse but ... is there anyway to extend that line limit?

  5. #35
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,659
    Nornally if you have lots of output, you do

    Code:
    myprog.exe > results.txt
    Then you look at results.txt using your favourite editor.

    You can right-click on the top-left icon in the title bar, choose properties and set the scroll-back to at most 9999 lines. But that isn't so good for say searching for stuff.
    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.

  6. #36
    cout<<"Wakka Wakka"<<endl
    Join Date
    May 2004
    Posts
    35
    thanks salem for you advice. I would also like to thank prelude and elad again for their help. Im just starting out in this programming bizz and im starting to like the problem solving. I just need to practice it everyday so i can learn the syntax properly then i can move onto quicker algorithms close this silly thread of mine mods so it can die a happy death.

  7. #37
    cout<<"Wakka Wakka"<<endl
    Join Date
    May 2004
    Posts
    35
    so 7 years later I run across this and wonder...Why not SQL or just use a built in macro.

    SELECT *
    FROM tblData
    Stdev(PatientOne)


    Ya know, I got this to work with everyones help back then. Could I have been more complicated?

  8. #38
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,659
    > close this silly thread of mine mods so it can die a happy death.
    Yeah, should have done that, then you wouldn't have bumped it 7 years later (read the rules!)
    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.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Help with code modification
    By DCMann2 in forum C Programming
    Replies: 7
    Last Post: 05-06-2008, 10:33 PM
  2. Merging the cells of excel from vc++
    By yongzai in forum Windows Programming
    Replies: 1
    Last Post: 06-16-2006, 03:42 AM
  3. excel spreadsheets / blank cells
    By xddxogm3 in forum Tech Board
    Replies: 3
    Last Post: 06-14-2005, 12:10 PM
  4. reading pictures and array
    By sunoflight77 in forum C++ Programming
    Replies: 0
    Last Post: 05-09-2005, 03:16 PM
  5. Q: Simpliest way to use Excel file?
    By cDir in forum Windows Programming
    Replies: 10
    Last Post: 02-01-2002, 03:21 PM