User's Guide > About the User's Guide > Word and Excel Templates > Excel Templates > Available Variables in Scripts (scope)
Available Variables in Scripts (scope)
The following objects are accessible in the scripts:
Name
Class
Explanation
engine
JETTExcelTemplateRen- derer
The template renderer engine.
applicationContext
ApplicationContext
The spring's ApplicationContext that can be useful to get access to DAOs or Manager objects using applicationContext. getBean(...) calls
user
UserDto
The user executing the export.
request
HttpServletRequest
The current HTTP request.
now
Date
The current date and time.
cbBaseUrl
String
The URL pointing to the Codebeamer server so that links can be generated.
numberFormat
NumberFormat
The number formatter.
textFormatter
TextFormatter
Renders text and localized messages.
items
List<TrackerItemDto>
The items (bug, issue, requirements) being exported.
cell
Cell
The POI cell being processed.
sheet
Sheet
The POI sheet being processed.
workbook
Workbook
The POI workbook being processed.
dates
com.intland.Codebeamer. text.excel.Dates
Various date constants for easy date filtering. For more information, see Excel Templates
You can use ALL objects from Word export.
For more information about the Java objects and their properties, refer to the JavaDoc file codebeamer-api-<version>.zip that you can find in your Codebeamer installation at the following path: \CB-<version>\tomcat\webapps\cb\, for example: \CB-2.2.0.0\tomcat\webapps\cb\codebeamer-api-2.2.0.0.zip.
Was this helpful?