Preconfiguration "Creating an Excel file (*.xlsx) from a sample file and adding data (without MS Excel)"
Creates the
PmgButton object configured as - Creating an Excel file (*.xlsx) from a sample file and adding data (without MS Excel).
This preconfiguration can be activated when
creating a new Pmg object.
This preconfiguration is included in the
"/ Widgets / Widgets - Excel" group.
Preconfiguration:
- Creates a
PmgButton object
- Creates the
PmaWebDir subobject in the given
PmaPanel object
- Inserts the widget files "xlsx.full.min.js" and "Template.xlsx" into the Resource folder.
The widget does not support loading a file containing charts.
A script in the
onButtonUp event using the
Pm.CreateView method opens a HTML page
widget.htm in the
PmaWebDir object. This request in the
PmaWebDir.onPageModify event creates a HTML page with a link to the
xlsx.full.min.js widget library. It asks for data, which are provided by the
"data" method. It writes the data to the "data" sheet of the newly created or loaded Excel file. This file is then automatically downloaded into the "
download" folder on web client site. And also to the application
Data folder of the local user.
Warning:
For the widget to work properly in the local application, it is necessary to have WebView2 (Edge) installed in Windows OS.
The component is called Microsoft Edge WebView2 Runtime version Evergreen.
Its use must be enabled in the application's INI file.
See
Web browser (/#glob/webbrowser)
These configurators can be set before the preconfiguration is created:
| The name of created object | Name (identifier) of the Pmg object. It is used for obtaining the Pmg object by the PmgObject.Items method.
This configurator sets the initial value of the Name property.
The maximum name length is 30 characters.
This is a system name, so it must contain only alphanumeric and must not contain any diacritics (i.e. national dependent characters), empty string, spaces and first character must not be a number. |
|---|
Preconfiguration:
- Creates a PmgButton object
- Creates the PmaWebDir subobject in the given PmaPanel object
- Inserts the widget files "xlsx.full.min.js" and "Template.xlsx" into the Resource folder.
The widget does not support loading a file containing charts.
The preconfiguration requires support for Microsoft Edge WebView2 Runtime.
And in the application's INI file it is necessary to enter the WebView2=1 key into the [Promotic] section. | |
|---|
| Name of the PmaWebDir subobject | Name of the PmaWebDir subobject |
|---|
| Widget file | Widget file insertion type
Insert file
Use the existing file
Overwrite the existing file
Insert the file with different name |
|---|
| Name of the widget object | Name of the widget object |
|---|