Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    California, USA
    Thanked 0 Times in 0 Posts

    Save As CSV (XL97:SR2)

    When I save a worksheet as a CSV file I get one additional line of data. If one were to open the CSV file in XL, the last row is blank. However if you open the CSV file in Word or a text editor program you see the additional row.

    Example in XL: CSV File Viewed by Word
    111,111,111 111,111,111 111,111,111
    222,222,222 222,222,222 222,222,222
    333,333,333 333,333,333 333,333,333
    ,, <-Two commas displayed

    I tried deleting the blank rows in the worksheet but still get the additional line.

    Any suggestions,

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post

    Re: Save As CSV (XL97:SR2)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> jstevens

    I think MS-Excel is putting this extra line as an End-Of-File marker. I maybe mistaken, it could be done by the CSV routine in MS-Excel, or the program you are using to open it, such as MS-Word, try and use NotePad, or what have you.

    Try and open it back into MS-Excel and see if this line gets read.

    Try to make sure that you don't have any "dirty" cells below your data range. Dirty cells are used cells that now are cleared from what they held before.

    There is a MSKB article about finding or resetting the Last Cell, see if this helps in making sure that you are ONLY saving what you really want to save.

    Let me know if any of these help.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Save As CSV (XL97:SR2)

    This looks like Excel thinks that the row after your last row of data is not empty. This can happen for a number of reasons:

    1- One or more cellsin the row contain some kind of formatting. For example, the cells may contain borders.

    2- The row below the last data at one time contained data which was deleted, but the workbook has not been saved since it was deleted. Excel does not reset the UsedRange until the file is saved.

    In either case, select the last row and delete it. Then save the workbook and create the CSV file again.

    One other comment. Excel's SaveAs in CSV format is notoriously buggy. You may be experiencing one of those.
    Legare Coleman

Posting Permissions

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