Excel Web Query through Powershell?

Not sure if this is possible. However, in Excel you can do a Web Query to import Data. Does anyone know if there is a way to automate this? For Example….

The Url I am importing through Excel is http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_pshmonprod2?p_beg_date=2018&p_parish_code=04

I just want to change the parish code to the next number in a while loop which is easy, just not sure how to run the Import Data Web Query through Powershell and then import them all into a sheet.

submitted by /u/the_jons3y
[link] [comments]

Leave a Reply