Free Support Forum - aspose.com

Header and detail records in spreadsheet

Hi

I wonder if anyone can help me.

I have a spreadsheet with header and detail records which are grouped into sets of one header with one or more detail records.

I need to read the header and then read all the related detail records and write them to a database table which contains the info from the header and one record for each detail record.

Does anyone have examples of how to do this?

Hi,

Thanks for your interest in Aspose.Cells for Java.

For header and footers, please refer to this document: Setting Headers and Footers

Since you want to read header and footers, so you should use the equivalent getter functions like

e.g

worksheet.getPageSetup().getLeftHeader();
worksheet.getPageSetup().getRightHeader()