I created an web application that let users download the application content in an excel file (csv file). In the application I have no ways to pre-define the column order in the downloaded excel file (csv file).
The downloaded excel file comes in incorrect yet fixed field order (say F5 F1 F4 F2 F3 F8 F7 F6). Is there any way (using excel macro or some other I do not know much) that will cause the excel file to show the correct order of the columns when the excel file is opened? On top of that is it possible for the excel file to show only the first 5 fields like this:
F1 F2 F3 F4 F5
The field names are not actually F1, F2 etc. but the field names are known (those to be included and excluded).
Thanks a lot.
Our community of experts have been thoroughly vetted for their expertise and industry experience.