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,