Is there a method from which I can the get the header and footer information of a worksheet.
Currently we only allow to set header and footer. Could you please tell me why you need this feature?
Thank you for the respose.
We needed to copy the header and footer information from one worksheet to another.
We have generated spreadsheet ML using XSLT and we want to save it into XLS format using Aspose. But Aspose removes the header and footer tags from the spreadsheet ML. We have Excel template to which we copy the data from the spreadsheet ML. We also want to copy the header and footer from these spreadsheet ML files on to the templates.
Have you tried the latest v3.0.3? Header/footer tags in spreadsheetML are now supported. And when you use Worksheet.Copy method, those information are also copied.