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. Visual Basic
  4. y something wrong after passing 10 row of line to EXCEL? [SOLVED!][modified]

y something wrong after passing 10 row of line to EXCEL? [SOLVED!][modified]

Scheduled Pinned Locked Moved Visual Basic
helpquestion
18 Posts 5 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.
  • C campbells

    there is no coding error at all i found out ! i solve it by only draging the data grid height longer! oh my..:laugh:

    C Offline
    C Offline
    ChandraRam
    wrote on last edited by
    #9

    Are you sure just increasing the height would do it, then? What happens if the number of rows increased to, say, 100?

    C 1 Reply Last reply
    0
    • C ChandraRam

      Are you sure just increasing the height would do it, then? What happens if the number of rows increased to, say, 100?

      C Offline
      C Offline
      campbells
      wrote on last edited by
      #10

      yes, recently the data i passing not really reach until 100. But u r, u may try go to the datagrid properties change the row length small, normally is 200 so maybe u try 100-50 u can see the row size was squez smaller. so that mean the Height of ur datagrid can contain more row inside. Cause i found out if my height is smaller then the data which suppose to show. Let said My datagrid height just able to show 10 row at one time.Even datagrid able for u to click scroll down to next row but it will have problem when passing to EXCEL. so i just drag the height higher to able to show all the data out without using the scoll. Hope u understand wat i mean... :)

      C 1 Reply Last reply
      0
      • C campbells

        i learn to put this urgent is because i saw ppl do it. sure i woundnt sit and wait anwser while i doing research and i wait anyone able to find out the solution more faster then me, anyway now this question i got my own solution from myself. so i dont mind they ignore my question or watever, as long as i happy to reless some of my recent problem here , maybe is a kind of way to reless my stress. And i more and more like to put bracket [xxx] anything inside, so is easy for me to know where is my post . FORUM FREEdom anyway ;P

        D Offline
        D Offline
        Dave Kreskowiak
        wrote on last edited by
        #11

        campbells wrote:

        i learn to put this urgent is because i saw ppl do it.

        Then you've also seen us tell other people NOT to do it.

        Dave Kreskowiak Microsoft MVP - Visual Basic

        C 1 Reply Last reply
        0
        • D Dave Kreskowiak

          campbells wrote:

          i learn to put this urgent is because i saw ppl do it.

          Then you've also seen us tell other people NOT to do it.

          Dave Kreskowiak Microsoft MVP - Visual Basic

          C Offline
          C Offline
          campbells
          wrote on last edited by
          #12

          so sorry didnt seend b4 this is the first time. just knew it. but wats the big deal? just an extra word anyway. to express some mood.

          P 1 Reply Last reply
          0
          • C campbells

            yes, recently the data i passing not really reach until 100. But u r, u may try go to the datagrid properties change the row length small, normally is 200 so maybe u try 100-50 u can see the row size was squez smaller. so that mean the Height of ur datagrid can contain more row inside. Cause i found out if my height is smaller then the data which suppose to show. Let said My datagrid height just able to show 10 row at one time.Even datagrid able for u to click scroll down to next row but it will have problem when passing to EXCEL. so i just drag the height higher to able to show all the data out without using the scoll. Hope u understand wat i mean... :)

            C Offline
            C Offline
            ChandraRam
            wrote on last edited by
            #13

            That is not really going to solve your problem, I think. What if you are unable to predict the number of rows that your data grid will display? You cannot infinitely decrease the row height...

            C 1 Reply Last reply
            0
            • C ChandraRam

              That is not really going to solve your problem, I think. What if you are unable to predict the number of rows that your data grid will display? You cannot infinitely decrease the row height...

              C Offline
              C Offline
              campbells
              wrote on last edited by
              #14

              can predict by some measurement of course, anyway is already solve already been tested the system.thanks anyway.

              1 Reply Last reply
              0
              • C campbells

                cause is very urgent, but anyway i solve most of it myself. maybe just to express some stress in the forum then

                P Offline
                P Offline
                Paul Conrad
                wrote on last edited by
                #15

                campbells wrote:

                anyway i solve most of it myself

                Good for you :)

                campbells wrote:

                just to express some stress in the forum

                But most people in these CP forums do not respond well to "urgent."


                Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                1 Reply Last reply
                0
                • C campbells

                  i learn to put this urgent is because i saw ppl do it. sure i woundnt sit and wait anwser while i doing research and i wait anyone able to find out the solution more faster then me, anyway now this question i got my own solution from myself. so i dont mind they ignore my question or watever, as long as i happy to reless some of my recent problem here , maybe is a kind of way to reless my stress. And i more and more like to put bracket [xxx] anything inside, so is easy for me to know where is my post . FORUM FREEdom anyway ;P

                  P Offline
                  P Offline
                  Paul Conrad
                  wrote on last edited by
                  #16

                  campbells wrote:

                  i learn to put this urgent is because i saw ppl do it.

                  And you haven't seen some of the nasty replies?


                  Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                  C 1 Reply Last reply
                  0
                  • C campbells

                    so sorry didnt seend b4 this is the first time. just knew it. but wats the big deal? just an extra word anyway. to express some mood.

                    P Offline
                    P Offline
                    Paul Conrad
                    wrote on last edited by
                    #17

                    campbells wrote:

                    just an extra word anyway. to express some mood.

                    Though it is just a word, it is seen as being rude.


                    Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                    1 Reply Last reply
                    0
                    • P Paul Conrad

                      campbells wrote:

                      i learn to put this urgent is because i saw ppl do it.

                      And you haven't seen some of the nasty replies?


                      Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                      C Offline
                      C Offline
                      campbells
                      wrote on last edited by
                      #18

                      wat nasty replies happen recently in the forum? I guess maybe the codeproject adminstration should give some notice to the member what should write and what whould not in the forum.

                      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