Aspose Cells Java: Copy a row without values

I want to copy a Row to another position. I want everything to be copied(formatting, style etc) except for the values. Is there any way to do it?

@sandipanghosh111,

Thanks for the query.

You may try to use Cells.copyRows() method to accomplish the task for your requirements. See the example code which copies a row (from source sheet to destination sheet) with values and formattings. If you need to copy formattings/style only (and not values), you will use PasteType.FORMATS enumeration member for PasteOptions:

Also, you will adjust the code a bit accordingly for source row index and destination row index as you want to copy a row in the same worksheet.