Import Excel files into PLC Siemens S7-300

Dear PLC Technical Members, 

Welcome back to the Blog PLC Technical, today we are going to talk about a very important topic in Step7 software at level PLC Siemens S7-300, which would ease the process of importing excel data to DB data block step 7, how? Follow me.

I. How to Import Excel into PLC siemens S7-300

On the off chance that you wish to import list factors from an Excel into PLC Siemens S7-300 using Step 7 Software, the system for this is portrayed in beneath.

But Before we look into the Import Excel files into PLC Siemens S7-300, let us take a look at Software Step7 Siemens.

The Step7 Siemens 

Step7 software siemens is a Simatic manager where you can program controllers, it's basic for the development and maintenance of Simatic automation systems. These systems include PLC, HMI Panel, Speed variator, drivers, networks.

1. Guidelines to import Ms excel into Siemens Simatic manager

A guide on the most proficient method to easily use Excel files to create a data block for a Siemens S7-300 project, and how Import this Excel files into PLC Siemens S7-300 using Step 7 Software.

1.  First of all you have create your project in Excel 
2. Write Initial values Microsoft Excel 
3. Compile the source data block DB10 
4. Save DB 10 as STL file 
5. New data block

1. Create the new project "TEST_EXCEL_STEP7

2. This source file is saved in the windows file system as ". Awl" and imported into STEP7, the fields must be filled in with a marker in the Excel and the data must be entered in the lines between the "STRUCT" and "END_STRUCT" as shown in the Figure Simple example for a direct start motor.

3. Choose your Project name "TEST_EXCEL_STEP7"-->Program-->OK

4. Compile the source data block: This is your source Program you can compile it, if compiler error is 0 then you have successfully created block from source program, if is an error then correct it

5. You can import the source file directly into step7 and generate the data block with the macro "compile DB". 

    Open the data block DB10 with the double click or open object.

6. The data block DB10 is now available within step7 Project The information square DB10 is currently accessible for additional handling inside your STEP 7 Project

-->Here is the Excel file to dowload.

From here we have finished the subject of the Import Excel files into PLC Siemens S7-300, if you like it, please share it with friends until it benefits, and then meet on a new topic on blog PLC Technical. 

Regards,
PLC Technical