How to delete columns in OWC10?

[barbara_dave]

Hi All,

I have a VB.NET program and use OWC10 to display a spreadsheet. I want
to delete 1 column, but it failed. Here is my code:

obj.csvsheet.ActiveSheet.Range(Col_Header(i) & 1).DeleteColumns(1)

I also try:

obj.csvsheet.ActiveSheet.Range(Col_Header(i) & 1).EntireColumn.Delete
()

it failed too.

how to delete a column? please help me! thanks!

 

[barbara_dave]

Hi All,

I have a VB.NET program and use OWC10 to display a spreadsheet. I want
to delete 1 column, but it failed. Here is my code:

obj.csvsheet.ActiveSheet.Range(Col_Header(i) & 1).DeleteColumns(1)

I also try:

obj.csvsheet.ActiveSheet.Range(Col_Header(i) & 1).EntireColumn.Delete
()

it failed too.

how to delete a column? please help me! thanks!

Hi all,

I am still looking for the answer of this problem. Actually I have
code that is working for OWC9 in my Visual Studio .NET 2003 program,

mySheet.ActiveSheet.Range(Col_Header(i) & 1).DeleteColumns(1)

but it doesn't work for OWC10. Why? How to make it work for OWC10 in
Visual Studio 2005?

Thanks in advance!!!

 

[Alvin Bruney [ASP.NET MVP]]

What error are you seeing? Why don't you just try hiding the column?

--
Regards,
Alvin Bruney

Want a free copy of VS 2008 w/ MSDN premium subscription?
Details at http://msmvps.com/blogs/alvin/Default.aspx

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc