How can i know about the page breaks that occur in excel sheet during report gen

[Tweetz]

Hello,

I am trying to generate an Excel report with a large number of columns. and i am facing the problem of some of the columns not fitting into the page due to the page break. as a result, these columns are being printed at the end of the report. I would like to add the Row and Column headers to the remaining of the columns so that it is easy to recognise as to which table they belong to. i would like to know if there is any method to find out when the page break occurs in the excel sheet, along with the last printed column number, so that it would be easy for me to add the Row and Column headers before the next row/column is printed.

Thank You

Regards

Tweetz.

[Devin_K]

Hi Tweetz,

I have tried to find a way to do what you are asking, but have been unsuccessful.  However, you can control where the page breaks occur by using the "New Report Page.vi".  You can call this VI after appending the table to the report, and specify the cell where you wish to insert a new page break (using the "position" or "name" elements of the "MS office parameters" input).  If you know the page size and you specify the column widths, you should be able to pick reasonable places to start a new page.

I hope that helps!