Hello Aspose team,
We are trying to export an excel file by combining multiple excel files. While doing so we are using the following function
workbook1.combine(workbook2)
But, upon using the above mentioned function, the header and footer are not available on the first page. However, header footer can be seen from the second page onward. We are using aspose cell version 20.5.
Sample Code:
void "test census header"() {
Workbook workbook1 = new Workbook()
Workbook workbook2 = new Workbook("src/test/groovy/resources/input_template_pa_censusReport.xlsx")
workbook1.combine(workbook2)
workbook1.save("src/test/groovy/resources/output_template_pa_censusReport.xlsx")
expect:
true
}
Would you please look into this issue?
The input and output files is attached here resources.zip (59.3 KB)
Thanks,
Astha