Preconfiguration "Creating an Excel file (*.xlsx) with data (without MS Excel)"
This preconfiguration can be activated when creating a new Pmg object
and is included in the group: "/ Widgets / Widgets Excel"
. Creates the PmgButton
object configured as - Creating an Excel file (*.xlsx) with data (without MS Excel).
Creates a PmgButton object, a PmaWebDir subobject and inserts the widget file "xlsx.full.min.js"
into the Resource
A script in the onButtonUp
using the CreateView
method opens a html page widget.htm
in the PmaWebDir
object. This in the PmaWebDir.onPageModify
event request calls the widget
method. This creates an html page with a link to the xlsx.full.min.js
widget library. It asks for data, which it provides the "data
" method. It writes the data to the "data" sheet of the newly created or loaded excel file. It then automatically downloads this file to the client's download folder.
For the widget to work properly in a local application, it is necessary to have WewbView2 (Edge) installed on the 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:
|Object name||Name (identifier) of the Pmg object. It is used to obtain 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, empty string, spaces and the first character must not be a number.
|Creates a PmgButton object, a PmaWebDir subobject and inserts the widget file "xlsx.full.min.js" into the Resource folder..|
|Name of the PmaWebDir subobject||Name of the PmaWebDir subobject|
|Name of the widget object||Name of the widget object|