Skip to content
MB Datasuite
  • Features
  • Applications
  • Energy
  • Visualization
  • Prices
  • Free Trial
  • Deutsch
MB Datasuite
  • Features
  • Applications
  • Energy
  • Visualization
  • Prices
  • Free Trial
  • Deutsch

System requirements and compatibility

7
  • System requirements for DataSuite
  • Supported operating systems
  • Operate as a windows service
  • Database connections 
  • PLC support  
  • Notes on safe operation  
  • White Label

Quick start

9
  • Installation  
  • Set up PLC connection  
  • Create trigger  
  • Select trigger variable in the handshake  
  • Execute trigger  
  • Create Excel file  
  • Write header data to the file  
  • Write record  
  • Connect to a Database

Tutorials, HowTos and instructions

1
  • Alarm emails with OPC-UA: Monitoring excess temperature with an S7 1500 PLC

User Manual

96
  • General information on the user manual
  • Accounts
    • Threema account
      • Threema Time limit  
      • Configure Threema account 
      • Set up a Threema account
    • E-Mail account
      • Email time limit
      • Configure email account  
      • General info about e-mail account
    • SMS-account
      • Configuring a SMS / Seven Account
      • SMS time limit
      • SMS Sandbox
    • Telegram account
      • Telegram time limit
      • Configure Telegram account 
      • Set up Telegram
  • Error Codes
    • General   (0 – 99)
    • PLC (200 – 299)
    • E-mail (300 – 399)
    • SMS (400 – 499)
    • Excel (500 – 599)
    • OPC UA (700 – 799)
    • Databases (800 – 899)
    • Print (1000 – 1099)
    • PDF (1100 – 1199)
    • HTML (1200 – 1299)
    • Start external applications  (1300 – 1399)
    • Rest (1400 – 1499)
    • Time Master (1900 – 1999)
    • Telegram (2000 – 2099)
    • Threema (2100 – 2199)
  • Devices (Shelly)
    • General information about Shelly
    • Add devices 
    • Using Shelly variables 
  • Excel, CSV, PDF files
    • CSV files: Formats, special characters, encodings
    • General information on Excel files
    • File selection 
    • File formats  
    • Read Access 
    • Write Access 
  • Control systems (PLC connections)
    • General information on PLC connections
    • Create PLC connection  
    • Variables  
    • Configure PLC connection  
  • Databases
    • General information on databases
    • Database: Write record (Insert) 
    • Database: Write several data records (insert) 
    • Database: Read data record (Select) 
    • Database: Read multiple records (Select) 
    • Database: Execute Query 
  • Webserver / REST API
    • General information web server/rest API
    • Settings and security 
    • Calling up web pages 
    • Use Rest-API 
  • Support
    • Create Support Packages  
    • Support contact details
  • Licensing
    • Determining the required licence  
    • Activate your licence  
  • Settings
    • General information
    • Export  
    • Import  
    • Password protection  
    • Change language  
    • Factory settings  
  • Trigger
    • General information about the trigger
    • Create trigger  
    • Trigger structure  
    • Use variables  
    • Trigger Actions
      • General information
      • Write variable 
      • Excel – Writing  
      • Excel – Read  
      • Convert Excel file to PDF  
      • Print Excel file  
      • Convert Excel file to HTML file  
      • Database: Execute Query 
      • Database: Write record (Insert) 
      • Database: Write several data records (insert) 
      • Database: Read data record (Select) 
      • Database: Read multiple records (Select) 
      • File options (copy, move, rename, delete)  
      • Read out file names in folder  
      • Execute REST Request 
      • FTP Upload
      • Send e-mail  
      • Send SMS  
      • Send message using Telegram 
      • Send message using Threema  
      • Start external applications  
      • Exporting and importing data blocks (DB)
      • Update Data Block
      • Set PLC time 
    • Trigger trigger conditions and handshake
      • General information on Trigger conditions and handshake  
      • Standard handshake  
      • Individual handshake  
    • Error handling and log
      • Error handling and log  
    • Additional trigger editing functions
      • Calculations and Formatting of SPS Data
      • Invert Excel Actions 
      • Changing data blocks for all variables in the trigger 

Upgrade from version 2 to version 3

1
  • Change from version 2 to version 3  
  • Home
  • Docs
  • User Manual
  • Trigger
  • Trigger Actions
View Categories

Convert Excel file to HTML file  

Lesedauer: 2 min

Description  This action allows you to convert an Excel file (XLSX, XLSM or CSV) into an HTML file.  
Required licence HTML Feature  
1  Excel file Select the file you want to convert to HTML web page. You have two options to select the file: Internal file: Here you can select a file that is already being used in the DataSuite and has, for example, previously been written to by another trigger. File system: With this option you can select any file from the file system of your computer.   
2 Publish You can either save the HTML file to the file system or publish it directly to the built-in web server (web server feature required) 

Publish HTML web page to file system  #

You can save the HTML web page on the file system to publish it on your own web server, for example. 

1  Filename Specify the filename of the HTML file. 

After you have converted the Excel file into an HTML file, you will receive the HTML file and an additional folder. 

To display the HTML file, the _files folder is also required. This contains the actual content. This means the individual sheets and graphics.  

Publish HTML web page on the integrated web server  #

You can publish the web page directly on the integrated web server. This allows the web page to be easily accessed via the browser. 

1  Webserver-Path Enter here the address under which you want to call the web page.  The first part is already given and cannot be changed. For more information on using the web server, see Webserver / REST API. 

Please note:  

Webserver feature required: The “Webserver/Rest-API” feature is required to use the integrated webserver. 

Please note:  

Configuration of the web server required: To use the integrated web server, you must first configure it. A default configuration is already available and can be used. However, you must switch on the web server (see Chapter 14)

Wie findest du den Beitrag?
Immer noch Fragen? Wie können wir helfen?

Wie können wir helfen?

Print Excel file  Database: Execute Query 
Inhalt
  • Publish HTML web page to file system 
  • Publish HTML web page on the integrated web server 

MB DataSuite

  • Home
  • Features
  • Applications
  • Prices

Info portal

  • Knowledge Base
  • Newsletter
  • Change Log
  • FAQ & Support

Company

  • About us
  • Imprint
  • Linkedin
  • YouTube
  • Facebook

Legal

  • Privacy
  • EULA
  • Cookie Settings

Help and support

  • Tel +49 2742 72927 80
  • Live Presentation
  • Contact
  • Deutsch
    • About us
    • Support & FAQ
    • Contact
    • Imprint
    • TOS and EULA
    • Privacy policy
    • Linkedin
    • Facebook
    • Youtube
    [MB] Software und Systeme GmbH