Excel Power Query: Parameter value from certain cell

Question

I have this power query (it works):

(INGCODE) => 

let
    Origine = Web.Page(Web.Contents("https://website/ProductDetails.aspx?id=IT01@@7000@@10@@"&(INGCODE))),
    #"Mantenute prime righe" = Table.FirstN(Origine,1),
    #"Rimosse altre colonne" = Table.SelectColumns(#"Mantenute prime righe",{"Caption"})
in
    #"Rimosse altre colonne"

The questions are:

Can I use a cell value for the "INGCODE" parameter?
Can I put the result of the power query in a determined cell?

For your first question, see this: stackoverflow.com/questions/26989279/… — Alexis Olson
– Alexis Olson, Commented Feb 21, 2018 at 19:51

Mike Honey · Accepted Answer · 2018-02-23 21:40:59Z

5

For 1 - As per Alexis' comment, you need to first define a named range using Excel for your "cell value". Then the syntax is:

Excel.CurrentWorkbook(){[Name=rangeName]}[Content]{0}[Column1]

(where rangeName is your named range).

For 2 - Right-click the query in the Workbook Queries pane and choose Load To ... Then under "Select where the data should be loaded to" choose a specific worksheet and cell.

answered Feb 23, 2018 at 21:40

Mike Honey

15.2k1 gold badge29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TylerH Over a year ago

Is the solution for doing step 1 with an External Source (SharePoint.Files...) similar enough to edit into the answer here (if you know it) or do you think it'd be worth asking as a separate question?

Collectives™ on Stack Overflow

Excel Power Query: Parameter value from certain cell

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related