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?

Improve company productivity with a Business Account.Sign Up

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.