+ Reply to Thread
Results 1 to 6 of 6

How do I export an Excel spreadsheet with fixed length rows?

  1. #1
    Paul from St.Paul
    Guest

    How do I export an Excel spreadsheet with fixed length rows?

    I want to create a file with fixed length records (lines). The fields
    (columns) have defined lengths. When I export the file, it should be in a
    flat text format, there should be no spacing between columns of data, and the
    total line length should be exactly what I want.

    How do I do this? What format should I export the data into?

  2. #2
    Jim Rech
    Guest

    Re: How do I export an Excel spreadsheet with fixed length rows?

    You should try the "Formatted Text (Space delimited) (*.prn)" format. You
    must adjust the worksheet column widths to the fixed field widths you want
    before the file, save. Unless you use a fixed width font like Courier New
    this (the column widths) may not look right in the worksheet, but the text
    file should be okay.

    --
    Jim
    "Paul from St.Paul" <Paul from [email protected]> wrote in
    message news:[email protected]...
    >I want to create a file with fixed length records (lines). The fields
    > (columns) have defined lengths. When I export the file, it should be in a
    > flat text format, there should be no spacing between columns of data, and
    > the
    > total line length should be exactly what I want.
    >
    > How do I do this? What format should I export the data into?




  3. #3
    Earl Kiosterud
    Guest

    Re: How do I export an Excel spreadsheet with fixed length rows?

    It's probably worth mentioning that setting the column width should be done
    with Format - Columm - Width. If you set the widths visually, it's pretty
    much mandatory that you use a fixed-pitch font like Courier, which seems to
    correlate closely with the actual width of the columns, in characters. The
    decimal digits have the same widths in many fonts, but other characters
    don't.

    --
    Earl Kiosterud
    www.smokeylake.com/
    -------------------------------------------

    "Jim Rech" <[email protected]> wrote in message
    news:%[email protected]...
    > You should try the "Formatted Text (Space delimited) (*.prn)" format. You
    > must adjust the worksheet column widths to the fixed field widths you want
    > before the file, save. Unless you use a fixed width font like Courier New
    > this (the column widths) may not look right in the worksheet, but the text
    > file should be okay.
    >
    > --
    > Jim
    > "Paul from St.Paul" <Paul from [email protected]> wrote in
    > message news:[email protected]...
    >>I want to create a file with fixed length records (lines). The fields
    >> (columns) have defined lengths. When I export the file, it should be in a
    >> flat text format, there should be no spacing between columns of data, and
    >> the
    >> total line length should be exactly what I want.
    >>
    >> How do I do this? What format should I export the data into?

    >
    >




  4. #4
    Paul from St.Paul
    Guest

    Re: How do I export an Excel spreadsheet with fixed length rows?

    Thanks for your replys, Jim and Earl,

    The part I was missing was the Formatted Text (Space delimited) export
    format. I am planning to use the Data > Validation > Text length tool to make
    sure each field is the right length, and I will use Courier New font.

    Paul

    "Earl Kiosterud" wrote:

    > It's probably worth mentioning that setting the column width should be done
    > with Format - Columm - Width. If you set the widths visually, it's pretty
    > much mandatory that you use a fixed-pitch font like Courier, which seems to
    > correlate closely with the actual width of the columns, in characters. The
    > decimal digits have the same widths in many fonts, but other characters
    > don't.
    >
    > --
    > Earl Kiosterud
    > www.smokeylake.com/
    > -------------------------------------------
    >
    > "Jim Rech" <[email protected]> wrote in message
    > news:%[email protected]...
    > > You should try the "Formatted Text (Space delimited) (*.prn)" format. You
    > > must adjust the worksheet column widths to the fixed field widths you want
    > > before the file, save. Unless you use a fixed width font like Courier New
    > > this (the column widths) may not look right in the worksheet, but the text
    > > file should be okay.
    > >
    > > --
    > > Jim
    > > "Paul from St.Paul" <Paul from [email protected]> wrote in
    > > message news:[email protected]...
    > >>I want to create a file with fixed length records (lines). The fields
    > >> (columns) have defined lengths. When I export the file, it should be in a
    > >> flat text format, there should be no spacing between columns of data, and
    > >> the
    > >> total line length should be exactly what I want.
    > >>
    > >> How do I do this? What format should I export the data into?

    > >
    > >

    >
    >
    >


  5. #5
    JE McGimpsey
    Guest

    Re: How do I export an Excel spreadsheet with fixed length rows?

    If you'd rather not reformat your worksheet to accommodate the png
    format, you can use VBA to export fixed field formats:

    http://www.mcgimpsey.com/excel/textf...tml#fixedfield


    In article <[email protected]>,
    "Paul from St.Paul" <[email protected]> wrote:

    > Thanks for your replys, Jim and Earl,
    >
    > The part I was missing was the Formatted Text (Space delimited) export
    > format. I am planning to use the Data > Validation > Text length tool to make
    > sure each field is the right length, and I will use Courier New font.
    >
    > Paul


  6. #6
    Paul from St.Paul
    Guest

    Re: How do I export an Excel spreadsheet with fixed length rows?

    Thanks John, I will give this a try.

    Paul

    "JE McGimpsey" wrote:

    > If you'd rather not reformat your worksheet to accommodate the png
    > format, you can use VBA to export fixed field formats:
    >
    > http://www.mcgimpsey.com/excel/textf...tml#fixedfield
    >
    >
    > In article <[email protected]>,
    > "Paul from St.Paul" <[email protected]> wrote:
    >
    > > Thanks for your replys, Jim and Earl,
    > >
    > > The part I was missing was the Formatted Text (Space delimited) export
    > > format. I am planning to use the Data > Validation > Text length tool to make
    > > sure each field is the right length, and I will use Courier New font.
    > >
    > > Paul

    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1