This project has moved. For the latest updates, please go here.

Delete a Row

Dec 2, 2015 at 4:53 AM
Edited Dec 2, 2015 at 4:59 AM
NetOffice is fantastic. I have managed to work out how to do most actions. Some are slightly different to how I would execute in a Excel Macro.

I am just stuck on how to delete a row. How can you delete a row in a open Excel.Worksheet?

Thx.
Dec 2, 2015 at 5:11 AM
Ok... The following works. I found this in a code snippet in another thread.
                    Excel.Range range = workSheet.Range("A" + currentRow);
                    range.EntireRow.Delete(Excel.Enums.XlDeleteShiftDirection.xlShiftUp);
I couldn't find this initially because Intellisense is not showing the EntireRow property. If I type it in directly it works????

I am using Visual Studio 2015 and have had a few issues using NetOffice classes not showing correctly with Intellisense. Anyone else having this issue?
Marked as answer by TonyZad on 12/1/2015 at 9:17 PM
Coordinator
Dec 2, 2015 at 7:39 PM
hey men,

i'm sorry for that. The EntireRow,EntireColumn property is marked as hidden in NetOffice 1.7.3. I've been changed this in latest source state and want publish them in NetOffice 1.7.4 if you find more hidden stuff - please let me know.

BTW: An easy bypass for the issue is to activate the option "show hidden/advanced members" in the VS Tools/Options menu(restart recommended).


*Sebastian