Insert Column in Excel doesn't work in C#

Question

using Excel = Microsoft.Office.Interop.Excel;


Excel.Range r = sheet.get_Range(ExcelAssistant.c1ToA(Column_Date + i) + Row_Date_Insert, ExcelAssistant.c1ToA(Column_Date + i) + (Row_Date_Insert + sheet.UsedRange.Rows.Count));

Console.WriteLine("range r property" + r.Address);

r.Insert(Excel.XlInsertShiftDirection.xlShiftToRight,Missing.Value);
r.Insert();
sheet.Columns[Column_Date + i].insert();

ExcelAssistant is an Excel Util class and it has static method c1ToA to transfer the interger of the column number into the "ABC" Format.

I use the Console.WriteLine to ensure I point to correct position.

Then I tried several insert method above but none works.

What' wrong?

Any help may be appreciated.

And you may try to see Console.WriteLine(r.Parent.Name) to see whether you are refering the correct worksheet. — Vityata
– Vityata, Commented Aug 1, 2017 at 14:09

Vityata · Accepted Answer · 2017-08-09 12:16:36Z

1

This is how you insert a column:

r.EntireColumn.Insert()

Take a look here as well: Insert Columns between columns in excel

answered Aug 9, 2017 at 12:16

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

张绍峰 Over a year ago

Well,I forgot to insert column in other sheets in a loop .So I always get the wrong result.Thank you,again.

张绍峰 Over a year ago

I only have the first sheet inserted the column,but I have never checked it until now.

Collectives™ on Stack Overflow

Insert Column in Excel doesn't work in C#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related