How to Interface data from excel sheet and S7?

ajaysharma

Member
Join Date
Dec 2011
Location
darmstadt
Posts
11
Hi all, I am a beginner and I am looking for a way to adjust a PID controller using S7 for a college project the task is I Have the 3 inputs and when ever any of it is changing i have to change the pneumatic pressure according to it (the values corresponding to it is saved in a excel sheet).
I want to read these values and give these values to SPS as a input so that the ouput to the PID controller can be varried accordingly.


I am confused and i searched on internet there are possibilities that i can do it I came across some articles in which it says we can transfer data from excel sheet but i am not sure how can we use it?

Can we use it as analog input or how ???
And i will need Winccflexible for it or i have create a OPC server I am bit confused How can I do this problem. ;)


Please do help me


thanks and regards
Ajay
 

Similar Topics

We have a customer who has a PLC5/25 controller that uses interfaces to a Fischer-Provox system using a 1785-KA on the PLC5 end and a 1771-KX1 on...
Replies
4
Views
1,628
Good day All, We are using a Desoutter CVIL II Controller for a project. It is currently connected from the RS232 Port of the Contrroller to a...
Replies
1
Views
2,724
We want to integrate a dedicated PH PID controller, implemented in a small PLC, to the main process controller. The basic idea is make possible...
Replies
2
Views
1,484
Hi Guys, I'm using socket interface as an official AOI from RA for data exchange between PLC with 1756-EN2T(supports Socket Interface) and...
Replies
3
Views
1,559
Hi, just wondering can serial interface data be duplicated?. I have a Siemens CP340 RS232C (ascii, 3964R)that communicates with a small little...
Replies
5
Views
3,802
Back
Top Bottom