Promotic

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 folder.

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.
Warning:
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 nameName (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 subobjectName of the PmaWebDir subobject
Name of the widget objectName of the widget object

History:
Pm9.00.23: Created
PROMOTIC 9.0.23 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.