This project has moved and is read-only. For the latest updates, please go here.

How to copy a set of cells and include formatting?

May 13, 2011 at 7:44 AM
Edited May 13, 2011 at 7:45 AM

Say I have a spread sheet and I would like to copy/paste a block of 4 rows and 10 columns.  Is there a way that I can do this and include all formatting?

I would like to copy merged rows and columns but haven't figured out how to do it.  Can this be done using EPPlus?  If so, could someone point me in the right direction

May 16, 2011 at 8:46 PM


No, merged cells are not copied, with the range.Copy method at the moment. Merged cells are handled a little bit different than other styles, so I have to add a separate rutine for that (in the Copy method).

I'll add that to my todo-list.

Mar 26, 2012 at 4:08 AM

Hey Jankallman,

Any chance you've had a moment to look at this functionality?