Export

ExportImg01

Standard Action Export has the following properties:

Category Property  
General Properties Caption ExportImg02
Tooltip
Enabled by Default
Behavior
Google Drive Web Panel
Base Location
Use External Storage Provider
Style Control Type
Image Type
Image
Image Class
Disabled Image
Disabled Image Class
Action Group Control Type
Action Group Button Class
Action Group Disabled Button Class
Button Class
Disabled Button Class
Template Excel File Extension
Consider User Conditions
Show Filters
Filters Color
Column Titles Color
Template
Start Row
Start Columns
Include Totalizers
Totalizers Format
Include Conditional Formatting
Export FIle Title
Title Color
Columns Selector Export Only Visible Columns
Columns order  


In order to read about the properties Caption, Tooltip, Enabled by Default, Control type, Image, Image class, Disabled Image, Disabled Image Class, Action Group Button Class and Button Class follow this link: Standard Actions

General Properties:

Caption

Caption for buttons, and for grid column if no image is specified.

Tooltip

Action tooltip.

Enabled by Default

Indicates wheather to include this action by default.

Behavior:

Specifies the bevahior that the action Export will have when the end user clicks in it. The options are:

  • Download Excel File: it will download the information of the records and the filters to an Excel file document so that end users can open it.
  • Upload to Google Drive: it will open a Web Panel in which the end user will select whether to download it to an Excel file or upload it to Google Drive. There are some configurations needed in order to achieve this, which are documented on the section: Google Drive .

Google Drive Web Panel:

Specifies the Web Panel that will be opened when clicking in the action to export to Excel, when the property 'Behavior' has the value 'Upload to Google Drive'.

Base Location:

Specifies the base location for the generated files. If you want to save the Excel file in some folder within the web application, you could set it here. For example: PublicTempStorage\

Use External Storage Provider

Three possible values:

- True
- False
- Default

 

 

Properties Of Category Style:

Control type

The control to include in the form. If the action is a grid action and 'Button' is selected, a variable will be included instead.

Image Type

Two possible values:

-Image
-Font icon

Image

Image to be used for the action.

Image Class

Theme class for the image

Disabled Image

Image to be used when the action is disabled.

Disabled Image Class

Theme class to be used when the action is disabled.

Action Group Control Type

Two possible values:

-Button
-Image

Action Group Button Class

Theme class for this action, when inserted as a button inside a GX Action Group.

Action Group Disabled Button Class

Theme class for this button when action group is disabled.

Button Class

Theme class for this action when inserted as a button in a form.

Disabled Button Class

Theme class to be used when the action is disabled.

 

 

Properties Of Category Template:

Excel file extension:

Specifies the extension of the Excel files generated. It could be xls (using Jakarta.POI), or xlsx (using  EPPlus ), that supports 64bits OS. The extension XLSX is supported only in Ev1 U8 and Ev2 generating Net, because GeneXus does not support POI 2.3 for Java yet.
 

Consider Users Conditions:

Specifies whether to consider in the navigation the conditions inserted by user directly in the Conditions of the object, like it is displayed above.

ExportImg03

Show Filters:

Specifies whether to include or not the filters added in the object that generates this export archive. This property can be False (will not include any filters), All (include all filters created), Only modified (will show only the ones that user inserted some filter value).


Filters Color:

Color for displaying the filters.


Column Titles Color:

Color that the title of the columns will have.


Template:

File name of the template used when creating the Excel spreadsheet (empty for no Template).


Start Row:

Specifies the number of row which will start inserting the data. In the example below is 1.


Start Column:

Specifies the number of column which will start inserting the data. In the example below is 1.

 

Include Totalizers

Specifies whether the totalizer will be included in the Export.

 

Totalizers Format

The format of the totalizer cell separated by ';'. Possible values are: Italic, Bold, Underline and Color:<COLOR_NUMBER> (i.e: Italic;Bold;Color=RGB(221,75,57).

 

Include Conditional Formatting

Specifies whether Conditional Formatting is included.

 

Properties Of Category Export Title:

Title:

Title to add in the export archive. You can leave this field empty so to not add a title.


Title Color:

Color of the title.

ExportImg04

 

 

Properties Of Category Columns Selector:

Export only visible columns:

Specifies whether to export to Excel only the columns that are visible at the moment of clicking in the action (and in the same order), or to export all the columns that are configured as visible within the grid.

If the property is True, when the WW Object is showing some columns at the grid, the exported document will show the same columns:

ExportImg05

ExportImg06

At runtime end user changes the columns visibles and then press the option to export to Excel again:

ExportImg07

ExportImg08

 

Columns order

Two possible values:

- Users order
- Fixed