تالار گفتگوی سایت مهندس ماهر

Notifications

Clear all

import و Export کردن Excel در wincc

آخرین ارسال

RSS

Masoud Maleki1982

(@masoud-maleki1982)

New Member

عضو شده: 7 سال قبل

ارسال‌ها: 3

۲۹/۱۰/۱۳۹۷ ۱۱:۴۶ ب.ظ

سلام دوستان در زمینه import و export کردن excel در wincc

آیا میشه در Excel متغیر مورد نظر را وارد کرد و در wincc داخل یک i/O Feild ظاهر گردد.در قضیه export کردن با Vbsشدنی هست ولی با import کردن ، wincc همچین اجازه ای رو به Excel را خواهد داد.ممنون

This topic was modified 56 سال قبل 2 times by Masoud Maleki1982

نقل‌قول

Rahaei

(@rahaei)

Trusted Member

عضو شده: 7 سال قبل

ارسال‌ها: 54

۳۰/۱۰/۱۳۹۷ ۸:۰۹ ب.ظ

سلام

شما با برنامه نویسی به زبان های C و VBS می توانید عملیات Write در سلول های Excel و Read را انجام دهید.

در پستی که آدرس آن ارسال می شود توضیحاتی در این باره داده شده است.

https://mohandesmaher.com/forum/monitoring/%D8%A7%D9%86%D8%AA%D9%82%D8%A7%D9%84-%D8%AF%DB%8C%D8%AA%D8%A7%D9%87%D8%A7-%D8%A7%D8%B2-wincc-%D8%A8%D9%87-excel/#post-22

پاسخنقل‌قول

Masoud Maleki1982

(@masoud-maleki1982)

New Member

عضو شده: 7 سال قبل

ارسال‌ها: 3

۳۰/۱۰/۱۳۹۷ ۱۱:۲۶ ب.ظ

جناب مهندس ممنون از بابت فایل

ولی من میخوام دیتا رو از Excel به wincc انتقال دهم.یعنی در یک cell متغیر رو وارد کنم و در wincc داخل یک i/O Feild ظاهر گردد.

پاسخنقل‌قول

Rahaei

(@rahaei)

Trusted Member

عضو شده: 7 سال قبل

ارسال‌ها: 54

۰۱/۱۱/۱۳۹۷ ۱۰:۵۴ ب.ظ

خواهش میکنم

SmartTags("EMS_to_SCADA_INV_DHS_SP.INV1_ACTIVE_PWR_SP") = .Cells(5,4).valu

خط برنامه نویسی فوق یک مثال از خواندن مقدار از Excel هست.

پاسخنقل‌قول

آمار تالار گفتمان

6 تالارهای گفتمان

602 موضوعات

1,803 ارسال‌ها

0 آنلاین

389 اعضا

آخرین ارسال: راه اندازی کلاینت جدیدترین عضو ما: saeid ارسال های اخیر Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

آیکن های موضوع: Not Replied پاسخ داده شده فعال داغ مهم تایید نشده حل شده خصوصی بسته شده

Super Globals

Requests: Array ( )

Server: Array ( )

Options and Features

