Aspose.Newsletter: Insert / Delete rows in an Excel Worksheet


Well-known member
Jan 21, 2007
Programming Experience
Welcome to the March 2008 issue of the Aspose Newsletter! In this month’s newsletter, we will provide some introductory information about our spotlight product: Aspose.ASPXpand. We will also look at the new and exciting features offered in the recent releases of Aspose.Words, Aspose.Pdf, Aspose.Cells, Aspose.BarCode and Aspose.Workflow. You will learn about the latest news from Aspose along with the monthly Tech-Tip, which demonstrates how you can insert / delete rows in an Excel worksheet?

Product Spotlight

Microsoft® did a wonderful job of marrying web development to a design environment that desktop programmers could embrace. However, the web environment lacks many of the features that so appealed to desktop developers. Aspose.ASPXpand helps bridge the gap between web and desktop development. Aspose.ASPXpand offers over 60 different functions ranging from Set Focus and Mask Edit to Auto Complete and handling the Enter Key. Aspose.ASPXpand works with all of the native web objects supplied with ASP.NET, making Aspose.ASPXpand easy to add to new code or existing code. Take the time to download the free evaluation version today to see how Aspose.Flash can work for you.

Aspose.Words for .NET released

Earlier this month Aspose.Words for .NET was released. With this release the support for Office Open XML documents officially came out of beta. This release also includes beta support for saving in Open Document Format (ODT). This release was soon followed by the and releases. These two releases contained numerous improvements and fixes for bugs present in the first release. For more information about the enhancements presented in these releases you are requested to visit their official release pages at here, here and here. The latest version of Aspose.Words for .NET can be downloaded from here.

Aspose.Pdf for .NET back in action

After an absence of almost 3 months, a new hot fix for Aspose.Pdf for .NET has been released. The latest version of Aspose.Pdf for .NET includes support for a new overloaded version of BindFO method, which accepts streams, and support for authentication when binding to HTML. This release also supports local hyperlink for table cells and data formatting in ImportDataTable and ImportDataView. In addition to this, also included are many improvements and numerous bug fixes. The latest version can be downloaded from here. For more details, please visit its official release page.

Exciting new demo and articles for Aspose.Words

We have published an interesting demo project that you might find useful. This demo project uses Aspose.Cells for .NET, Aspose.Words for .NET and about 1200 lines of custom code to convert Microsoft Excel workbooks to Microsoft Word documents. The demo can be downloaded from here. We also have a great new article about how to use Aspose.Words in a PHP project. You can use either Aspose.Words for .NET or Aspose.Words for Java. The article discusses pros and cons of both approaches and shows essential techniques.

File type auto-detection in Aspose.Cells for .NET

The latest release of Aspose.Cells for .NET version comes with the ability to automatically detect the file type when opening an Excel file. In addition to this the support for Excel2007 XLSX has been enhanced and XLS2PDF feature has been improved in this release. The release also comes with enhanced pivot table support and more functions in formula calculation engine. You will also find many improvements and numerous bug fixes in this release. For more information please consult the official release page. The latest version of Aspose.Cells for .NET can be downloaded from here.

USPS OneCode barcode recognition with Aspose.BarCode for .NET

The latest release of Aspose.BarCode for .NET version supports recognizing USPS OneCode barcode images, which makes Aspose.BarCode for .NET the first barcode recognition component in the market to have this feature. Aspose.BarCode can now recognize more than 22 barcode standards including both 1D barcodes and 2D barcodes. Numerous other improvements and bug fixes have also been included in this release. For more information please visit the official release page. Please download this latest release from here.

Aspose.Cells for Java released

We have released Aspose.Cells for Java version Included in this version is the support for adding Arc, Oval, and Rectangle to Excel files; as well as adding Word and Excel file as OLE object. Now you can copy the style when inserting rows and columns, get number format type of cell and filter non-blank/blank cells in AutoFilter. Also included in this release are numerous bug fixes and improvements. Please visit the official release page for more information. You can download the latest version of Aspose.Cells for Java from here.

Aspose.Workflow for .NET optimized for .NET 2.0

Aspose.Workflow for .NET version has been released. Aspose.Workflow is a distinct .NET based component that is used to manage workflow applications in order to automate business processes. The latest release has been optimized for the .NET 2.0 Framework. Also included in this release are updated samples for .NET 1.x and .NET 2.0 as well as updated help documents. Numerous bug fixes and improvements have also been incorporated into this release. For more information please visit the release page. The latest version is available for download from here.

Technical Tip – Insert / Delete rows in an Excel Worksheet

Do you wish to have worksheets that can be easily updated to keep up with your constantly changing business needs? Using Aspose.Cells APIs, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — calling a few methods only and your task is performed with excellence. While you are creating a new worksheet from scratch or working with an existing worksheet, you might need to add extra rows / columns into your worksheet to accommodate more data or for your specific need. Alternatively, it can also be required to delete rows / columns from specified positions / locations in the worksheet. To fulfill these requirements, Aspose.Cells provides simplest set of APIs that can easily perform your desired task within no time. There are two methods that Aspose.Cells offers in this regard i.e., InsertRows and DeleteRows, these two methods are optimized related performance and efficient enough to do the job very quickly.
So if you are in need to insert some sets of rows or remove a number of rows, it is recommended that you should always use InsertRows and DeleteRows methods instead of repeatedly using InsertRow and DeleteRow methods in a loop.

Aspose.Cells works in the same way as Microsoft Excel does. When rows or columns are added, the contents in the worksheet are shifted to downwards or right side but if rows or columns are removed, the contents in the worksheet will be shifted to upwards or left side. Moreover, the references in other worksheets are updated accordingly upon insertion / deletion of rows.

Following example shows the usage of InsertRows and DeleteRows methods


'Instantiate a Workbook object.
Dim workbook As Workbook = New Workbook
'Load a template file.
'Get the first worksheet in the book.
Dim sheet As Worksheet = workbook.Worksheets(0)
'Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.Cells.InsertRows(2, 10)
'Delete 5 rows now. (8th row - 12th row)
sheet.Cells.DeleteRows(7, 5)
'Save the excel file.

Aspose Newsletter is now available in four different languages

Collect the English version of this newsletter.
Collect the Japanese version of this newsletter.
Collect the Turkish version of this newsletter.
Collect the Chinese version of this newsletter.

Contact Information
Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465l
Top Bottom