Forum Discussion
Problem with Gateway - SharePoint
Hi AndrejZitnay ,
Actually, if you select Combine Edit and it will go the view below then you could select the file you want.
In addition, for your scenario, you could click Binary and then you will see the sheets in the excel file and then if you click table, it will show with table format.
Hope this is clear for you!
Best Regards,
Cherry
Hello v-piga-msft ,
Many thanks for your help.
Microsoft Account did help. I am almost there.
I just don't know how to open my exact excel file. I have tried combine, edit & Load but I can't get what I need.
It end up in query in binnary form. How I can transfer 3rd line to table layout wiht all my variables?
I know how to remove first 2 row but don't know how transfer 3rd to table layout.
Would you be so kind and hlep with that?
Hopefully I will be able to set up getaway once this will be properly linked to SharePoint.
Many thanks in advance.
Kind regards.
Andrej
Hi AndrejZitnay ,
Actually, if you select Combine Edit and it will go the view below then you could select the file you want.
In addition, for your scenario, you could click Binary and then you will see the sheets in the excel file and then if you click table, it will show with table format.
Hope this is clear for you!
Best Regards,
Cherry