permastruct: forum
use_home_url: 0
url: https://mohandesmaher.com/forum/
Array
(
    [title] => تالارهای گفتگوی اتوماسیون صنعتی
    [description] => تالارهای تخصصی سایت مهندس ماهر
    [menu_position] => 23
    [lang] => 1
)
pageid:1729
default_groupid: 3
Array
(
    [layout_extended_intro_topics_toggle] => 0
    [layout_extended_intro_topics_count] => 220
    [layout_extended_intro_topics_length] => 0
    [layout_qa_intro_topics_toggle] => 0
    [layout_qa_intro_topics_count] => 3
    [layout_qa_intro_topics_length] => 90
    [layout_threaded_intro_topics_toggle] => 0
    [layout_threaded_filter_buttons] => 1
    [layout_threaded_add_topic_button] => 1
    [layout_threaded_intro_topics_count] => 10
    [layout_threaded_intro_topics_length] => 0
    [display_current_viewers] => 0
)
Array
(
    [layout_extended_intro_posts_toggle] => 1
    [layout_extended_intro_posts_count] => 4
    [layout_extended_intro_posts_length] => 50
    [layout_qa_posts_per_page] => 15
    [layout_qa_comments_limit_count] => 3
    [layout_qa_first_post_reply] => 1
    [comment_body_min_length] => 2
    [comment_body_max_length] => 0
    [layout_threaded_posts_per_page] => 5
    [layout_threaded_nesting_level] => 5
    [layout_threaded_first_post_reply] => 0
    [union_first_post] => Array
        (
            [1] => 0
            [4] => 0
            [2] => 0
            [3] => 1
        )

[topic_body_min_length] => 2
    [topic_body_max_length] => 0
    [post_body_min_length] => 2
    [post_body_max_length] => 0
    [recent_posts_type] => topics
    [tags] => 1
    [max_tags] => 10
    [tags_per_page] => 100
    [edit_topic] => 1
    [edit_post] => 1
    [edit_log_display_limit] => 0
    [display_current_viewers] => 1
    [display_recent_viewers] => 1
    [display_admin_viewers] => 1
    [topics_per_page] => 10
    [eot_durr] => 0
    [dot_durr] => 0
    [posts_per_page] => 15
    [eor_durr] => 0
    [dor_durr] => 0
    [search_max_results] => 100
    [max_upload_size] => 10485760
    [attach_cant_view_msg] => شما مجاز به مشاهده این ضمیمه نمی‌باشید
)
Array
(
    [online_status_timeout] => 60
    [members_per_page] => 15
    [url_structure] => nicename
    [search_type] => search
    [login_url] => 
    [register_url] => 
    [lost_password_url] => 
    [redirect_url_after_login] => https://mohandesmaher.com
    [redirect_url_after_register] => https://mohandesmaher.com
    [redirect_url_after_confirm_sbscrb] => https://mohandesmaher.com
    [custom_title_is_on] => 1
    [default_title] => Member
    [rating] => Array
        (
            [0] => Array
                (
                    [points] => 0
                    [title] => New Member
                    [color] => #d2d2d2
                    [icon] => far fa-star-half
                )

[1] => Array
                (
                    [points] => 5
                    [title] => Active Member
                    [color] => #4dca5c
                    [icon] => fas fa-star
                )

[2] => Array
                (
                    [points] => 20
                    [title] => Eminent Member
                    [color] => #4dca5c
                    [icon] => fas fa-star
                )

[3] => Array
                (
                    [points] => 50
                    [title] => Trusted Member
                    [color] => #4dca5c
                    [icon] => fas fa-star
                )

[4] => Array
                (
                    [points] => 100
                    [title] => Estimable Member
                    [color] => #4dca5c
                    [icon] => fas fa-star
                )

[5] => Array
                (
                    [points] => 250
                    [title] => Reputable Member
                    [color] => #4dca5c
                    [icon] => fas fa-star
                )

[6] => Array
                (
                    [points] => 500
                    [title] => Honorable Member
                    [color] => #e5d600
                    [icon] => fas fa-certificate
                )

[7] => Array
                (
                    [points] => 750
                    [title] => Prominent Member
                    [color] => #e5d600
                    [icon] => fas fa-certificate
                )

[8] => Array
                (
                    [points] => 1000
                    [title] => Noble Member
                    [color] => #e5d600
                    [icon] => fas fa-certificate
                )

[9] => Array
                (
                    [points] => 2500
                    [title] => Famed Member
                    [color] => #ff812d
                    [icon] => fas fa-shield-alt
                )

[10] => Array
                (
                    [points] => 5000
                    [title] => Illustrious Member
                    [color] => #e04a47
                    [icon] => fas fa-trophy
                )

)

[rating_title_ug] => Array
        (
            [5] => 1
            [4] => 1
            [3] => 1
        )

[rating_badge_ug] => Array
        (
            [1] => 1
            [5] => 1
            [4] => 1
            [2] => 1
            [3] => 1
        )

[title_usergroup] => Array
        (
            [1] => 1
            [5] => 1
            [4] => 1
            [2] => 1
        )

[title_second_usergroup] => Array
        (
            [3] => 1
        )

[4] => Array
                (
                    [id] => 4
                    [name] => Threaded
                    [version] => 1.0.0
                    [description] => Threaded layout turns your forum to a threads list accented on discussion tree view.
                    [author] => gVectors Team
                    [url] => http://gvectors.com/
                    [file] => classic/layouts/4/forum.php
                )

[2] => Array
                (
                    [id] => 2
                    [name] => Simplified
                    [version] => 1.0.0
                    [description] => Simplified layout looks simple and clean.
                    [author] => gVectors Team
                    [url] => http://gvectors.com/
                    [file] => classic/layouts/2/forum.php
                )

[3] => Array
                (
                    [id] => 3
                    [name] => QA
                    [version] => 1.0.0
                    [description] => Q&A Layout turns your forum to a powerful question and answer discussion board.
                    [author] => gVectors Team
                    [url] => http://gvectors.com/
                    [file] => classic/layouts/3/forum.php
                )

)

