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.
( Copy Range Data with Style|Documentation )
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.