oneExcelSheetPerPage

This parameter supports for rendering sheets in the excel document.

You can use the server-side parameter oneExcelSheetPerPage for rendering one excel sheet in one page. An excel document can have multiple columns and rows in a sheet, which might make the width and height of the sheet exceed the viewer's window and split the content of one sheet in to multiple view pages. If you set the parameter value to true, the content of one sheet is rendered in to a single page. By default the value of oneExcelSheetPerPage is set to false, which renders the content of one sheet in to multiple view pages.
Note:
  • You must restart the server after you set the server-side parameter.
  • If the excel sheet is too large to fit on a single page, it will automatically render across multiple pages with the best possible fit.

Sample syntax

<param name="oneExcelSheetPerPage" value="true">

The default value of this parameter is false.