Excell

Technology in the Spotlight…

Excel Features

XLReporter for Reporting

One of the best things about generating reports with XLReporter is that you can take advantage of all the great features Excel has to offer. Features like charts, formulas, custom formatting, custom macros and much more can all be included as part of your report solution. The following highlights a few Excel features that can be used in your reports. The Chart Range connection is usually invoked after the data has been written to the report so that it can recalibrate the chart series based on the actual amount of data in the report.

Formulas and Functions

Another great feature of Excel is the ability to embed formulas into cells to calculate data. In addition, an impressive list of built-in functions is provided that can be used to summarize data.

Charting

Charting is one of the most powerful features of Excel. Any cell or range of cells can be summarized in an embedded chart. Excel provides a vast number of chart types and options. Any chart you can configure in Excel you can use as part of your report solution. When configuring a chart for a template with XLReporter, you start by selecting the type of chart you want.

Inserting a Function

Formulas can range from the simple “=B11+C11” that adds 2 cells values together to a complex statement like, “=OFFSET(B11, MATCH(B6, B11:B35, 0),0)” that can be used to get the timestamp of the minimum or maximum value in the report. Formulas in Excel require cell ranges as input e.g., AVERAGE(B11:B35). When it comes to specifying the cell range for the formulas used in a template, you have two options. If you know the exact cell range of the data in the report, set the cell range for each formula in the template accordingly. However, if you don’t know the exact cell range, then set the range for each formula to only the top row of cells where the data will be written. In this case, you will need to add a Formula Range connection using...