Hi,
Is there a way we can retreive the headers from an Excel file, without having to completely load it into a datatable? (which causes much load time for very big files).
Regards,
Calago
// Get text and image in the left header
string headerLeftText = worksheet.PageSetup.LeftHeader;
Image headerLeftImage = worksheet.PageSetup.LeftHeaderImage;
// Get text and image in the center header
string headerCenterText = worksheet.PageSetup.CenterHeader;
Image headerCenterImage = worksheet.PageSetup.CenterHeaderImage;
// Get text and image in the right header
string headerRightText = worksheet.PageSetup.RightHeader;
Image headerRightImage = worksheet.PageSetup.RightHeaderImage;