Cookies helfen uns bei der Bereitstellung unserer Dienste. Durch die Nutzung unserer Dienste erklären Sie sich damit einverstanden, dass wir Cookies setzen.
Cookies help us in providing our services. By using our services, you agree that we set cookies.
OK
PLC-data in Excel - Process Informatik Entwicklungsgesellschaft mbH

PLC-data in Excel


Create with the S7-PLC Excel-files

New: growing regions (PLC data is updated in the same file)
S7-To-Excel-tool generates from any PLC-variables Excel-files according to your design.
You customize the look directly into Excel!

Features:
  • free create of the Excel-tables with formulas and formats
  • Insert data records (regions) to Excel file, (as of V 2.0)
  • Operation without Excel-installation
  • event- and time-controlled writing per worksheet (time-/event-trigger)
  • no programm in the PLC necessary
  • no limit on the count of variables
  • file-creation with time-stamp in the file-name

more...

New: growing regions (PLC data is updated in the same file)
S7-To-Excel-tool generates from any PLC-variables Excel-files according to your design.
You customize the look directly into Excel!

Features:
  • free create of the Excel-tables with formulas and formats
  • Insert data records (regions) to Excel file, (as of V 2.0)
  • Operation without Excel-installation
  • event- and time-controlled writing per worksheet (time-/event-trigger)
  • no programm in the PLC necessary
  • no limit on the count of variables
  • file-creation with time-stamp in the file-name
  • easy parameterization
  • the addresses of the PLC-variables are specified directly in the Excel table (for e.g. PLC_ADDR,DB10.DBW100,INT)
Differences of license types:
Features Standard Advanced Expert
Count of variables  100  unlimited  unlimited
Possibility to write data areas dynamically      x

Supported PLC-types:
  • S7-1500
  • S7-1200
  • S7 300/400
  • S7-200
  • S7-SoftPLC
  • Logo!-SPS
  • VIPA-S7
  • all S7 compatible controls
All parameters are stored directly in the XML-template-file.
The template includes all information as:
  • target directory
  • target-file with format-specification for the date and time
  • connection-parameters to the PLC (ip-address etc.)
  • addresses of the PLC-variables
  • Time or event trigger for generating the target file / appending records
  • This information is indicated with the help of keywords at any position in the Excel worksheet. Variables from the PLC will appear in the target file at the same position (cell), where the relevant variable address has been entered.
Example

Template:


Result:

screenshot of the configuration

program flow

All prices plus costs of delivery, shipping insurance and VAT.

support-service:

SUP-9773-S7
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard single-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-2
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard subsequent-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-3
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard site-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-A
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced single-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-A-2
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced subsequent-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-A-3
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced site-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-A-DO
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced single-license with dongle-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-DO
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard single-license with dongle-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-E
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a S7-To-Excel expert single-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-E-2
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel expert subsequent-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-E-3
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel expert site-license
INFOMAIL
by e-mail
price on request
request quotation
SUP-9773-S7-E-DO
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a S7-To-Excel expert single-license with dongle-license
INFOMAIL
by e-mail
price on request
request quotation

accessories:

9773-DO
PLC-data in Excel license-dongle AddOn
USB-dongle with license-key instead of software-key Only for Win7/8/8.1 and Win10
INFOMAIL
by e-mail
price on request
request quotation
All prices plus costs of delivery, shipping insurance and VAT.

Einzel-Lizenz

9773-S7
PLC-data in Excel-tool, single-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
INFOMAIL
by e-mail
price on request
request quotation
9773-S7-A
PLC-data in Excel-tool, advanced, single-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
INFOMAIL
by e-mail
price on request
request quotation
9773-S7-E
PLC-data in Excel-tool, expert, single-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
INFOMAIL
by e-mail
price on request
request quotation

Folge-Lizenz

9773-S7-2
PLC-data in Excel-tool, subsequent-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
INFOMAIL
by e-mail
price on request
request quotation
9773-S7-A-2
PLC-data inExcel-tool, advanced, subsequent-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
INFOMAIL
by e-mail
price on request
request quotation
9773-S7-E-2
PLC-data in Excel-tool, expert, subsequent-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
INFOMAIL
by e-mail
price on request
request quotation

Standort-Lizenz

9773-S7-3
PLC-data in Excel-tool, site / company license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
INFOMAIL
by e-mail
price on request
request quotation
9773-S7-A-3
PLC-data in Excel-tool, advanced, state / comp.lic.
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
INFOMAIL
by e-mail
price on request
request quotation
9773-S7-E-3
PLC-data in Excel-tool, expert, state / comp.lic.
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
INFOMAIL
by e-mail
price on request
request quotation
All prices plus costs of delivery, shipping insurance and VAT.

Automatic-mode

Other downloads

Extension

Support-videos