It sounds like what you want is the single cell data option. You can find this in the help documentation inside the Excel Reports Module:
This works by creating a named range such as "voltage" and then in your excel template give a single cell the named range of voltage.lastValue
Now link your voltage data point to the voltage named range.
From the help documentation:
Mango Data Available
Mango can insert various types of data into an Excel named range. Some are single cell while others require a column or row.
Single Cell Data
Single cell data can be assigned into cells by creating a named range with a .{data_name} postfix. For example to insert the XID for a data point one would use the named rangevoltage.average. Then via the Mango template configuration page one can link a data point to a named range of voltage. This will allow any named range that starts with voltage prefix to be filled in the the available single cell data. The following are a lists of available single cell data:
For any point:
xid - The XID of the linked point
name - The name of the linked point
deviceName - the device name of the linked point
For Numeric Points:
firstValue - The first value of the time period
firstTime - The date of the first value of the time period
lastValue - The last value of the time period
lastTime - The date of the last value of the time period
minimumValue - The statistical minimum value of the time period
minimumTime - The date of the statistical minimum value of the time period
maximumValue - The statistical maximum value of the time period
maximumTime - The date of the statistical maximum value of the time period
average - The statistical average value of the time period
integral - The statistical integral value of the time period
sum - The statistical sum of the time period
count - The count of samples within the time period
See more in the help documentation