3

In my line of work, I have to use an add-on to Excel in order to extract data from multiple instruments. I'm a chemical engineer in a chemical plant, so think thousands and thousands of inputs, all stored every 5 seconds.

This add-on runs only in the desktop version of Excel, and wont run if I try to run it in the online version of Excel.

Due to budget and team constraints, it's not possible to have an SQL server where this data is copied, and accessed.

I'd like to run a power automate flow to open an Excel file in the desktop app, update all calculations and data links, save and close the file. Then, with the file in my team's Sharepoint, I'll be able to update our KPIs and dashboards automatically.

Any of you have some idea? I'm at a loss.

Thanks

Improve this question
4
  • Yeah, use UiPath or PowerAutomate Desktop. Computer Use is the latest development from MS in that regard. theverge.com/news/649574/… learn.microsoft.com/en-us/microsoft-copilot-studio/computer-use Commented Oct 24 at 19:14
  • I’ll try this out next week and update here. Thanks Commented Oct 24 at 20:36
  • Hi @LordPaylor Out of curiosity, could you explain how data is retrieved from the instruments in the first place? Are you using industrial protocols? Thank you. Commented Oct 27 at 16:35
  • 1
    @Michalis we're using industrial protocols indeed. The data is stored in an Honeywell system (we have an Honeywell DCS). I'm not too familiar with all the details since we have a whole department in charge of it. Commented Oct 28 at 20:35
Related questions
2
Add Item to Sharepoint list with Power Automate Desktop
0
Power Automate: Extract info from excel file into sharepoint list, then save excel file as attachment?
0
Update Sharepoint-List with with excel-file using power automate
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.