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

	Input.zip (11.9 KB, 6 views)
	Output.zip (3.1 KB, 6 views)