Data Collection

[BradDavis 0]

I am New to Siemens and running S7-300. Trying to set-up Data Collection from S7 to Excel. Can anyone help?

[TravisPedley 21]

quick google search turned this up.  Haven't used it, but it may be worth a shot.  How are your VB macro skills?

http://plc2k.com/excel-read-data-from-s7-300-with-libnodave/

[BradDavis 0]

No macro skills.

[Automated Solutions 3]

Try ASComm Excel Add-in from Automated Solutions.

Siemens S7 is supported. 

Macros, VBA, OPC, DDE, external drivers not required. 

http://automatedsolutions.com/products/dotnet/ascomm/excel-addin.asp

 

[Lanester 0]

Hi, sorry to hijack your old post. 

I have downloaded ASComm Excel Add-in and trying to read from an S7-1200 CPU.

I keep getting errors. The help file doesn't explain in enough detail how to setup the software, anyone have any experience using this?

The error I am seeing is 'Invalid. Object reference not set to an instance of an object'.

All i'm trying to do is read MB100 as a test on an IP of 192.168.0.1 on a S7-1214C CPU. Can go online without issue using TIA.

[Automated Solutions 3]

Hi,

The runtime configuration application has the ability to read/write values directly, so you can use it to verify your setup prior to loading the configuration file in ASComm Excel Add-in.

The configuration app should provide detailed error descriptions in the event viewer if there is a problem. Select the 'Values View' toolbar button to enable data collection in the config app (see image).

If you are still having a problem, email a support request to 'support @ automatedsolutions.com' (remove spaces) and include your configuration file in the e-mail.

I did a quick test here and do not have a problem accessing MB100 on S7-1200 (see image)

 

 

[progpro 0]

Hi, probably bit too late but we use S7 Excel Connect for some months now. It's useful to get and write realtime S7 data using Excel. 

Edited 25 Mar 2022 by progpro