We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Can I insert row without previous row format?

I use InsertRow() to insert new row. New(inserted) row have same format as previous row. Can I disable it?

Currently InsertRow method copys format as previous row. That’s the routine same as MS Excel. I will add a new method to enable you to disable it.


We would like to inform you that Aspose.Cells has replaced Aspose.Excel which is no more continued now. This new product supports all the latest features of MS Excel as well as the features present in Aspose.Excel. You can use it to insert rows with or without formatting as shown below:

// Creating a file stream containing the Excel file to be opened

FileStream fstream = new FileStream("book1.xls", FileMode.Open);

// Instantiating a Workbook object

// Opening the Excel file through the file stream

Workbook workbook = new Workbook(fstream);

// Accessing the first worksheet in the Excel file

Worksheet worksheet = workbook.Worksheets[0];

// Setting Formatting options

InsertOptions insertOptions = new InsertOptions();

insertOptions.CopyFormatType = CopyFormatType.Clear;

// Inserting a row into the worksheet at 3rd position

worksheet.Cells.InsertRows(2, 1, insertOptions);

// Saving the modified Excel file


// Closing the file stream to free all resources


Here is a detailed article about formatting the cells:
Inserting and Deleting Rows and Columns

Here is the link to the latest version of this new product for free trials:
Aspose.Cells for .NET (Latest Version)

A comprehensive detailed solution is available here which contains hundreds of ready to run examples for testing different features of this product.