This article explains how to programmatically get headers and footers from Excel or OpenOffice files using the C++ API or Library....Headers and footers are displayed only in Page Layout view, Print Preview...can insert headers and footers only by using the Page Setup dialog...