The XLS Renderer is used to generate an Excel file. The generated output is compatible with Excel 97 or later.

XLS provides a Snap option that may improve (or worsen) the layout of Excel cells. When Snap is off, the cells are positioned exactly the same as in the report template. This means if there is a one pixel gap between two report elements, there will be a one pixel row or column in the Excel file. When Snap is enabled, all coordinates are adjusted to fit on a 4x4 pixel grid. This means a component at 9,11 will be adjusted to 8,8. This adjustment removes the very small cells used as spacers, but may adjust the layout slightly to accomodate the grid. You should try both Snap on and Snap off to see which works best for your template. In general, if you use HBox and VBox to do alignment, then Snap off will usually give the best results.

XLS supports the Paged render property. When the Paged check box is not selected the data will be displayed on one continuous worksheet in the Excel file. If the Paged check box is selected, the data will be split into multiple pages (based on the page setup) and displayed across multiple worksheets. When Paged is false, no page headers or footer will be rendered.