Announcement

Collapse
No announcement yet.

Save Worksheet As Text File Retaining Spacing

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Save Worksheet As Text File Retaining Spacing

    Fellow Forum Members,
    I have a customer requirement that requires I deliver to him a 300 row, 6 column table I have setup in Excel 2003 as a text file. When I export as a tab delimited text file within Excel 2003 the resulting text file is missing the repeating page header, page footer and table header row. In addition, the columns don't look evenly spaced. What is the best way to get a text file that looks as close as possible to the original Excel file it originates from? (minus the grid lines - I don't need grid lines in the text file). Is this possible to do in Excel? Does it require I use a text editor? I would like to know how to get all the columns looking evenly spaced in the text file with tabs in between them. Any help will be greatly appreciated. Thanks.

  • #2
    Re: High Fidelity Text File Export

    Originally posted by binar
    Fellow Forum Members,
    In addition, the columns don't look evenly spaced.
    A delimited file uses a character to seperate the fields. If you want the fields to be padded with spaces, you'll create a fixed-length file.

    Comment


    • #3
      Re: High Fidelity Text File Export

      Binar, save your file as "Formatted Text Space delimited" as per graphic and it will save headers and pad text with space as required.

      This creates a 'prn' file, which is just a text file.

      Ger
      Attached Files

      Check out our new reputation system. Click on the "star" under the post!
      _______________________________________________

      There are 10 types of people in the world. Those that understand Binary and those that dont.

      Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

      The BEST Lookup function of all time

      Dynamic Named Ranges are your bestest friend

      _______________________________________________

      Comment


      • #4
        Re: High Fidelity Text File Export

        Thanks for the help Ger and Ravenswood,
        I tried out the PRN file format and it does a good job in maintaining the same column spacing established in the Excel source file. However, the shortfalls are as follow:

        1. The automated repeating Heading row found in the Excel file does not carry over to the PRN text file. The heading row only shows up once. I would like it to show up on the top of every page in the text file.

        2. The Header and Footer info does not carry over to the PRN text format.

        It would really help me out a lot if someone out there could direct me to an Excel plugin or some other app that can do better than saving as a PRN file format. Is there a text file solution that can add the repeating header row, and header/footer info automaticaly? Any info will be highly appreciated. Thanks.

        Comment


        • #5
          Re: High Fidelity Text File Export

          Sorry forgot about the header/footer parts...

          Where / what row would define the footer in the text file?

          I think you need to create a macro to do this...

          Ger
          Auto Merged Post;

          Also, why not just give them an excel file?


          Ger
          Last edited by Ger Plante; October 18th, 2007, 10:20. Reason: Auto Merged Doublepost

          Check out our new reputation system. Click on the "star" under the post!
          _______________________________________________

          There are 10 types of people in the world. Those that understand Binary and those that dont.

          Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

          The BEST Lookup function of all time

          Dynamic Named Ranges are your bestest friend

          _______________________________________________

          Comment


          • #6
            Re: High Fidelity Text File Export

            Originally posted by Ger Plante
            Sorry forgot about the header/footer parts...

            Where / what row would define the footer in the text file?

            I think you need to create a macro to do this...

            Ger
            Auto Merged Post;

            Also, why not just give them an excel file?


            Ger
            Thanks for the help Ger,
            Essentially I have a table with six columns and 300 hundred rows of data. The first row is the Heading Row and contains the following fields: First Name, Last Name, Address, City, Zip Code, Phone Nmbr.

            I would like these six field titles that make up the heading row to repeat on the top of every page in the PRN text file. In addition the header and footer info is something else I would to see repeated on every page in the PRN file. Centered in the Footer is the Page #. This needs to count each page. The header has the name of the file centered which is "Contact List". In addition, in between each of the 300 rows is a dashed line separating each row that looks like this: - - - - - - - - - - - - This line goes across from left to right in between each of the rows. I used the border tool to create such a dashed line but for some odd reason the PRN file is not picking up this bottom line border formatting I have done inside Excel.

            Essentially, I'm trying to create a Report using Excel. I realize the correct tool to create a report is Microsoft Access. But I don't know the first thing about Access, this is why I'm trying to accomplish this using Excel. Thanks for any help you can provide.

            Comment


            • #7
              If you wish to continue using this free service.

              Please read the This Page which you agreed to when joining. In particular the point on Thread Titles. After you have done so please CLICK HERE and Private Message Dave Hawley[/B] with your acceptance, or non-acceptance of the rules and a suggested change for your thread title. Please also include a link to this Thread. You can copy this directly from the Address bar of your Browser. When this is done your thread will be re-opened.

              REMEMBER: Your question Title must accurately and concisely describe you are trying do, NOT what you THINK is your answer and use only relevant keywords.

              Please take just 3 mins of your time to read: How To Get Your Question Answered...FAST! AND Anatomy Of A Good Thread Title

              This Thread MUST now stay on the topic of the new Thread Title only please
              Save Worksheet As Text File Retaining Spacing

              Comment

              Working...
              X