Search the Community

Showing results for tags 'excel write to s7'.

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type

Find results in...

Find results that...


Date Created

Last Updated

Filter by number of...

Found 47 results

  1. WRITE MULTIPLE REGISTER MODBUS

    riandanualdy posted a topic in CX-Programmer

    Hallo my name is Danu, i have a CP1E wirh CP1W-CIF11 and connect to modbus RTU device, i have done with write single coil, write single register,  read single register and read multiple register. But i try to write multiple register,  the indicator of CP1W-CIF11 is off and if i check d memory its no data. I attached my cx programmer. Can you help me create write multiple register in cx programmer?  Thank you AD4402-modbus edit edit edit edit edit.cxp
  2. Hello Everyone, I have a Omron CJ2M PLC, and I have configured the Ethernet/IP port of this PLC to communicate over ethernet connection. I want to read/write the DM, HR memory areas of Omron PLC (CJ2M) using eip protocol communication. Is there any protocol specification which explains the telegram structure to be sent over ethernet to be able to read/write the values in omron plc over EIP? I want to know the command structure which can be sent to PLC and PLC will respond with the proper response. 

  3. Reporting for Siemens PLC

    Timoti posted a topic in Siemens

    Hello, We want to do excel reports on Siemens PLC. We do not want to use historian programs. Do you know another programs?

  4. LOGO For Excel

    progpro posted a file in Demo Software

    Version 1.0.0

    22 downloads

    LOGO For Excel allows you to retrieve, view, log and write data to one or more Siemens LAN connected LOGO! 8 basic modules using Microsoft Excel without the need of a touchpanel or any other hardware or driver. Configure in no time Excel spreadsheets that contains live LOGO! data.
  5. View File LOGO For Excel LOGO For Excel allows you to retrieve, view, log and write data to one or more Siemens LAN connected LOGO! 8 basic modules using Microsoft Excel without the need of a touchpanel or any other hardware or driver. Configure in no time Excel spreadsheets that contains live LOGO! data. Submitter progpro Submitted 03/25/22 Category Demo Software

  6. S7 Excel Connect

    progpro posted a file in Demo Software

    Version 2.0.0

    66 downloads

    S7 Excel Connect allows you to read, log and write one or more Siemens S7 PLCs data using Microsoft Excel. This can be data from a datablock, marker, input/output as well as digital as analog (not peripheral), timer and counter. S7 Excel Connect can be used for many uses ranging from a reporting tool, to a tool to write recipes to any S7 PLC.
  7. View File S7ExcelReader The S7ExcelReader Add-In enables users to load and work with data from a profinet connected Siemens S7 PLC. The retrieved S7 PLC data can be used to visualize proess data, create custom reports, perform complex calculations on process data, … . With one click on the refresh button, all the data of one or more S7 PLC’s are refreshed in your worksheet. Download your free trial of S7ExcelReader today! Submitter progpro Submitted 11/03/21 Category Demo Software
  8. Hey guys,   I know this is a topic that has been discussed before, but I am having trouble finding exactly what I am looking for.. I want to know the most efficient way to record data from my PLC to an Excel file on my PC. I want this to be done without the use of the PLC's webserver.  Specifically I am trying to record vfd speed every 10seconds with a time and date stamp. How can I do this?   Thanks, James  
  9. Here is a step by step tutorial... Utilizing the CX Server DDE Manager will allow us to provide a link to the information in the Omron PLC. This link can be placed on an Excel spreadsheet. Charts, graphs, etc. can be made from the data. We will create links on an excel spread sheet from a CQM1H and a CP1L PLC. The information will then be displayed as a bar graph comparing the first ten memory areas. Here is a step by step tutorial... Watch on YouTube : Implementing the Omron CX Server DDE and Excel Let me know what you think. Regards, Garry

  10. plc mtsubishi r series and rj71c24-r4

    Javier Campos posted a topic in Mitsubishi

    hello, im working with r04 mitsubishi plc with rj71c24-r4 in modbus rtu mode, i need to read and write PM1200 scheneider values, but i have problems, is my first time with this model and very different than fx5u model, i working in GX works3 someone who can guide me, I would appreciate it too much
  11. Hello, I am new to Scada Programming. I am using Citect scada V7.50. I have completed whole project, but I am unable to generate Excel report for Alarms generated during run time. Please help me for this issue. Thanks...
  12. I'm a young Controls Engineer at an integration company, and I need assistance.   I have a client that has about 330 different alphanumeric product numbers broken down by length and width. The operator must be able to select the product number at the HMI to pass along to the robot we are integrating. Is there a way to be able to have the operator select the product number simply, without having to scroll over 300 items in a single control list. The HMI is not chosen yet, so it can be GE, Rockwell/AB, or Automation Direct, but we are using a AB ControlLogix Processor. Racking my brain and I have little VBA/Scripting experience.

  13. sthilaire

    dsthilaire posted a topic in Allen Bradley / Rockwell Automation

    Does anyone have any idea how to set up an OPC server in FactoryTalk SE for Excel?  I'm trying to move data from a spread sheet to the PLC.  Got it working in excel now I'm trying to initiate the transfer from SE. 
  14. Hello,   Target:  I'm looking to make an excel macro that will take an IP address and pull the components on that specific backplane. Pretty much how RSLinx Classic OEM does it, but it will save me a lot of time if I could automatically put the results into excel. Example: Enter IP "111.111.111.111" into excel, run the macro, and have it fill in the components on the backplane below. 111.111.111.111 00, 1756-L73 LOGIX5573 01, 1756-EN2T 02, 1756-DNB 03, ... 04, ... Any help that could get me toward this would be amazing. I'm just not sure of the code that would do this.   Thank you, MalSmith21
  15. My project is to read an RFID tag (ascii) with a Micrologix 1400, send the string to a PC using Ethernet/IP, lookup and compare in an Excel spreadsheet, and send back data (probably an integer) for the plc to use to control direction. I have to scan and compare an RFID tag to a list of 1400 possible part numbers, at different locations (more than 1 plc). I want the several PLCs to go to a single PC to make it easy to update when changes occur (on a weekly basis). Has anyone done anything like this? I'm assuming there will have to be some kind of vb or c+ application involved.   Thanks,  CK

  16. mitsubishi PLC R series

    kaviraj posted a topic in Mitsubishi

    I have R16 PLC (firmware45) and SD card(2GB). Can any one help me to create CSV file in SD card.I need to Logg the data of D0-100 when the M0 trigger bit goes high. can any please help to creat  ladder for this. it will be really helpful.
  17. Does anyone have any tips or tricks for generating UDT Templates from an excel spreadsheet? It says in the help files you can copy/paste from excel into the UDT Template, but it seems to only allow that cell by cell, instead of the whole table of data. This is painfully tedious when building larger interfaces. I've tried saving the spreadsheet in various formats (CSV, PRN, tab delimted txt) and I've tried various versions of RSLogix from 23 to 31. I can't seem to find any detailed info on how to do this. I've seen some other forum posts regarding using scripting to generate the XML to import the UDT, but I don't understand why I can't simply copy and paste the info in. Is this really that difficult? Any help would be greatly appreciated. Thanks Otto
  18. hello everyone.Please help.I have a program for the machine written on protool and Strp7, When I want to open it to add changes to it, it gives me the erroropen object 734:26 OM TD/OP: simatic-op is on a write-protected medium.please tell me, How can I overcome this problem?"Unexpected file format" Attached images.Thank you for your help

  19. Read/Write data to PLC

    CarloM posted a topic in Mitsubishi

    Goodmorning a question... I builded a simple monitor of plc. I need to read the data of the Mitsubishi FX3GE PLC. In example I should read: D14  FLOAT 32bit D16  FLOAT 32bit alarms from M100 to M119 and a bit of state M450 How can I do this? The PLC is connected via ethernet and the port il 5002.  I'm working with PHP and normally use modbus, opc-ua, etc. But here? Thanks in advance Carlo
  20. Hi Guys! A have a problem with Excel and RS linx. I belive the communication is good. I just need a few tips, especially with excel. I have about 3000 dint value, and aI dont know how to put them in excel at once. Not one by one. THis is my first question. You can see the link: =RSLINX|MC!'Database_fifo[0].Motor_rpm, L1,C1' the next one is =RSLINX|MC!'Database_fifo[1].Motor_rpm, L1,C1' and =RSLINX|MC!'Database_fifo[2].Motor_rpm, L1,C1' and so on. I dont want to write the numbers like 3, 4 ,5 ...2560... So I hope you guys get it, sorry for the bad explanation. For this problem maybe exsiting some macro or something like that, I dont know. The second: there is some dint what is in decimal style, but acutall they are ascii, I know how solve that, with the char function, but I dont know how to collect it. Like on the picture, there is the numbers what I read from the plc, like 82 equal to R. But I want to see them in one cell. Like RKBF-355, I want them in a same cell. Unfortunaltely I cant solve it. At least until now, and I hope somebody know it by memory.    Thank you in advance!  

  21. Vijeo Citect - write to tag - error

    Nizami_225 posted a topic in Mitsubishi

    Hi everyone.  In Vijeo Citect SCADA I created some tags and I try to write to a bit device of MELSEQ Q PLC. But I get this error : Cicode General software error. Note: I can read from PLC.

  22. Excel import

    Luka0204 posted a topic in Mitsubishi

    Hi, i have excel file with 2 columns and cc 300 rows (saturation curve). How to import excel file in GX works 3 (R04CPU) and use data as two array variables [0..300]? I want to avoid manual writing around 600 values. Thanks  
  23. Does anyone have an example piece of ladder logic, created on a Micrologix 1200, using ASCII to READ and Write to a serial device?  I am building a ladder on a Micrologix 1200 that will send data to an old CNC once a certain ASCII instruction is received on the PLC.  For example, when the machine spits out an ASCII "1", the PLC will see the "1" and send out a three digit number depending on a sequence of discrete inputs.   Thank you,
  24. Dear Everyone can help     i have a batching system of about 12 materials and i need to generate a report for all batches in the day in runtime, i tried using SQL with Cicode but sometimes i can't find some material's data or to be Zeros. did any one here know a way to do that?? vijeo citect 7.4 thank you

  25. Cimplicity Auto Report Generation

    MD SULTAN ALAM posted a topic in GE

    Dear All, I am having a problem with my cimplicity Auto Report Generation, When I Click on Generate Report, it shows "0 values collected" does anyone knows what's possibly could gone wrong here ??