How to export lists from Vertec
Operating mode
Cloud Suite
|ON-PREMISES
Modules
Services & CRM
Budget & Phases
Purchases
Resource Planning
Business Intelligence
Via the menu button Export to Excel
, the displayed list is written directly to an Excel file, cached in the temporary folder and opened for the user.
In addition to the font and background colors, the data types are applied, and the cells are formatted accordingly in Excel. If there are summed columns in the list, they are also summed in Excel.
An exception is the export of time values to simplify subsequent calculations in Excel. Vertec exports time values as hours in decimal representation, even if they are displayed on the interface as hours:minutes. The rules are as follows:
Customers with Vertec on-premises can create a standard template for the Vertec Excel exports. As soon as one is available, this template will be used for all exports. This is useful, for example, if you want to add your company logo or a company-specific header or footer to the Excel exports of Vertec list views.
Create an Excel file and save it as VertecExport.xlsx
in the Vertec installation directory.
You can now customize this template as you like (font & font size, logo, cell formatting, etc.).
If an area called VertecStart
is defined in the template, the export starts at this point.
To define an area, select the appropriate row in the template and click Formulas > Define Name. Give the area the name VertecStart
: