Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 01-18-2019, 09:54 AM
samirahmed007 samirahmed007 is offline Windows 7 32bit Office 2016
Join Date: Jan 2019
Posts: 1
samirahmed007 is on a distinguished road
Default Converting into a fixed column width table with data alignment&table length under 72 colums

Hi everyone

I have to convert xlsx/csv/txt file into a fixed column width table with data alignment and table split over 72 columns.
The input files may be in 3 different types like (.xlsx/.csv/.txt).
That's what I have attached 3 different types of input files [input.xlsx/input.csv/input.txt (any one can be used according to convenience)]
and 2 different output (1_output_with_align.txt and 2_output_with_align_with_split_table_under_72_colu mn.txt).

Output file should be meet bellow criteria:

  1. Table column align with decimal characters, if there is text in table cell that text should be in left align and only numeric characters always be in right align.
  2. All table's width should be maximum 72 columns in length like our output text file (2_output_with_align_with_split_table_under_72_col umn.txt).
  3. If the table is more than 72 column then split extra part of table with common heads and common columns from the beginning.
  4. Distance between any two columns should be 2 spaces maximum.
  5. Table header and table body should be separated with a blank line.

    Please help me..........
Attached Files
File Type: zip (11.9 KB, 0 views)
File Type: zip (3.1 KB, 0 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table column width wrong - unless macro paused!? Kebap Word VBA 7 09-21-2018 03:14 PM
how to set column width fixed in all similar documents blackice Word 6 07-14-2014 11:36 AM
create fields with multiple lines - fix column width in table expert4knowledge Word 4 02-14-2014 01:06 PM
Merge only the text in a table and keep the 2 original colums of a table james1979uk Word Tables 5 12-15-2013 05:48 PM
Word 2012: Change column width changes table width OpfinnarJocke Word Tables 1 09-22-2012 04:03 AM

All times are GMT -7. The time now is 07:04 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft