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

Free Support Forum - aspose.com

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:
https://docs.aspose.com/display/cellsjava/Copying+Rows+and+Columns#CopyingRowsandColumns-PastingRows/ColumnswithPasteOptions
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.