Ask our Experts
Didn't find what you are looking for? Ask our experts!
Launch of Consumer/Home Owner registration process! We are pleased to announce the commencement of the Consumer/Home Owner Registration Process on Community. Consumers/Home Owners may now proceed to register by clicking on Login/Register. The process is straightforward and designed to be completed in just a few steps.
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Search in
Link copied. Please paste this link to share this article on your social media post.
Posted: 2019-11-06 11:08 PM . Last Modified: 2023-05-03 12:24 AM
>>Message imported from previous forum - Category:General Items<<
User: andrew, originally posted: 2019-05-29 14:49:31 Id:438
Good morning, I have been tasked with creating a scheduled task (windows task scheduler) to automatically write data to an excel sheet on a file server every hour. Normally I would write a sql query in excel to pull this in but that has to be refreshed manually. does any know a good way to do this?
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2019-11-06 11:08 PM
>>Responses imported from previous forum
Reply From User: adamwoodland, posted: 2019-05-29 20:09:31
Bit of VBScript using the older COM ClearSCADA automation interface, and then using the relevant COM Excel objects if they still exist, should do the trick.
Alternatively you could use the SQL Export driver the generate the data once an hour and then some Excel magic to import them, for example on Excel load.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2019-11-06 11:08 PM
>>Responses imported from previous forum
Reply From User: adamwoodland, posted: 2019-05-29 20:09:31
Bit of VBScript using the older COM ClearSCADA automation interface, and then using the relevant COM Excel objects if they still exist, should do the trick.
Alternatively you could use the SQL Export driver the generate the data once an hour and then some Excel magic to import them, for example on Excel load.
Link copied. Please paste this link to share this article on your social media post.
You’ve reached the end of your document
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.