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?
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.