Thanks for your query.
Please see the sample code to accomplish your task, you may refer to the code segment and may add/update lines of code by yourselves for your needs accordingly:
Workbook sourceWorkbook = new Workbook("e:\\test2\\BookA1.xlsx");
Workbook destWorkbook = new Workbook("e:\\test2\\BookB1.xlsx");
Worksheet sourceSheet = sourceWorkbook.Worksheets["XX"];
Worksheet destSheet = destWorkbook.Worksheets["NN"];
Aspose.Cells.Range sourceRange = sourceSheet.Cells.CreateRange("A7:M7");
Aspose.Cells.Range destRange = destSheet.Cells.CreateRange(sourceRange.FirstRow, sourceRange.FirstColumn, sourceRange.RowCount, sourceRange.ColumnCount);
PasteOptions options = new PasteOptions();
options.PasteType = PasteType.All;
Also, see the document on how to copy ranges for your further reference:
Hope, this helps a bit.