Announcement

Collapse
No announcement yet.

Export data to Excel

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts


  • Export data to Excel

    Hi all,

    I have directlogic 06 D0-06DR and directsoft 5 connected to pc at usb from port 1. This is my first time working with this brand. I want to export data from v-memory to excel. Can I do this with the existing things that I have? I read somewhere can use vba in excel to do this. is it true? Thank you.


  • #2
    The D0-06DR can understand the Modbus RTU protocol. You will need to use VBA to open the serial port, send the Modbus command for the data, read the return data and then display in excel.
    https://pps2.com/smf/index.php?topic=25.0
    The above link has a sample code for Modbus RTU using VBA.

    Here is the post I have done using Modbus TCP (Ethernet) to get information into excel.
    https://accautomation.ca/how-to-impl...ba-with-excel/

    Hope this helps you out.
    Regards,
    Garry

    Comment



    • #3
      https://forum.automationdirect.com/f...emory-to-excel
      The above post may also help you out.
      Regards,
      Garry

      Comment



      • #4
        I have been playing around with python.

        It wouldn't be all that hard to create a python script to poll the modbus address you want and append it to a csv at a rate you define.

        Comment

        Working...
        X