BradDavis

Data Collection

7 posts in this topic

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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)

 

 

S7-1200.jpg

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now