reverse order of columns after transposing

Example

There is an Excel file source.xlsx, the data is as follows:

1 2 3 4

5 6 7

8 9 11


22 33



44

Now we need to transpose the two-dimensional table of M column into M rows, starting from the M-th column, and turning into columns M-1, M-2...2, 1 in order, and the results are as follows:

4 7 11 33 44
3 6 9 22
2 5 8

1



Write SPL script:

A
1 =file("source.xlsx").xlsimport@w()
2 =transpose(A1).rvs()
3 =file("result.xlsx").xlsexport@w(A2)

A1 Read the excel file and read it as a sequence composed of sequences

A2 reverses the order of the columns after transposing

A3 export results to result.xlsx 

Turn back, A2 is changed to: =transpose(A1).(~.rvs()), note that the order of rows is reversed here