Results 1 to 9 of 9

Thread: [RESOLVED] Export to Excel cell's row height more than 409

  1. Jun 5th, 2009, 04:26 AM #1
    nUflAvOrS
    nUflAvOrS is offline

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Resolved [RESOLVED] Export to Excel cell's row height more than 409

    Hi All,

    My exporting excel file will get the record from database.
    My remark cell has a lot of word to be loaded.
    My problem is when the row height exceed than 409 the remaining word will not be printed.

    How to rectify my problem ?
    can anyone give me some guide to resolve my problem.

    Thanks a million.
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.
    Reply With Quote Reply With Quote
  2. Jun 5th, 2009, 05:31 AM #2
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Export to Excel cell's row height more than 409

    i believe the text will all be in the cell, just not visible
    limitations vary depending on excel version
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  3. Jun 5th, 2009, 11:54 AM #3
    Cruncher
    Cruncher is offline
    Addicted Member
    Join Date
    Feb 2009
    Posts
    160

    Re: Export to Excel cell's row height more than 409

    merge cells? makes it bigger
    Reply With Quote Reply With Quote
  4. Jun 7th, 2009, 11:43 AM #4
    nUflAvOrS
    nUflAvOrS is offline

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Re: Export to Excel cell's row height more than 409

    Thanks westconn1,

    The text will all be in the same cell just cannot be print if the text more caused the cell row height exceed than 409.

    Got any method can rectify my issue ?

    Cruncher,

    I think merge cell can't resolve my problem because the text all are still inside the same cell. Can I do separation of row if the text exceed than row height 409 ?
    How to accomplish this ?

    Thanks for advice.
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.
    Reply With Quote Reply With Quote
  6. Jun 7th, 2009, 11:44 AM #5
    Cruncher
    Cruncher is offline
    Addicted Member
    Join Date
    Feb 2009
    Posts
    160

    Re: Export to Excel cell's row height more than 409

    row height? does that mean you are using big font??
    Reply With Quote Reply With Quote
  7. Jun 7th, 2009, 11:54 AM #6
    Cruncher
    Cruncher is offline
    Addicted Member
    Join Date
    Feb 2009
    Posts
    160

    Re: Export to Excel cell's row height more than 409

    uhm i think merge cells will fix your problem, look



    as for the coding, i can't help... i dont know anything about writing vb for excell or word etc
    Last edited by Cruncher; Jun 7th, 2009 at 11:59 AM.
    Reply With Quote Reply With Quote
  8. Jun 8th, 2009, 01:35 AM #7
    nUflAvOrS
    nUflAvOrS is offline

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Re: Export to Excel cell's row height more than 409

    Thanks Cruncher,

    I think you misundestood my problem.
    The problem was not caused by font height.
    You may try to select a single row , press the mouse right button and select row height.
    Adjust the row height to 410 or above you will see something.The cell must be fixed and enabled wrap text.

    Thanks.
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.
    Reply With Quote Reply With Quote
  9. Jun 8th, 2009, 04:17 AM #8
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Export to Excel cell's row height more than 409

    as far as i am aware, Maximum row height is 409, your choices are to
    reduce the amount of text,
    widen the column, to the extent the text will fit in the allowed height
    split the text into portions and insert extra rows as required to get the height required, merged or not
    or
    update to see if 2007 allows bigger rows

    i did do some work on this problem before, posted in office development forum, see
    http://www.vbforums.com/showthread.p...cel+row+height
    http://www.vbforums.com/showthread.p...cel+row+height
    Last edited by westconn1; Jun 8th, 2009 at 04:21 AM.
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  11. Jun 15th, 2009, 01:42 AM #9
    nUflAvOrS
    nUflAvOrS is offline

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Re: Export to Excel cell's row height more than 409

    Thanks westconn1,

    The problem resolved. I set my cells will split into another row if the cells text was exceed 800 characters.
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width