How to reverse all the columns in an Excel file

[Alom_R]

Hi All,

I need to reverse all the columns in an Excel file but don’t know how to do, please help me.

Regards,
Ruhul.

[William_Blech_Sister]

Hy @Alom_R,

Data Tables variables: dt_Reverse, dt_Original

Thry this line of code:
dt_Reverse = dt_Original.AsEnumerable.Reverse.CopyToDataTable

Regards

[ppr (Peter)]

I do understand your request that the columns are to reorder (inital First Columns should be the last one …)
like:

so this can be done by

• clone the datatable - dtReversed from original DataTable dtData
• reverse the columns with the setOrdinal method
• iterate over dtData, take the ItemArray for of each row, reverse it and add it to dtReversed

find some starter help here:
DT_ReverseColumns.xaml (8.5 KB)

[hasan_mousavi]

, {
extend: ‘pdfHtml5’,
exportOptions: {
orthogonal: “PDF”,
columns: [1, 2, 3, 4, 5],
alignment: ‘right’,
},

                    customize : function(doc) {
                        //console.log(doc.content[1].table.body[0].reverse());
                        doc.content[0]['text']=doc.content[0]['text'].split(' ').reverse().join(' ');


                        for(var i=0;i<doc.content[1].table.body.length;i++)
                        {
                            doc.content[1].table.body[i]=doc.content[1].table.body[i].reverse();
                            console.log(doc.content[1].table.body[i].length);
                            for(var j=0;j<doc.content[1].table.body[i].length;j++)
                            {
                                doc.content[1].table.body[i][j]['text']=doc.content[1].table.body[i][j]['text'].split(' ').reverse().join(' ');
                            }
                        }
                        console.log(doc);

                        doc.defaultStyle.font = 'IRANSansWeb';
                        doc.defaultStyle.alignment = 'center';

                        doc.styles.tableHeader.alignment = 'center';


                    }
                }