Add an excel row programmatically ?

Hello EE,

I have a OWC11  (AxSpreadsheet) in my vb.net form.

I have some data on Row 1

I would like to add a row before that current row so it goes to Row 2 and that Row 1 would be blank

I tried to search on internet, it must be something like myspreadsheet.ActiveSheet.Rows.Insert but I couldnt find any good answers working.


can you help?

Its just a simple row to add and I cant do it.. !
LVL 1
PhilippeRenaudAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Frank WhiteConnect With a Mentor Commented:
If this were directly in Excel, it would be as simple as:

ActiveWorkbook.ActiveSheet.Range("A1").EntireRow.Insert

I'm not sure if/how that would be different for within a VBNET form.
0
 
PhilippeRenaudAuthor Commented:
It worked !

thank you.
0
All Courses

From novice to tech pro — start learning today.