Forum Discussion

JulesHan's avatar
JulesHan
Frequent Visitor
2 years ago

Unzip XLS file from Oracle in Power Query

Dears,    I'm struggling for a while with this one. I already watched numerous youtube videos and read multiple blogs but nothing worked so I hope someone can help me with this.   I would li...
Need Help
Show and Tell
Tips and Tricks
JulesHan's avatar
JulesHan
Frequent Visitor
2 years ago

If I check the properties of these files it says excel workbook:

 

lbendlin's avatar
lbendlin
Super User
2 years ago

Yet Excel complains - do you have a HEX editor that you could use to peek at the bytes?

  • JulesHan's avatar
    JulesHan
    Frequent Visitor
    2 years ago

    Hi Ibendlin,

     

    Unfortunately not. I hoped we would be able to solve this using the unzip formula in Power Query.

     

    Kr,

    Julie