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

Sujeet Raman

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujeet Raman5y ago
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 C5y ago
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?
Sachin Singh5y ago
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());