Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

how to read data continous from excel file

Created by: naveen_paliwal at: 7/9/2013 12:32 PM (11 Replies)

Rating (0)

Thanks 1

Result pages:: |; 1 | 2; |

12 Entries

Entries per page: 10 | all

7/9/2013 12:32 PM	Rate (0)
naveen_paliwal Bronze Member Joined: 4/25/2011 Last visit: 1/19/2025 Posts: 128 Rating: (5)	Dear experts I want to read some data from excel file to plc tag in s7 300 plc. In excel data automatically update and i want similar updation in plc also automatic. How can I do it? thanks n regards
	Naveen Paliwal Vibrant Automations Pvt Ltd Rajasthan, India +919887624827 https://www.vaplindia.co.in/ E-mail- info@vaplindia.co.in
Suggestion To thank Quote Answer

7/9/2013 12:47 PM	Rate (0)
MRG Bronze Member Joined: 1/20/2008 Last visit: 2/24/2025 Posts: 120 Rating: (7)	naveen_paliwal Dear experts I want to read some data from excel file to plc tag in s7 300 plc. In excel data automatically update and i want similar updation in plc also automatic. How can I do it? thanks n regards Hello Naveen, Do you want to make this connection directly or via WinCC?' For direct communication: Take a look at this link: Prodave For communication via WinCC: use WinCC sample project (C Script, VB, OPC, DDE channel in previous version oretc.) Regards, MRG

Suggestion To thank Quote Answer

7/9/2013 12:49 PM	Rate (0)
Anit Kumar Posts: 153 Rating: (2)	naveen_paliwal Dear experts I want to read some data from excel file to plc tag in s7 300 plc. In excel data automatically update and i want similar updation in plc also automatic. How can I do it? thanks n regards Check this link..... . How do you create an OPC client with Microsoft Excel? also ... Simple Plant visualization with OCX Data Control in VBA for Excel
Anit Kumar Posts: 153 Rating: (2)	Last edited by: P,abs at: 7/9/2013 12:56 PM
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users metwally mustafa

7/9/2013 2:26 PM	Rate (0)
RKM Posts: 93 Rating: (13)	Hi frined, Please share your system over view.
RKM Posts: 93 Rating: (13)
Suggestion To thank Quote Answer

7/10/2013 4:20 AM	Rate (0)
naveen_paliwal Bronze Member Joined: 4/25/2011 Last visit: 1/19/2025 Posts: 128 Rating: (5)	Dear Mrg, I want to fetch excel data directly to simatic manager plc. I dont have any other scada software. prodave is a software? Can you please send its download link n sample project. thanks n regards
	Naveen Paliwal Vibrant Automations Pvt Ltd Rajasthan, India +919887624827 https://www.vaplindia.co.in/ E-mail- info@vaplindia.co.in
Suggestion To thank Quote Answer

7/10/2013 7:19 AM	Rate (0)
edsel lin Experienced Member Joined: 5/17/2010 Last visit: 2/21/2022 Posts: 80 Rating: (1)	You need to use Simatic NET OPC software. Try those link given above. P,abs Check this link..... . How do you create an OPC client with Microsoft Excel? also ... Simple Plant visualization with OCX Data Control in VBA for Excel One more useful link. How do you incorporate the S7 controls in Microsoft Excel?

Suggestion To thank Quote Answer

7/10/2013 8:43 AM	Rate (0)
umencho Diamond Expert Joined: 3/21/2006 Last visit: 3/17/2025 Posts: 10239 Rating: (1183)	Like an option you can use any OPC Server plus its corresponding ODBC Client in order to make connection with Excel or Access... Best regards, Hristo Mihalev

Suggestion To thank Quote Answer

7/11/2013 6:38 AM	Rate (0)
naveen_paliwal Bronze Member Joined: 4/25/2011 Last visit: 1/19/2025 Posts: 128 Rating: (5)	UMENCHO Like an option you can use any OPC Server plus its corresponding ODBC Client in order to make connection with Excel or Access... Best regards, Hristo Mihalev dear sir, opc is a paid software, and we dont want any investment. also the excel file in sample project giving error. I m using simatic manager v5.5 and MS Office 2007 and my plc is on ethernet. thanks
	Naveen Paliwal Vibrant Automations Pvt Ltd Rajasthan, India +919887624827 https://www.vaplindia.co.in/ E-mail- info@vaplindia.co.in
Suggestion To thank Quote Answer

7/11/2013 7:41 AM	Rate (0)
umencho Diamond Expert Joined: 3/21/2006 Last visit: 3/17/2025 Posts: 10239 Rating: (1183)	There are a lot free of charge OPC Server/Clients. Anyway, what kind of error did you receive? Attahc here a screen shots.

Suggestion To thank Quote Answer

7/11/2013 7:51 AM	Rate (0)
viralpatel Silver Member Joined: 11/18/2010 Last visit: 8/5/2022 Posts: 523 Rating: (32)	naveen_paliwal UMENCHO Like an option you can use any OPC Server plus its corresponding ODBC Client in order to make connection with Excel or Access... Best regards, Hristo Mihalev dear sir, opc is a paid software, and we dont want any investment. also the excel file in sample project giving error. I m using simatic manager v5.5 and MS Office 2007 and my plc is on ethernet. thanks Hi i think DDE is one idea to solve data transfer from Excel to PLC directly but i am not sure S7 PLC support DDE channel like it support OPC server configuration. VP

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on