[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 763
  • Last Modified:

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.. !
0
PhilippeRenaud
Asked:
PhilippeRenaud
1 Solution
 
Frank WhiteCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now