Forums

How to order Fields in XLS Export

tonkom 02 Aug, 2016
Hi,

i would like to know how to order the fields in XLS Export different to the order in the Form.

Could not get it to work except in the order of the original Form.

Thank you,

Thomas
GreyHead 02 Aug, 2016
Hi Thomas,

There is a Fields list box in the XLS EXport action. If you put the list of fields in there does that set the order?

if you are using a DB Read to get the data there's also a Fields list box there.

Bob
tonkom 03 Aug, 2016
Hi Bob,

thanks for your reply.
I tried the field list boxes in the XLS export action already, but couldnt get the fields and field heads(column name in xls) into sync :-(.

Is there any other way to order fields and column names than the field list boxes?

Best regards

Thomas
GreyHead 03 Aug, 2016
Hi tonkom,

You could re-order the columns in the database table; or use a Custom Code action after the DB Read to re-sort the data after it has been loaded.

Bob
This topic is locked and no more replies can be posted.