We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How do I efficiently delete many rows from a named range

Thread ID:

Created:

Updated:

Platform:

Replies:

47330 Aug 2,2006 07:21 PM UTC Aug 2,2006 07:49 PM UTC Windows Forms 1
loading
Tags: XlsIO
Robert Chapman
Asked On August 2, 2006 07:21 PM UTC

I load a template file and drop data into named ranges on the template.

Sometimes the data does not require all of the rows in the range. I want to be able to

sheet.Range(row, col, lastrow, last).Delete

but I cant find a way to do this.

To iterate over the list takes to long. I want to be able to delete all of the rows at once.

How do I efficiently delete many rows from a named range

Robert Chapman
Replied On August 2, 2006 07:49 PM UTC


It takes 4 mins to delete 900 rows in a named range


>I load a template file and drop data into named ranges on the template.

Sometimes the data does not require all of the rows in the range. I want to be able to

sheet.Range(row, col, lastrow, last).Delete

but I cant find a way to do this.

To iterate over the list takes to long. I want to be able to delete all of the rows at once.

How do I efficiently delete many rows from a named range

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;