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

Free Support Forum - aspose.com

Format painter for a range of cells?

I have an area of formatted cells (shaded cells, merged cells, borders) that is 9 columns wide by 15 columns long. I am outputting collections of data from my database and for each object, I need to make one section for it. Therefore, I was hoping to have a template file with one formatted section, and then for each object I have, copy the formatting exactly with format painter and then insert my data as need be.

How can I use format painter to copy the formatting of this range and apply it to another cell/range? Thank you.

Hi,

Thank you for considering Aspose.

You can try Range.CopyStyle API to only Copy the style of the range. Please see the following article for further details and sample codes.

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/copy-range-style-only.html

Thank You & Best Regards,