Power query and web serwer device - grabbing and automatically archived

teo39

New Member
Joined
Jun 26, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Hello everyone!

I would like to create or use a ready-made tool to get data from a device that has a web server in HTML form. These data are variable (measurement results) and I need the tool to automatically refresh cyclic queries to this web server. All these readings I would need to be automatically archived (say every 10 minutes) with the possibility of exporting to MS Excell sheets.

environment: enthernet ( tcp ip ) fixed device IP address, widnows 10 pro

I have tried with ms excell using Power Query but it does not recognize properly all readings from web server.
The problem is mainly with Date and Time which Power Query does not see at all and I have to use the old way which is Web Query, only then I can extract date and time to ms excell.

1.
The problem is that it downloads the data for date and time to a single cell and I need in separate cells.

2.
Another problem I don't really know how to handle history.
Web server itself does not have functionality of storing values of measurement variables.
But the measurements are updated in the excell sheet ( every 1 min I have set) and I would have to copy them automatically e.g. to another sheet as a list.
I do not know how to automate this in the best way, please help
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,491
Messages
5,831,998
Members
430,103
Latest member
BIGGAZ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top