How to Insert Excel Spreadsheet Page Breaks using a CSV source file

Copper Contributor

I output formatted CSV files from my data base programs and then load them into a PC/Win10 MS Office 365 Excel spreadsheet to display, print and manipulate the exported data. I am looking for a way to insert page breaks into the source csv file that will cause Excel to insert page breaks at the lines specified from the CSV file. I want to avoid having to manually enter the page breaks in page_break_view if possible. Is there a way to achieve this, ie, is there an escape code that the CSV input interpreter will recognize as a page break insertion?

1 Reply

@murray_ruben 

A CSV file is a plain text file without any formatting information; as far as I know you cannot specify page breaks.