Inserting a column using C# and Excel 2000

[rkappini]

I need to programmatically insert a column in the first column of an
Excel sheet. I tried using the code
wsSheet.Columns.EntireColumn.Insert(Excel.XlInsertShiftDirection.xlShiftToRight);

and I even tried creating a range and shifting the range to the right
and then inserting a column, but that didn't work either.

Am really in need of help here.... please let me know if there is some
code i can use. And for some reason
oWSheet.Columns(1).Insert
doesn't work either.

 

[Nick Hodge]

I'm not going to be much help here, but to confirm in VBA you would use

Worksheets("Sheet1").Columns(1).Insert

Therefore as you have a reference to the worksheet object it should work. I
can only presume you should check the .NET side, imported namespace?
properly reference the worksheet object?

Do you get any build errors?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk

 

[rkappini]

Thanks Nick. For some reason I couldn't access a column using
wsSheet.Columns(1)... that gave me an error. Anyways, I used a range
and inserted a column... am sure there's a much better way to do it but
this goes for now Thanks!