Column values Lost After Re-order columns in c# excel interop

Question

Hi,

how can i re order my columns following way.i used this syntax but i lost particular coloumn data'

Excel.Range copyRange = xlWorksheet.Range["A:A"];
Excel.Range insertRange = xlWorksheet.Range["P:P"];
insertRange.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, copyRange.Cut());

ORIGINAL

"Account_No";
"FIRST_NAME";
"MIDDLE_NAME";
"LAST_NAME";
"Effective_Date";
"Birth_Year";
"SSN";
"Gender";
"Tobacco";
"ADDR_LINE1";
"CITY_NAME";
"ZIP_CODE";
"PCP ID ";
"Policy No";/N
"Product Offering ";
"State";

How can i reorder below coloumns like first one with out lose data

Sachin Singh · Answer

No, your answer is correct and the value doesn't lost, again test it . Excel.Application xlApp = new Excel.Application(); Excel.Workbook xlWb = xlApp.Workbooks.Open(@ "C:\myExcel.xlsx" ); Excel.Worksheet xlWs = (Excel.Worksheet)xlWb.Sheets[1]; // Sheet1 xlApp.Visible = true ; // cut column A and insert into P, shifting columns right Excel.Range copyRange = xlWs.Range[ "A:A" ]; Excel.Range insertRange = xlWs.Range[ "P:P" ]; insertRange.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, copyRange.Cut());

Sujeet Raman · Answer

data lose happening multiple ordering.how to do it? i did like this Excel.Range copyRange = xlWorksheet.Range["A:A,H:H,DD"]; Excel.Range insertRange = xlWorksheet.Range["P:P,MM,NN"]; insertRange.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, copyRange.Cut());

Ganesan C · Answer

do you have data in 'P' column also? your is issue is your are moved 'A' column with data to 'P' column and you lost old values in the 'P'coulmn? am i right or not?