Page Break Excel PHP XML

slim dan

New Member
I am trying to insert a page break automatically, I would like to have some help. My current code inputs page breaks manually, is there any way to insert a page break automatically after some key word? Thank!\[code\]<html xmlns:v='urn:schemas-microsoft-com:vml'xmlns:o='urn:schemas-microsoft-com:office:office'xmlns:x='urn:schemas-microsoft-com:office:excel'xmlns='http://www.w3.org/TR/REC-html40'><head><style type="text/css">@page{mso-page-orientation:landscape;}td{text-align:center;}td.code{mso-number-format:\@}td.cost{mso-number-format:0\.00000}td.date{mso-number-format:mm\/dd\/yy \[$-F400\]h\:mm\:ss\\ AM\/PM}</style><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:WorksheetOptions><x:Print><x:ValidPrinterInfo/><x:HorizontalResolution>1200</x:HorizontalResolution><x:VerticalResolution>1200</x:VerticalResolution><x:Scale>70</x:Scale></x:Print><x:Selected/><x:DoNotDisplayGridlines/><x:ProtectContents>False</x:ProtectContents><x:ProtectObjects>False</x:ProtectObjects><x:ProtectScenarios>False</x:ProtectScenarios></x:WorksheetOptions><x:PageBreaks><x:RowBreaks><x:RowBreak><x:Row>21</x:Row></x:RowBreak><x:RowBreak><x:Row>50</x:Row></x:RowBreak><x:RowBreak><x:Row>77</x:Row></x:RowBreak><x:RowBreak><x:Row>105</x:Row></x:RowBreak></x:RowBreaks></x:PageBreaks></x:ExcelWorksheet></x:ExcelWorksheets><x:WindowHeight>12780</x:WindowHeight><x:WindowWidth>19035</x:WindowWidth><x:WindowTopX>0</x:WindowTopX><x:WindowTopY>15</x:WindowTopY><x:ProtectStructure>False</x:ProtectStructure><x:ProtectWindows>False</x:ProtectWindows></x:ExcelWorkbook></xml><![endif]--></head>\[/code\]
 
Back
Top