Free Support Forum - aspose.com

Add / copy excel sheet formatting

I’m creating a template excel file and then copying the template sheet to build reports. It’s working ok, but i have two problems;

1) The footer margin isn’t being copied correctly and
2) The custom header image isn’t being copied along with the rest of the sheet.
Can you take a look at this?

thanks,
Dave

Hi Dave,

About 1), please try the attached fix.

About 2), currently Aspose.Excel doesn’t support this feature.

Laurence wrote:
Hi Dave,

About 2), currently Aspose.Excel doesn't support this feature.


How would I populate the middle section of the header with an image using aspose code?

thanks,
David

You can only put the image in your template and use Excel.Open method to import it.

Laurence wrote:
You can only put the image in your template and use Excel.Open method to import it.


Isn't this all kind of circuitious? If the image is in the template sheet and I do an add/copy everything in the template sheet should appear in the new sheet.

Image header/footer is a new feature since ExcelXP. Now Aspose.Excel can only load it in a template but cannot copy them or add them at run time.

I will check this issue. But it may take a relatively long time for it is complex.