[style] => default
    [styles] => Array
        (
            [default] => Array
                (
                    [0] => #000000
                    [1] => #ffffff
                    [2] => #333333
                    [3] => #555555
                    [4] => #666666
                    [5] => #777777
                    [6] => #999999
                    [7] => #cccccc
                    [8] => #e6e6e6
                    [9] => #f5f5f5
                    [10] => #dadada
                    [11] => #659fbe
                    [12] => #43a6df
                    [13] => #72ccfc
                    [14] => #0099cc
                    [15] => #3f7796
                    [16] => #4a8eb3
                    [17] => #dff4ff
                    [20] => #ff812d
                    [30] => #4dca5c
                    [31] => #00a636
                    [32] => #86ba4c
                    [33] => #6fa634
                    [40] => #ff9595
                    [41] => #ff7575
                    [42] => #f46464
                )

[red] => Array
                (
                    [0] => #000000
                    [1] => #ffffff
                    [2] => #333333
                    [3] => #555555
                    [4] => #666666
                    [5] => #777777
                    [6] => #999999
                    [7] => #cccccc
                    [8] => #e6e6e6
                    [9] => #f5f5f5
                    [10] => #dadada
                    [11] => #e0141e
                    [12] => #ee1a26
                    [13] => #fc979c
                    [14] => #e0141e
                    [15] => #99262b
                    [16] => #d61319
                    [17] => #fff7f7
                    [20] => #30b2a7
                    [30] => #4dca5c
                    [31] => #00a636
                    [32] => #86ba4c
                    [33] => #6fa634
                    [40] => #ff9595
                    [41] => #ff7575
                    [42] => #f46464
                )

[green] => Array
                (
                    [0] => #000000
                    [1] => #ffffff
                    [2] => #333333
                    [3] => #555555
                    [4] => #666666
                    [5] => #777777
                    [6] => #999999
                    [7] => #cccccc
                    [8] => #e6e6e6
                    [9] => #f5f5f5
                    [10] => #dadada
                    [11] => #6ea500
                    [12] => #649e2d
                    [13] => #8dce0c
                    [14] => #447714
                    [15] => #5a7f10
                    [16] => #6ea500
                    [17] => #f8fcef
                    [20] => #ff812d
                    [30] => #4dca5c
                    [31] => #00a636
                    [32] => #ff812d
                    [33] => #f47222
                    [40] => #ff9595
                    [41] => #ff7575
                    [42] => #f46464
                )

[orange] => Array
                (
                    [0] => #000000
                    [1] => #FFFFFF
                    [2] => #333333
                    [3] => #555555
                    [4] => #666666
                    [5] => #777777
                    [6] => #999999
                    [7] => #CCCCCC
                    [8] => #E6E6E6
                    [9] => #F5F5F5
                    [10] => #DADADA
                    [11] => #E0762F
                    [12] => #FF6600
                    [13] => #FC9958
                    [14] => #F26000
                    [15] => #AA4F12
                    [16] => #F26000
                    [17] => #FFF4ED
                    [20] => #FF812D
                    [30] => #4DCA5C
                    [31] => #00A636
                    [32] => #86BA4C
                    [33] => #6FA634
                    [40] => #FF9595
                    [41] => #FF7575
                    [42] => #F46464
                )

[grey] => Array
                (
                    [0] => #000000
                    [1] => #ffffff
                    [2] => #333333
                    [3] => #343434
                    [4] => #666666
                    [5] => #777777
                    [6] => #999999
                    [7] => #cccccc
                    [8] => #e6e6e6
                    [9] => #f5f5f5
                    [10] => #dadada
                    [11] => #888888
                    [12] => #666666
                    [13] => #7eea8d
                    [14] => #777777
                    [15] => #333333
                    [16] => #555555
                    [17] => #dff4ff
                    [20] => #ff812d
                    [30] => #4dca5c
                    [31] => #00a636
                    [32] => #86ba4c
                    [33] => #6fa634
                    [40] => #ff9595
                    [41] => #ff7575
                    [42] => #f46464
                )

[dark] => Array
                (
                    [0] => #000000
                    [1] => #141414
                    [2] => #bbbbbb
                    [3] => #000000
                    [4] => #666666
                    [5] => #bcbcbc
                    [6] => #999999
                    [7] => #585858
                    [8] => #727272
                    [9] => #323232
                    [10] => #dadada
                    [11] => #888888
                    [12] => #33779b
                    [13] => #7eea8d
                    [14] => #777777
                    [15] => #e0e0e0
                    [16] => #cecece
                    [17] => #33779b
                    [20] => #ff812d
                    [30] => #4dca5c
                    [31] => #00a636
                    [32] => #86ba4c
                    [33] => #6fa634
                    [40] => #ff9595
                    [41] => #ff7575
                    [42] => #f46464
                )

)

)
classic