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

Free Support Forum - aspose.com

Insert Copied Cells

In Excel there is options “Insert Copied Cells”.

how we can achieve this using Aspose.Cells

Please help me in this

Hi Jaganlal,

Thanks for your posting and considering Aspose.Cells.

You can copy and paste source range to destination range using the Range.Copy() method. One of the Range.Copy() method takes PasteOptions as a parameters. You can specify your required paste option via PasteOptions.PasteType which can be one of the following.

PasteType.Formats
PasteType.Formulas
PasteType.All
PasteType.Comments

etc.

We think, this should fullfill your needs. Let us know if you encounter any issue, we will look into it and help you asap.

We also recommend you to see the following documentation article that explains how to use Range.Copy() method.

( http://www.aspose.com/docs/display/cellsnet/Copy+Range+Data+with+Style )

If it does not fulfill your needs, then please provide us screenshot and sample xls/xlsx files explaining your requirements in detail, it will help us look into your issue precisely and we will be able to help you.