Change position of Columns In Excel file using C# -

hello,

i'm using microsoft.office.interop in c#. there easy way change columns position of excel worksheet.

example: position of first column 1. position of second column 2. . . . position of tenth column 10.

what need change position, example : position of first column 5.

thanks in advance response.

try this..

// cut column c , insert a, shifting columns right

    excel.range copyrange = xlws.range["c:c"];     excel.range insertrange = xlws.range["a:a"];     insertrange.insert(excel.xlinsertshiftdirection.xlshifttoright, copyrange.cut());