We are using HTML/XML/CSS to export a table to excel 2007.I have the below code setup, which when the HTML page loads, it then exports the data to Excel. The first two rows are set as frozen panes, which is great while viewing the document, but does not print those rows on every printed page. All of my page data is in table tr-th tr-td format.the block towads the bottom (i have read) is supposed to make the first row print on every printed page... but it is not.I have also read that the .... section, should print the first rows on every page, but this does not seem to work either.Any suggestions, ideas or answers are appreciated!!\[code\] header("Cache-Control: public, must-revalidate"); header("Pragma: no-cache"); header ('Content-type: application/vnd.ms-excel'); header ('Content-Disposition: attachment; filename=StoreVsCompany.xls'); echo ' <html xmlns:x="urn:schemas-microsoft-com
ffice:excel"> <head> <!--[if gte mso 9]> <xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>VendorAgendaSummary</x:Name> <x:WorksheetOptions> <xageSetup> <x:Layout x:Orientation="Portrait"/> <x:Header x:Margin="0.3"/> <x:Footer x:Margin="0.3"/> <xageMargins x:Bottom="0.75" x:Left="0.5" x:Right="0.5" x:Top="0.75"/> </xageSetup> <x:FitToPage/> <xrint> <x:FitHeight>100</x:FitHeight> <x:ValidPrinterInfo/> <x:HorizontalResolution>600</x:HorizontalResolution> <x:VerticalResolution>600</x:VerticalResolution> </xrint> <x:FreezePanes/> <x:FrozenNoSplit/> <x:SplitHorizontal>2</x:SplitHorizontal> <x:TopRowBottomPane>2</x:TopRowBottomPane> <x:SplitVertical>2</x:SplitVertical> <x:LeftColumnRightPane>2</x:LeftColumnRightPane> <x:ActivePane>0</x:ActivePane> <xanes> <xane> <x:Number>3</x:Number> </xane> <xane> <x:Number>1</x:Number> </xane> <xane> <x:Number>2</x:Number> </xane> <xane> <x:Number>0</x:Number> <x:ActiveRow>0</x:ActiveRow> <x:ActiveCol>1</x:ActiveCol> </xane> </xanes> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> </x:ExcelWorkbook> <x:ExcelName> <x:Name>Print_Titles</x:Name> <x:SheetIndex>1</x:SheetIndex> <x:Formula>=\'strWorkBookName\'!$1:$1</x:Formula> </x:ExcelName> </xml> <![endif]--> </head>'; \[/code\]
ffice:excel"> <head> <!--[if gte mso 9]> <xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>VendorAgendaSummary</x:Name> <x:WorksheetOptions> <xageSetup> <x:Layout x:Orientation="Portrait"/> <x:Header x:Margin="0.3"/> <x:Footer x:Margin="0.3"/> <xageMargins x:Bottom="0.75" x:Left="0.5" x:Right="0.5" x:Top="0.75"/> </xageSetup> <x:FitToPage/> <xrint> <x:FitHeight>100</x:FitHeight> <x:ValidPrinterInfo/> <x:HorizontalResolution>600</x:HorizontalResolution> <x:VerticalResolution>600</x:VerticalResolution> </xrint> <x:FreezePanes/> <x:FrozenNoSplit/> <x:SplitHorizontal>2</x:SplitHorizontal> <x:TopRowBottomPane>2</x:TopRowBottomPane> <x:SplitVertical>2</x:SplitVertical> <x:LeftColumnRightPane>2</x:LeftColumnRightPane> <x:ActivePane>0</x:ActivePane> <xanes> <xane> <x:Number>3</x:Number> </xane> <xane> <x:Number>1</x:Number> </xane> <xane> <x:Number>2</x:Number> </xane> <xane> <x:Number>0</x:Number> <x:ActiveRow>0</x:ActiveRow> <x:ActiveCol>1</x:ActiveCol> </xane> </xanes> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> </x:ExcelWorkbook> <x:ExcelName> <x:Name>Print_Titles</x:Name> <x:SheetIndex>1</x:SheetIndex> <x:Formula>=\'strWorkBookName\'!$1:$1</x:Formula> </x:ExcelName> </xml> <![endif]--> </head>'; \[/code\]