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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Insert cells... shift down or right

Thread ID:

Created:

Updated:

Platform:

Replies:

123780 Apr 20,2016 09:57 PM UTC Apr 26,2016 06:53 AM UTC ASP.NET MVC 5
loading
Tags: XlsIO
Mark
Asked On April 20, 2016 09:57 PM UTC

Hi, is it possible to replicate this option in Excel...?


i.e. insert a range of cells and push the existing cells down like this...

Insert Cells... Shift cells down


Thanks,
Mark


Abirami Varadharajan [Syncfusion]
Replied On April 21, 2016 12:58 PM UTC

Hi Mark,

Thank you for contacting syncfusion support.

Yes, it is possible to insert rows in between the existing cells using InsertRow method . We have shared a sample for your reference which can be downloaded from the following link.

Code Example:

Worksheet.InsertRow(int iRowIndex, int iRowCount, ExcelInsertOptions insertOptions);

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/InsertCells-298069843.zip

Kindly try this sample and you can also refer the below UG documentation link, to know more about ExcelInsertOptions.

UG Documentation link http://help.syncfusion.com/cr/cref_files/windowsforms/xlsio/Syncfusion.XlsIO.Base~Syncfusion.XlsIO.ExcelInsertOptions.html

Please let us know if you have any concerns.

Regards,
Abirami.

Mark
Replied On April 21, 2016 09:38 PM UTC

Thanks, but that method inserts an entire row, not a range.

See my original post for an example.

Mark

Abirami Varadharajan [Syncfusion]
Replied On April 22, 2016 12:48 PM UTC

Hi Mark, 
 
Currently, there is no direct method to insert cells. But your requirement can be achieved through a workaround, we have created a custom method Insertcells to insert cells in between the existing cells and you can move them right or down. The sample illustrating this behaviour can be downloaded from the following link. 
 
 
Please let us know if you have any concerns. 
 
Regards, 
Abirami. 


Mark
Replied On April 25, 2016 11:40 PM UTC

OK, thanks.

Abirami Varadharajan [Syncfusion]
Replied On April 26, 2016 06:53 AM UTC

Hi Mark, 
 
Thank you for updating us. 
 
Please let us know if you need any further assistance on this. 
 
Regards, 
Abirami. 
 


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

;