Solved

Add an excel row programmatically ?

Posted on 2012-03-22
2
679 Views
Last Modified: 2012-03-22
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
Comment
Question by:PhilippeRenaud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
Frank White earned 500 total points
ID: 37752248
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
 
LVL 1

Author Comment

by:PhilippeRenaud
ID: 37752251
It worked !

thank you.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question