Excel read data from S7-300 with libnodave

Simple way to get data directly from Siemens PLC like S7-315 2PN/DP in Excel

 

what you need

  • libnodave.dll
  • Siemens PLC (I use S7-315pn/dp)
  • excel (I use office 2010)

You can download a excel file with libnodave dll ready to use,  Libnodave_Excel_Communication.zip

Here is a small presentaion , how to use this method:

 

PS: dont forget to put libnodave.dll in your system folder like : C:\Windows\System32\

23 comments on “Excel read data from S7-300 with libnodave

  • Hallo…
    Excel read data from S7-300 ist genau was ich gesucht habe.
    Doch leider steht bei mir “7,00649232162409E-44” anstelle von “100” .
    Mache ich etwas falsch ? ich habe die Original Dateien benutzt.

    Schön wäre noch eine Spalte und eine taste zu Schreiben von Werten ist das möglich?

    mfg J.Osmer

    • >Doch leider steht bei mir “7,00649232162409E-44” anstelle von “100” .
      Eventuel haben Sie sich mit der Addresse vertan?

      >Schön wäre noch eine Spalte und eine taste zu Schreiben von Werten ist das möglich?
      Ja das wäre möglich, da muss man einfach das Makro anpassen.

      Grüße.

  • Dear all
    would you please send a sample s7 project for testing .
    Would you pleas help me?
    I can not connect to PLC Siemens .
    Remark:
    -I use PLCSIM
    – I use Simatic manager version is 5.3

    kind regards

  • hello,

    i have used your programm and it works very good, but i have a question, if i want to read the data i must press the button, but is there any way to refresh the data automatic? i mean, to the a button connect and show the data like if it were online.

    Thank you very much

  • Every time the function is called excel returns a hault message indicating that the libnodave.dll file is not found. I work in Windows 7 whit Excel 2010.

  • Ich verwende Windows 8.1 (64Bit) und Excel 2010. Ich bekomme immer die Fehlermeldung “Laufzeitfehler 48” Datei nicht gefunden. Ich habe die Datei libnodave.dll schon in sämtliche Ordner kopiert (C:\ , C:\ Windows, System, System32, Excel Programmordner,…)

    Auf Windows 7 (64Bit) und Excel 2007 funktioniert es.

    Können sie mir helfen? Vielen Dank.

  • Hallo ,

    I have copied libnodave file to my system 32 followed up trying to connect it to the PC reultrs in no luck . I am recieving a error Lauftzeit 53. Data nicht gefunden.

    I even tried to change the patch in the program for the dLL file but no fruitful results. Could you please help me on this issue.

  • Hello,
    Thanks for this job.
    I’ve tested it with a S7-300 PLC , it works fine with bit,bool,word or real.
    But when I test it with a data type DINT, the result is always 0 ( example : db8.dbd10 DINT L#10 )
    Have you an idea why ?

  • Hello Plc2k. I opened excel file but the error message appeared from Microsoft Visual basic for applications:” The code in this project must be updated for use on 64 bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute”. This error may be because my operation system is window 10 – 64 bit but your library (dll file) was written in 32 bit. Please help me to solve this problem. Thank you very much

Leave a Reply

Your email address will not be published. Required fields are marked *

* Please Add the Values