Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

=Excel.CurrentWorkbook()

How work this function? =Excel.CurrentWorkbook()  Which is current workbook? I always got emtpy fields Do i need specify any workbook name and path? Do it take everithing from Activeworkbook?
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Analitika Probably a good question for ImkeF , edhans  and HotChilli 

 

My Excel queries generally look like this though:

let
    Source = Excel.Workbook(File.Contents("C:\Users\gdeckler\Downloads\ItemUnit.xlsx"), null, true),
    Ancilliary_Table = Source{[Item="Ancilliary",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Ancilliary_Table,{{"Item no", Int64.Type}, {"Product Description", type text}, {"Qty", Int64.Type}, {"Sale", type text}, {"Attribute.1", type text}, {"Value", type any}})
in
    #"Changed Type"