How can I use Format Painter in Excel ??
Do you mean that you want to set a range of cells with same formattings? Please check http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/FormatRoutine.html .
Thanks for the reply.
I needed the format painter to hide the row outlines for the 2 rows and show for the 3rd row so that 3 rows will look like a single cell. I can achieve this in excel throw format painter?? I'm wondering how can we achieve through aspose.
Sorry, I am not clear about your need. Do you mean merged cells? Could you post a sample file here to show your need?