Copy worksheet don't pass header and footer

Jun 27, 2012 at 4:52 PM

Hi, my name is Joao,

I'm trying to copy worksheet using an excel template with header and footer, but in the result doesn't appear both. Only the data and cells appears. I use this method to copy my sheet1.

  IXLWorksheet sheet_new = sheet_old.CopyTo("Sheet_new"); 

Can you help me out?

Thank you very much.