Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Save Worksheet As Text File Retaining Spacing

  1. #1
    Join Date
    28th December 2006
    Posts
    94

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    10th August 2006
    Posts
    155

    Re: High Fidelity Text File Export

    Quote 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.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,553

    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 Images
    _______________________________________________
    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

    _______________________________________________

  4. #4
    Join Date
    28th December 2006
    Posts
    94

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,553

    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 at 11:20. Reason: Auto Merged Doublepost
    _______________________________________________
    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

    _______________________________________________

  6. #6
    Join Date
    28th December 2006
    Posts
    94

    Re: High Fidelity Text File Export

    Quote 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.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718
    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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 5
    Last Post: January 29th, 2009, 19:31
  2. Save Worksheet As CSV Text File
    By Eric Golf in forum EXCEL HELP
    Replies: 2
    Last Post: May 31st, 2008, 00:52
  3. Open Text File Into Worksheet & Save As .xls
    By vegasdude123 in forum EXCEL HELP
    Replies: 5
    Last Post: May 22nd, 2008, 00:31
  4. Replies: 2
    Last Post: October 12th, 2005, 07:56
  5. Replies: 3
    Last Post: October 17th, 2004, 08:01

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
  •  
porno