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:
- 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.
- 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).
- If the table is more than 72 column then split extra part of table with common heads and common columns from the beginning.
- Distance between any two columns should be 2 spaces maximum.
- Table header and table body should be separated with a blank line.
Please help me..........