Excel.Workbook

[smpa01]

Hi,

I have performed Excel.Workbook on a folder with a single excel file. However, whenever I expand Table to get the data I see 3 files which should not be the case. Because the Folder contains only one excel file. Why does it happen. Because of this my data gets duplicated on the query window.

How can I prevent it from happening.

Thank you in advance

[Anonymous]

Hi @smpa01, if I understand, you are duplicating your data on line two of your advanced editor. Remove the third and fourth lines, remove the last comma on your second line and the last line replace: #"Expanded Custom" by Source.

let
  Source = Folder.Files("C:\Users\  \Documents\PO Upload Automation\ OLD PO RESQUEST FORMAT")
in
  Source

Hope it helps!

[smpa01]

Thanks for the response. I can't work out what you suggested - I understand, you are duplicating your data on line two of your advanced editor. Remove the third and fourth lines, remove the last comma on your second line and the last line replace: #"Expanded Custom".

Can you please write the complete code.

[Anonymous]

@smpa01, I have already written the code. 

Remove all the lines and just put it on your editor.

let
  Source = Folder.Files("C:\Users\  \Documents\PO Upload Automation\ OLD PO RESQUEST FORMAT")
in
  Source

 What is the output?

[smpa01]

This does not help me get to the data which the excel contains.

I think Excel.Workbook is the code to specify the path for the folder contents which I used to get to the data.

[Anonymous · Accepted solution]

I'm sorry, yes, I did not realized it, please remove all the lines on your editor and put it:

let
    Source = Excel.Workbook(File.Contents("C:\Users\ \Documents\PO Upload Automation\ OLD PO RESQUEST FORMAT\PO Request Landscaping 2017 - Ontario1.xlsx"), null, true)
in
    Source

 Please, check if the path and the file name is correct.

[smpa01]

It Works !!! 🙂