Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84248members
353348posts

[Imported] Excel Work sheets in SCADA

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

sbeadle
Janeway Janeway
Janeway
0 Likes
1
355

[Imported] Excel Work sheets in SCADA

>>Message imported from previous forum - Category:Scripts and Tips<<
User: ROVSCADAENGINEER, originally posted: 2019-07-14 23:30:15 Id:470
Does ClearScada allow an option that opens up or previews an EXCEL worksheet that can be displayed to operators?

For example a mimic page which is a display of an excel worksheet saved locally on the drive.

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
354

Re: [Imported] Excel Work sheets in SCADA

>>Responses imported from previous forum


Reply From User: adamwoodland, posted: 2019-07-15 00:25:51
Sure. Depends how fancy you want to be. Assuming you have Excel installed on the operator machine then the simplest way would be to configure a pick action to run a system command, pointing to Excel and the file to open, e.g.:

"C:\\Program Files (x86)\\Microsoft Office\oot\\Office16\\excel.exe" "Whatever.xlsx"

If you want it dynamic you can do it via animations or call it from some mimic script.

This opens up Excel, if you want to open in up within ViewX then you may need to save it as a HTML file, stick it on some webserver and just open that.


Reply From User: BevanWeiss, posted: 2019-07-15 12:32:05
If ViewX supported a nested WebKit instance it would be possible to launch some Google Calc thing too 👅
I really wish WebKit (or other HTML5 browser) stuff was exposed from ViewX. It's obviously using something for the GIS integration in the newer versions, but we still need to use dodgy script hacks to launch IExplore.exe to popup a webbrowser..